Completed

Extracting Information from Complicated Excel Spreadsheet into Access

This is part of a much larger project. We have a spreadsheet which is very complex which has been hard coded and has lots of lookups, formulas and macros. We cannot recreate the formulas so are looking for the access database to open the spreadhseet, inject in the infromation required and extract the information output (this is essentially done on just two sheets).

The problems:

1. In order for the spreadsheet to operate there are various buttons and macros that need to be activated in order for it to work (we cannot modify the excel spreadsheet as its used elsewhere in the company).

2. Some of the inputs are drop downboxes and dont setect the text if its typed.

Attached is a word document explaining what buttons need to be clicked in order to get the spreadsheet working. What we need is a very basic Access interface which basically recreates Item 1 - 12 on the "laminate input details tab" (rest of sheet isn't required). When these inputs have been input via the access form it calls up the spreadsheet in the background, injects the information and then extracts all of the outputs provided in the "Refurb Quote" tab.

We need this to be done quite quickly.

Skills: Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

See more: import excel into access 2010, exporting data from excel to access using vba, import excel into access 2013, excel to access converter online, convert excel spreadsheet to access database 2010, copy excel data into access, import data from excel to access vba, convert excel spreadsheet to access database 2013, import data excel spreadsheet access table, enter business cards information excel spreadsheet template, enter business cards information excel spreadsheet, complicated excel spreadsheet ipad, website information excel spreadsheet, modify excel spreadsheet access data, excel spreadsheet missing information, excel spreadsheet information missing, vbscript import excel spreadsheet access, combine information excel spreadsheet, can copy website address information excel spreadsheet, contact information excel spreadsheet

About the Employer:
( 86 reviews ) Norwich, United Kingdom

Project ID: #15573120

Awarded to:

bouslimi1979

Hi, can you please send the Word document. I ll code a VBA macro to simulate all these steps and interact with Access. Also do you already have an Access Databse/App ? Thanks Expérience et Compétences appropriées V More

£220 GBP in 5 days
(185 Reviews)
7.2

35 freelancers are bidding on average £151 for this job

schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience More

£100 GBP in 2 days
(218 Reviews)
7.2
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can Extract Information from Complicated Excel Spreadsheet into Access. Relevant Skills and Exp More

£100 GBP in 3 days
(220 Reviews)
7.4
wsh2

Rush Job! Highly experienced (25+years) ACCESS/EXCEL/VBA Programming Expert with excellent complex workbook TROUBLESHOOTING and DEBUGGING competence. Strong DATA INTEGRATION, Reporting, and USER INTERFACE skills. More

£373 GBP in 3 days
(53 Reviews)
6.5
kolosibalint

Hi, I would be interested in your project but unfortunately it seems the doc file has not been uploaded. Can you send it directly? Relevant Skills and Experience During my years of Excel VBA developer I created More

£250 GBP in 5 days
(90 Reviews)
6.2
£250 GBP in 3 days
(13 Reviews)
6.3
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc More

£20 GBP in 1 day
(59 Reviews)
5.6
£150 GBP in 3 days
(28 Reviews)
5.8
£105 GBP in 3 days
(42 Reviews)
5.5
zu02

Hi, I can do that automation(Access/Excel) maximum 2 days , but if you can pay your max range(i.e. 250 ) than during a day/if need I'll work full night. Thanks. Access/Excl automation is one of my fav Relevant Skills More

£250 GBP in 2 days
(44 Reviews)
6.0
oadsmedia

!!!Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss.................................. Stay tuned, I'm still working on this proposal.

£200 GBP in 3 days
(48 Reviews)
5.7
narsim3128

I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects Relevant Skills and Experience Ms-Access Excel(Advanced) VBA More

£88 GBP in 3 days
(33 Reviews)
4.9
kahilH

Hello I propose to implement a script that reads the excel worksheets in java using some dedicated apis I am using my phone no i coudlnt see the word document I invite you to discuss more in chat Relevant Skills an More

£200 GBP in 3 days
(19 Reviews)
4.5
adilsyed123

Hey, I'm interested in your project. Please send me a message so that we can discuss more. I can do trial work before hire me sir , will wait for your reply, Thanks, Syed Relevant Skills and Experience Excel, Micros More

£70 GBP in 3 days
(29 Reviews)
4.3
chintuag

I have read the project description and would like to discuss it further for a complete understanding. I'm interested to work on your project Relevant Skills and Experience I have experience in VBA and Access and coul More

£205 GBP in 5 days
(8 Reviews)
3.9
vmadhavan15

There seems no word doc instead of that I could see Excel Macro file as Calculator (which I think you are mentioning) I hope I can do this one but I am not yet more clear about the work just few. Relevant Skills and E More

£222 GBP in 5 days
(9 Reviews)
3.8
liangjongai

Hi, sir I have a detail look to your project, I have a great skill in excel and vba. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Thanks.

£150 GBP in 1 day
(5 Reviews)
3.8
anzarulislam

Hello... I'm highly skilled in this categories jobs. You can check my profile. You can trust me on this project. I'll complete this project to your satisfied payment. I'm waiting for your response...!

£50 GBP in 1 day
(7 Reviews)
3.9
hunmin888

A proposal has not yet been provided

£166 GBP in 2 days
(9 Reviews)
3.9
ufoteam

Why? Why? why don't you award the project to me ?I really want to get this project. If you can, please contact me and let me know how much your budget is, and I'll try my best to offer you the best price.I will do my b More

£150 GBP in 3 days
(6 Reviews)
3.3
£150 GBP in 3 days
(3 Reviews)
2.8