Excel Spreadsheet/Database Customization

I am looking to have an Excel spreadsheet modified/programmed. We have used a single Excel file for >20 years as our database to track treatment and outcome of patients. It currently has 5700+ rows with 43 columns of data per row. We would like to modify the spreadsheet so that is it more efficient to enter data into each of the columns by using dropdown menus for many of the columns. There are also some columns that need to be modified such that an entry into one would prevent an entry into another one. We are hoping to make the data entry process less error-prone. We would also like to be able to query the spreadsheet without having to use separate database software. Currently, we go through the onerous process of filtering columns to get lists of patients with particular characteristics from which we can analyze the data. Ideally, we'd like to have our current Excel file modified with VBA so that it can stay within the same Excel file.

Skills: Database Administration, Excel

See more: business card database spreadsheet excel, wikipedia spreadsheet excel, making address contact info spreadsheet excel, example weighted criteria spreadsheet excel, bowling tournament spreadsheet excel, copying pasting excel spreadsheet excel spreadsheet, bank statement spreadsheet excel, database error 1146 query user doesnt exist, copy paste spreadsheet excel websites, phplist users database error 1064 query error, copy excel spreadsheet excel spreadsheet, database error 1146 query, database error 1146 query table phplist, copy pdf spreadsheet excel, database error 1064 query phplist, phplist error database error 1064 query, database error 1146 query table doesnt exist, database error 1146 query table user doesnt exist, database error 1146 query table doesnt exist phplist, copy spreadsheet excel, phplist database error 1146 query table, phplist database error 1146 query table doesnt exist, evaluation spreadsheet excel, database error 1146 query table, copy browser spreadsheet excel code

About the Employer:
( 4 reviews ) New York, United States

Project ID: #14377916

Awarded to:


Hey There, We can built user form for this. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can d More

$45 USD in 2 days
(140 Reviews)

69 freelancers are bidding on average $130 for this job


Hello Sir, I have knowledge of managing Patient's database as I have worked on similar projects. My name is Jay and I am #1 Excel VBA programming expert on and have been featured by the freelancer com More

$150 USD in 2 days
(536 Reviews)

Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with f More

$100 USD in 2 days
(613 Reviews)

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the informatio More

$150 USD in 3 days
(231 Reviews)

Hello, I am ready to modify your current VBA excel sheet. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft More

$150 USD in 3 days
(137 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$150 USD in 3 days
(211 Reviews)

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, More

$250 USD in 5 days
(159 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$150 USD in 3 days
(177 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 3 days
(220 Reviews)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet filled with VBA and drop-down menus. I have 7 years’ experience designing and developing Excel spreadsheets fi More

$140 USD in 3 days
(116 Reviews)

Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project, making y More

$150 USD in 3 days
(60 Reviews)

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further discus More

$100 USD in 2 days
(230 Reviews)

At your earliest convenience, could you please attach a copy of your "well tried and true" workbook(s) to this private message thread and send, so we may better analyze and discuss your requirement. Thank you in advanc More

$222 USD in 3 days
(29 Reviews)
$250 USD in 5 days
(30 Reviews)
$48 USD in 1 day
(58 Reviews)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$155 USD in 3 days
(62 Reviews)

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details More

$98 USD in 3 days
(62 Reviews)

Dear Sir, Greetings. The purpose is to develop the spreadsheet that it covers most automation. Key Points: 1. Reduce the entry to the lowest level [url removed, login to view] populate other fields data when user select option from More

$127 USD in 2 days
(93 Reviews)

It is really good idea to modify your existing excel database with VBA. I recommend you allow me develop User Form where you can easily view you data, enter new data, make analysis, easily search with different paramet More

$155 USD in 3 days
(33 Reviews)

we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.

$60 USD in 1 day
(34 Reviews)

I have a lot of practical experience in Excel. Including the development of databases and User Forms. Your task is clear to me and I am ready to execute the project for the 80 USD. For example, I send a screen of one o More

$80 USD in 2 days
(42 Reviews)