Excel VBA Macro- Locking cells after data entry

$10-30 USD

Imekamilika

Imechapishwa

almost 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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

Kitambulisho cha mradi: 19772603

Kuhusu mradi

11 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@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 ndani ya siku 1

5.0

(84 hakiki)

5.3

11 wafanyakazi huru wana zabuni kwa wastani $20 USD kwa kazi hii

@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 ndani ya siku 1

5.0

(23 hakiki)

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 experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

$25 USD ndani ya siku 0

5.0

(25 hakiki)

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 forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$20 USD ndani ya siku 7

4.8

(3 hakiki)

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 through your requirements and I can help you on this project. I am looking forward for positive response. Regards, Neha C

$30 USD ndani ya siku 1

0.0

(0 hakiki)

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 also be done for locking of the cells once selected. Kindly allocate the project so that we can start the work. Thank you.

$20 USD ndani ya siku 1