Extracting Information from Complicated Excel Spreadsheet into Access
£20-250 GBP
Paid on delivery
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.
Project ID: #15573120
About the project
Awarded to:
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
34 freelancers are bidding on average £150 for this job
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
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
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
!!!Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss.................................. Stay tuned, I'm still working on this proposal.
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
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.
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
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...!
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
Hello I can help you out in your work as per your requirements. Kindly ping me for more details. Thank u
I'm expert on excel. Relevant Skills and Experience I've 4 years experience. Proposed Milestones £222 GBP - Beginging I want to discuss with you.
