Forum Discussion
Jason McDaniel
Jan 09, 2018Copper Contributor
Summarize data from multiple tabs on another workbook
I have a workbook that is updated and sent to me every day by another company. This workbook contains a new tab that is created for each day with the date as the worksheet name. Each worksheet has ...
Mark Fitzgerald
Jan 10, 2018Iron Contributor
To clarify:
- The file always has the same name?
- New sheets are added for each day?
- Existing sheets are not deleted?
Jason McDaniel
Jan 10, 2018Copper Contributor
Mark,
Yes, the file always has the same name. A new sheet is added each day and existing sheets are not deleted.