Extracting Information from Complicated Excel Spreadsheet into Access

Виконано Опубліковано %project.relative_time Оплачується при отриманні

£20-250 GBP

Оплачується при отриманні

Виконано Оплачується при отриманні

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.

Excel Microsoft Access Visual Basic Visual Basic для додатків

ID Проекту: #15573120

Про проект

34 заявок(-ки) Дистанційний проект Остання активність 6 роки(ів) тому

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та часові рамки

Отримайте плату за вашу роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручено:

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 Більше

£220 GBP за 5 дні(-в)

(283 відгуків(-и))

7.7

34 фрілансерів(-и) готові виконати цю роботу у середньому за £150

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 Більше

£100 GBP за 3 дні(-в)

(327 відгуків(и))

7.9

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 Більше

£100 GBP за 2 дні(-в)

(331 відгуків(и))

8.0

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 Більше

£250 GBP за 5 дні(-в)

(130 відгуків(и))

7.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 за 3 дні(-в)

(77 відгуків(и))

6.5

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. Більше

£373 GBP за 3 дні(-в)

(54 відгуків(и))

6.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 Більше

£250 GBP за 2 дні(-в)

(54 відгуків(и))

6.1

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 Більше

£88 GBP за 3 дні(-в)

(39 відгуків(и))

5.7

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 за 1 день

(13 відгуків(и))

5.2

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 Більше

£222 GBP за 5 дні(-в)

(30 відгуків(и))

5.1

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 за 1 день

(17 відгуків(и))

4.8

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 Більше

£200 GBP за 3 дні(-в)

(27 відгуків(и))

5.0

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 Більше

£70 GBP за 3 дні(-в)

(34 відгуків(и))

4.7

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 Більше

£205 GBP за 5 дні(-в)

(10 відгуків(и))

4.0

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 Більше

£150 GBP за 3 дні(-в)

(6 відгуків(и))

3.3

andinfini

Hello, I hope you are well. With my 10 years of experience in web and office (web search, development and scraping). I would like to postulate my candidacy for your project. Expérience et Compétences appropriées - Dev Більше

£44 GBP за 3 дні(-в)

(3 відгуків(и))

1.2

shafeekmohamed

I can do the project perfectly, If you want perfect project please contact me.

£23 GBP за 1 день

(1 відгук)

1.0

lux666

Hello I can help you out in your work as per your requirements. Kindly ping me for more details. Thank u

£222 GBP за 1 день

(0 відгуків(и))

0.0

Ola206

A proposal has not yet been provided

£222 GBP за 3 дні(-в)

(0 відгуків(и))

0.0

bhardwajprince47

A proposal has not yet been provided

£100 GBP за 10 дні(-в)

(0 відгуків(и))

0.0

dhrubotara92

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.

£222 GBP за 5 дні(-в)

(0 відгуків(и))

0.0

Опублікувати схожий проект

Extracting Information from Complicated Excel Spreadsheet into Access

Про проект

Хочете заробити?

Переваги подання заявок на Freelancer

Доручено:

34 фрілансерів(-и) готові виконати цю роботу у середньому за £150

Freelancer

Огляд

Умови

Додатки