Closed

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
Employer working
Skills Required
Project Budget
£20 - £250 GBP
Total Bids
23
Project Description

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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online