In Progress

Lock down fields on an Excel spreadsheet

Excel assistance needed!

I am using an Excel template to upload a spreadsheet into “QuickBooks”. The issue is that certain data fields must be 100% accurate in terms of both spelling & spacing or QuickBooks will create erroneous duplicate accounts. Unfortunately my data entry people make errors that I prefer to prevent.

What I need is to have certain fields “locked down” so only those accounts already established can be entered. This could be done thru some sort of formula or “auto-complete” Here are some examples which better explain my intent

Assume I have the account “Bobby Jones”

Entering “Bob Jones” will create a separate (duplicate account) so if I had a “drop down” where the data entry person could only select from the items already embedded in the template I would be successful.

Thus as soon as the clerk entered the “B” then all entries starting with a “B” come up, upon entering “Bob” only entries with “Bob” would come up. (selection must be made only from those items in the dropdown box) Case sensitivity is not an issue.

My template is a worksheet with say 7 almost identical pages. Each “worksheet page” has 7 fields of which (the same) 2 need to be locked down. (The name of the client, and the name of the cost center to be “charged”) Each locked down “field” has about 150 items. (I would provide the correct “spellings” etc) I will also need to be able to “expand” the template items as new customers or cost centers are eventually added.

Skills: Excel

See more: lock fields excel, lock excel spreadsheet, excel lock fields, lock field excel, lock excel fields, lock excel, excel lock field, excel protect field, locking fields excel, lock fields spreadsheet, lock spreadsheet, protect field excel, lock formulas excel, excel formula lock field, excel spreadsheet field, lock excel entry, lock template excel, lock field spreadsheet, lock excel work, lockdown excel workbook, lock excel drop list, lock drop box excel, better lock excel, lock part formula excel, lock drop field excel

About the Employer:
( 2 reviews ) toronto, Canada

Project ID: #227752

Awarded to:

ashishyahoo

Dear Sir, I am ready for this. Kindly See PMB. Kind Rgds, Ashish

$30 USD in 2 days
(1 Review)
1.6

24 freelancers are bidding on average $51 for this job

svet63

VBA developer since 1997. As I see it, you need some VBA coding to make it work as described. Regards, Svet.

$50 USD in 2 days
(46 Reviews)
6.1
cyberdeveloper

I'm Excel/VBAprogrammer and I'll be glad to do this job.

$40 USD in 3 days
(9 Reviews)
2.6
hiratariq

Please see PM

$50 USD in 2 days
(2 Reviews)
2.4
VitaliyR

Hallo, I can do it FREE for you! The price will be only your review about my work. I'm new in freelancing, but not new in Exel. (Please check PM). Thank you:)

$30 USD in 2 days
(2 Reviews)
1.8
Nitisachdeva

Hi, I am interested in working on this project. I have qualification and experience in excel programming. Pls see PM for details. Rgds

$150 USD in 2 days
(1 Review)
1.1
kmohan1962

Hello; I'm right away ready for a quick turnaround. Regards.

$30 USD in 3 days
(3 Reviews)
0.9
nikhilrao123

Hello, I am a professional data analyst and I constantly use Excel at work. I have implemented several spreadsheets which match your requirements. I can handle this task for you and deliver it in an efficient and tim More

$30 USD in 2 days
(0 Reviews)
0.0
singular

I'm a programmer-analyst specializing in MS Office solutions. As such, I'm an expert in Excel. I can do this work perfectly for you. See you PMB for my message outlining my implementation of your solution.

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

Hello I am new in freelancer but not in excel. So, I can do it [url removed, login to view] see my PM.

$200 USD in 20 days
(0 Reviews)
0.0
diedie

please send [url removed, login to view] you

$40 USD in 2 days
(0 Reviews)
0.0
aarpee

yes,I can do it

$50 USD in 5 days
(0 Reviews)
0.0
vosmerkin

Hi. This should be a macro

$35 USD in 1 day
(0 Reviews)
0.0
shobhitk

See i am excel epxpert, and have solved this type of problems in pasttt..... If u can send me the sample data... can start wrking on it...

$30 USD in 2 days
(0 Reviews)
0.0
vivekvelu

This problem can be solved by developing a small macro (VB coding) in Excel itself (you don't need any other software). I have done some projects like this. If you could send me a sample data (excel file), I co More

$30 USD in 3 days
(0 Reviews)
0.0
kingbill

Sir, I could see your requirement in GAF.com. I 'm interested in the offer. I possess 13+ years experience in office works, especially in finance industry at different levels. Please see my profile and let me k More

$30 USD in 2 days
(0 Reviews)
0.0
sbinfo

Hi Check PM for details Thanks

$50 USD in 2 days
(0 Reviews)
0.0
pbarbas

Can be done in 2 days.

$50 USD in 2 days
(0 Reviews)
0.0
hinamk

Dear Sir/Madam i am very much into it and can do it easily. We will be happy if you'll consider our bid. Cheers...Hina

$100 USD in 0 days
(0 Reviews)
0.0
sivanvega

I can do this with an extra-module to insert the names to be listed in the drop-down list.

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

You are at the right place

$30 USD in 5 days
(0 Reviews)
0.0