Awarded

Adapting simple user interface in excel and macro to copy data between files

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.

Skills: Excel, Visual Basic for Apps

See more: update macro gui excel, excel data update, simple excel macros, testing user, static interface, master excel 2010, master excel, visual interface, user interface/, to copy, testing and bug fixing, simple macro, excel master file with macros, dynamic interface, data structured, excel 2013 version, write macro, 2013 visual basic applications excel, macros excel basic, update existing macro excel, excel workbook stand alone, excel macro read data files, read write update, import data macro excel, macro 2013 2010

About the Employer:
( 3 reviews ) Winchester, United Kingdom

Project ID: #4844302

21 freelancers are bidding on average £136 for this job

Teloquence

Consider it done. Check your PM for my bid details.

£210 GBP in 3 days
(294 Reviews)
7.5
jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

£177 GBP in 3 days
(211 Reviews)
7.0
wsh2

Highly skilled [20+ years] MsExcel programming expert. [10+ years] VBA programming Expert / Mentor at [url removed, login to view] and www.experts-exchange.com. CONFIDENTIALITY guaranteed. FAST and ACCURATE work. American English is More

£180 GBP in 8 days
(23 Reviews)
5.7
fabest

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

£167 GBP in 7 days
(28 Reviews)
5.9
diegogarcia0531

Hi, I can do the job, just send me the file and let discuss some details via skype Regards Diego

£222 GBP in 8 days
(18 Reviews)
4.9
Gooroo

Hello Sir! I'm your man for this! Please DO check my reviews and portfolio. IT and Excel Professional and High-school professor. Let me help. Thanks!

£174 GBP in 3 days
(16 Reviews)
4.2
drevak

Hi. I am a professional VBA Developer.

£133 GBP in 5 days
(13 Reviews)
4.4
adim

More than 15 years of experience in VBA.

£166 GBP in 7 days
(9 Reviews)
4.2
Midlander

To let you judge for yourself whether I can update and 'prove' your three codes by your deadline, I am sending an Excel 2010 with a macro that enters and updates values.. Happy to work under a Confidentiality and No More

£100 GBP in 3 days
(11 Reviews)
4.3
rbbahia

HI, please read PM message.

£100 GBP in 3 days
(14 Reviews)
3.5
adaytay

Hi Aidan, UK-based excel specialist here. I can provide what you need - please check your PM for more details, thanks.

£166 GBP in 3 days
(1 Review)
3.4
amrosamaeg

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, More

£166 GBP in 5 days
(5 Reviews)
3.2
iainwatson

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 More

£90 GBP in 4 days
(3 Reviews)
2.5
NhatAnhIT

Please check my pm!

£88 GBP in 3 days
(1 Review)
2.3
warwickf

HI Folks, I am a twenty year programmer and a experience Excel expert. I could complete this project easily and well. Up until now I have been on elance for a year and this is my first freelancer post. Here More

£55 GBP in 3 days
(1 Review)
1.8
mistyhue

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

£111 GBP in 5 days
(3 Reviews)
1.4
GMIGroup

GMI Group has experts in Excel VBA development that would appreciate your consideration. Turnaround time estimated at (1) day.

£75 GBP in 1 day
(1 Review)
1.4
twinklekumar

trust is key

£177 GBP in 7 days
(3 Reviews)
1.1
wldctwildcat

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.

£80 GBP in 1 day
(0 Reviews)
0.0
ravikirankmca

Having good exposure on Excel/Access VBA Macros,I will do this.. Please add me in your project basket.

£111 GBP in 3 days
(0 Reviews)
0.0