Excel VBA Macro- Locking cells after data entry

Completed Posted 4 years ago Paid on delivery
Completed 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

Excel Excel VBA

Project ID: #19772603

About the project

11 proposals Remote project Active 4 years ago

Awarded to:

nvchien94

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.

$25 USD in 1 day
(84 Reviews)
5.3

11 freelancers are bidding on average $20 for this job

UmarMahmood

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.

$15 USD in 1 day
(23 Reviews)
4.3
paulodayto08

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

$25 USD in 0 days
(25 Reviews)
3.7
bluesea1990

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

$20 USD in 7 days
(3 Reviews)
2.7
nehachaudhari189

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

$30 USD in 1 day
(0 Reviews)
0.0
EDSRD

Hi, We have gone through the file and we would be able to get the work done for you. We can introduce a dropdown in column J for all the rows to select either Accepted or Rejected and rest of the functionalities can al More

$20 USD in 1 day
(0 Reviews)
0.0
rojesh1234

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..

$25 USD in 0 days
(0 Reviews)
0.0
aachi2295

I will work properly and take all responsibility

$25 USD in 1 day
(0 Reviews)
0.0
Taurusrex01

I need the VBA experience, so I am going to try my hand at it regardless of being paid / accepted

$10 USD in 5 days
(0 Reviews)
0.0