Adapting simple user interface in excel and macro to copy data between files
£20-250 GBP
Pagado a la entrega
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.
Nº del proyecto: #4844302
Sobre el proyecto
19 freelancers están ofertando un promedio de £131 por este trabajo
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 can do the job, just send me the file and let discuss some details via skype Regards Diego
Hi Aidan, UK-based excel specialist here. I can provide what you need - please check your PM for more details, thanks.
HELLO SIR, I AM IN PROGRAMMING SINCE 2001, I AM MICROSOFT CERTIFIED, YOU CAN READ MORE ABOUT ME AT: EGYPT-PROGRAMMERS (COM) I AM VERY READY AND INTERESTED IN YOUR PROJECT READY TO SUPPORT FOR LONG TIME, Más
Hi Aidan, Many thanks for your comprehensive brief - it's quite a breath of fresh air! The GUI looks like a UserForm from your screenshots, which are fairly straightforward to modify. I should be able to get somethi Más
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
GMI Group has experts in Excel VBA development that would appreciate your consideration. Turnaround time estimated at (1) day.
Hi, I have many experience in VBA. I have created a Coffe billing system using Excel + VBA. Please give this work for me, I'll do the best. Thanks.
Having good exposure on Excel/Access VBA Macros,I will do this.. Please add me in your project basket.
