Summarizing data on one main sheet
Hello,
I have one workbook which is considered a template to workbooks that input data into daily and save it based on the current date. For example WorkbookA040106, Workbook2040206, etc. The workbooks are added daily based on the current date. I would like for one main spreadsheet to give me the sum totals of the data that is input into each saved workbook daily whenever a new file is added. Is this possible to do? If I saved each individual workbook into a folder is there a formula or a macro that can be created that would look for a new file and add the data for each workbook in the folder to themain workbook when ever a new file is created? This would be done once a month. These files would need to remain in the folder for individual data results but I also need month to date data results |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com