Adapting simple user interface in excel and macro to copy data between files
This project received 23 bids from talented freelancers with an average bid price of £129 GBP.Get free quotes for a project like this
Project Budget£20 - £250 GBP
We have an excel workbook that has a GUI to enter / update values in a number of sheets. We would like to use the same user interface in a different workbook that is structured in exactly the same way, and therefore need the existing GUI and associated macros to be modified to work with the other workbook. The following would need to be modified.
The GUI in a master file (in excel 2010)
An identical GUI that is used in a standalone version in excel 2003
A macro that copies the values from the standalone GUI to the master file
The GUI / macros have been created and only need to be adapted to work with the other workbook.
The GUI consists of 9 screens (10 for the adapted version), that each contain 4-8 tabs. Each screen corresponds to a sheet in excel. Each tab consists of 6 (2 in the new version) static fields that need to be read from excel sheets and 5 dynamic field that read / write to cells in excel.
The stand alone GUI (in excel 2003, so it can be used on different platforms) is identical, and additionally includes a function to have the file expire after a certain date and a protected macro to hide / unhide sheets to protect the content.
The import macro copies the (dynamic) fields from the stand alone GUI to the master file.
All GUI components / macros have been created and only need to be adapted to work in the other workbook. There are some screenshots in the attachment.
The deadline for the project (including testing and bug-fixing if required) is 3 September.
Browse Related Skills
- Need email list of Marijuana Dispensaries throughout the USA.
- Portuguese (Brazilian) Data entry - Run searches online and fill in Excel sheet
- Web Scraping needed and put into excell and TXT
- Find correlations in data - people of a given role in a company and size or sales or number of employees of that company
- Mail Merge expert needed
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online