Excel VBA Macro- Locking cells after data entry

Slutfört Publicerat 4 år sedan Betalades vid leverans

$10-30 USD

Betalades vid leverans

Slutfört Betalades vid leverans

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

Projekt-id: #19772603

About the project

11 offerter Distansprojekt Aktivt 4 år sedan

Skulle du vilja tjäna pengar?

Fördelar med att lägga anbud på Freelancer

Ställ in budget och tidsram
Få betalt för ditt arbete
Skissa på ditt förslag
Det är gratis att registrera sig och lägga bud på jobb

Tilldelades:

nvchien94s Profilbild
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 inom 1 dag
(84 omdömen)
5.3

11 frilansare har lagt bud på i genomsnitt $20 för det här jobbet

UmarMahmoods Profilbild
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 inom 1 dag
(23 omdömen)
4.3
paulodayto08s Profilbild
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 Mer

$25 USD inom 0 dagar
(25 omdömen)
3.7
bluesea1990s Profilbild
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 Mer

$20 USD inom 7 dagar
(3 omdömen)
2.7
nehachaudhari189s Profilbild
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 Mer

$30 USD inom 1 dag
(0 omdömen)
0.0
EDSRDs Profilbild
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 Mer

$20 USD inom 1 dag
(0 omdömen)
0.0
rojesh1234s Profilbild
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 inom 0 dagar
(0 omdömen)
0.0
aachi2295s Profilbild
aachi2295

I will work properly and take all responsibility

$25 USD inom 1 dag
(0 omdömen)
0.0
Taurusrex01s Profilbild
Taurusrex01

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

$10 USD inom 5 dagar
(0 omdömen)
0.0
Lägg upp ett liknande projekt