There is a requirement to produce a consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook onto the consolidated Daily Sales Summary sheet.
What is needed is an automated facility to open and copy the contents of 10 or more different new daily Excel spreadsheets (each with one sheet) into separate existing sheets in the main report Excel workbook, so that the results of the consolidated DailyReport sheet are updated with new data each day. Once completed the DailyReport sheet is to be copied and emailed to a (parameterised) email address.
15 freelancere byder i gennemsnit $149 på dette job
Hi, I viewed your job description and I can code this. I can code it via Ms Access for 555 AUD within 5 days. The interface will be very friendly, smart and easy to use, Regards, Zura
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivery of project well advance in time.i would like you to give me a chance to showcase my talent.
I have knowledge of the excel macro and do data entry job like this I have read your work specifications I will do your job more efficiently please hire me