englanti (Yhdysvallat), Excel, Microsoft, SQL Job by accelv


I have 2 Excel files - one weekly report (which is an extract from another piece of software containing timesheet data) and one other summary report file.

I would like you to build a macro button that queries data from "Extract", updates values in the "Report" file, and updates a field to indicate the last time the macro was run. Once the core function works, we can add features like;

- check to make sure the function is not run twice on the same data (otherwise we increment values every time someone clicks the Macro)

- check to make sure the Extract file is open and accessible

- save the Summary file prompt with a new name based on the date

I have the 2 files as a template. There are actually 10 different Report files but they all read from the same Extract file, but if it works with 1, it will work with the others - they are identical.

I estimate about 10-12 hours' work but will wait for your confirmation to accept. If you are available to complete the work in the next few days it will be very helpful.


Taidot: englanti (Yhdysvallat), Excel, Microsoft, SQL

Näytä lisää: excel macro add, extract excel files, save excel read, check data excel files, excel macro read data files, excel report macro, work weekly summary, project macro, excel 2013 macro, core data project, excel macro data extract, build timesheet excel, check excel files, add excel macro, macro report, extract data excel files, excel macro open file, extract function excel, macro extract data excel files, excel macro save, excel project timesheet project, extract macro excel, excel timesheet project, can open excel files, excel custom button

Tietoa työnantajasta:
( 5 arvostelua ) Canada

Projektin tunnus: #4268076

Myönnetty käyttäjälle:


Hired by the Employer

$15 USD / tunti
(24 Arvostelua)