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.
21 freelancers are bidding on average £136 for this job
Dear, I am Excel/VBA automation Expert since 11years. I can handle your project right now, Please let me know. I will be available after development, as support. Regards, Fabrice
Hi, I have 5 years of experience in Excel modelling and support. I can help you develop the new Excel model within the deadline. Please refer my PM for more details