Завершено

Excel VBA Macro- Locking cells after data entry

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

Показать больше lock a cell after data entry using vba excel with message box notification before locking, vba lock cells, excel data entry form protected sheet, how to lock or protect cells after data entry or input in google sheet, auto-lock-cells-after-data-entry excel sheets, lock cells after today's date passed excel, how to lock or protect cells after data entry or input in excel?, how to lock cells in excel, excel vba macro paste adjacent column, excel vba paste csv cells, paste excel vba macro, updating excel vba workbooks without changing data, excel vba macro databases, excel vba macro programming bids, script excel spreadsheet macro read cells, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell

О работодателе:
( 15 отзыв(-а, -ов) ) Kottayam, India

ID проекта: #19772603

Поручен:

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 за 1 день
(84 отзывов(-а))
5.3

11 фрилансеров(-а) в среднем готовы выполнить эту работу за $20

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 за 1 день
(23 отзывов(-а))
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 Больше

$25 USD за 0 дней(-я)
(25 отзывов(-а))
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 Больше

$20 USD за 7 дней(-я)
(3 отзывов(-а))
2.7
milindaudichya

Hello, I have just gone through your requirement. I understand your requirement completely and I can do your work and I am able to Start ASAP. Check out my works: Belliza Designer Studio:-[login to view URL] Больше

$15 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
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 Больше

$30 USD за 1 день
(0 отзывов(-а))
0.0
florabelle193007

hi sir i am professional dat entry i am willing to work your project.. hoping for i am the one you choose [login to view URL] you

$10 USD за 2 дней(-я)
(0 отзывов(-а))
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 Больше

$20 USD за 1 день
(0 отзывов(-а))
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 за 0 дней(-я)
(0 отзывов(-а))
0.0
aachi2295

I will work properly and take all responsibility

$25 USD за 1 день
(0 отзывов(-а))
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 за 5 дней(-я)
(0 отзывов(-а))
0.0