A small VBA work. Very urgent. Just 1 hour.
A * Need two options in J8 till end (downwards) - Combobox
B After Selecting any of the above, that particular cell should be locked and can be unlocked and edited only by providing password set by admin
C Column H and I should be locked always. But admin should be able to edit it anytime with password
D Upon selecting Accepted or Rejected on each row, Total Count mentioned on left side should reduce after data entry.
Eg: In this sheet total count is 106, if I select J7 as accepted or rejected, then total count should show 105 and so on.
E Same should be applied to all sheets in this worksheet
See the attachment
11 фрилансеров(-а) в среднем готовы выполнить эту работу за $20
Hello. I can handle almost everything in excel. I am willing to take this job. I ll do the sheet first, you can review and then award the project for payment. Understood t he project requirements and ready to start.