Käynnissä

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

Hello,

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.

Dan

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

Näytä lisää: excel macro add, extract excel files, save excel read, check data excel 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, excel macro save, extract macro excel, excel timesheet project, macro values, macro excel report, extract data excel macro, build excel macro, complete project macro

About the Employer:
( 5 reviews ) Canada

Projektin tunnus: #4268076

Myönnetty käyttäjälle:

Nhcuong

Hired by the Employer

$15 USD / tunti
(24 arvostelua)
4.9