Combine data from excell spreadsheets based on a specific date range
$30-250 USD
Paid on delivery
Attached is a template that will be kept by each employee in a billing office. The spreadsheet will be protected, and data validation is in place for the template. There will be between 5 and 15 separate instances of this template all with different file names. What I need is a spreadsheet that will aggregate the contents of the "productivity" and "hours" tab into a single data set for reporting. I can generate the reports, where I need assistance is pulling the data together from up to 15 separate spreadsheets into one data set.
I need to be able to control the file names, and I need to be able to change file names periodically and our productivity tracking needs change. All files (productivity and the aggregating file) will be in the same directory on a server.
I'm open to an alternate method (please describe), but what I would envision is a spreadsheet that would allow me to list file names (including file location if required) and a macro or VB script goes to the target productivity tracking sheets and generates a data set in a new tab. I would also like to be able to limit the records returned by a date range if possible (e.g. from 1/1/2013 through 1/31/2013 inclusive of the beginning and end dates). I would expect this to be a fairly simple and quick request for a knowledgeable excel resource.
Project ID: #4197767
About the project
Awarded to:
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to More
10 freelancers are bidding on average $141 for this job
Hello, I am offering you to make this job using Excel VBA macro. Please see private message for details.
JOIN US IN OUR ONGOING ONLINE AND OFFLINE TYPING JOBS FROM HOME VISIT http://The Administrator removed this message for containing contact details which breaches our Terms of Service/
This is my first bid here. I have not done such work before. But i am confident i can do it as i have good knowledge of excel
