In Progress

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:
( 2 reviews ) Pittsburgh, United States

Project ID: #14377916

Awarded to:

avinav606lx

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
(125 Reviews)
6.2

70 freelancers are bidding on average $131 for this job

jaylancer43

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 [url removed, login to view] and have been featured by the freelancer com More

$150 USD in 2 days
(477 Reviews)
8.0
cgullapalli

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
(499 Reviews)
7.5
Webxpert4u

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
(121 Reviews)
7.0
schoudhary1553

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
(179 Reviews)
6.9
mirniyazuddin92

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
(188 Reviews)
7.1
cugamelover

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
(151 Reviews)
6.9
P0L

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
(181 Reviews)
6.7
elqueabandona

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
(167 Reviews)
6.6
paris2785

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
(111 Reviews)
6.4
chriskerpini

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
(56 Reviews)
6.3
TonmoyRoy111

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
(191 Reviews)
6.1
MohsanEijaz

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
(52 Reviews)
5.6
nagybatonyi

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
(61 Reviews)
5.7
bdoutsource

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
(89 Reviews)
6.0
wsh2

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
(28 Reviews)
5.8
$48 USD in 1 day
(54 Reviews)
5.8
axiomswb

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
(28 Reviews)
5.4
$250 USD in 5 days
(28 Reviews)
5.1
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$133 USD in 3 days
(47 Reviews)
5.7
osmemon

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
(15 Reviews)
5.1