Excel VBA Macro- Locking cells after data entry
$10-30 USD
Paid on delivery
A small VBA work. Very urgent. Just 1 hour.
A * Need two options in J8 till end (downwards) - Combobox
1. Accepted
2. Rejected
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
Project ID: #19772603
About the project
Awarded to:
Hello there, I am an Excel coder and I can create 1 script do do this task for you. It will take from 30-45 mins so please contact me now. Thank you.
11 freelancers are bidding on average $20 for this job
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.
Hi Good Day! A serious freelancer here. I've done a lot of excel macro work which part of my daily tasks as a Project Management Officer. I can help you with this project. Please consider my bid. With my exper More
Hi. 1. I am an expert in Excel(VBA), Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for f More
I am Neha C. I am a Web Developer and have 5+ experience in VB,ASP.Net,Excel,SQL,Oracle. I have hands on experience on Excel macros and VBA.I like doing challenging work and I always complete my commitments. I gone More
I am good at excel.I always use excel for my projects form my school days so i will complete your work in minimum hours. Thank you..
I need the VBA experience, so I am going to try my hand at it regardless of being paid / accepted