muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Sorry, title of this question should read as
Is it possible for a macro to aggregate daily workbooks we get from our bank to a single workbook?
Our bank emails us a daily log of our transactions for our accounts, however rather than looking at the individual 28+ days in workbooks can it all be compiled into a single workbook? This macro would need to pick up any new worksheets that are added daily within a folder. I'm not sure if this matters or not but each file is named "BofA 2021.06.28" and obviously the date changes to each new day within the month.
If we need to keep all the files within a single folder or however it is needed to store to make the macro work, we can adjust where we save the files.
Thanks in advance for your assistance!
Aggregate individual workbooks into a single workbook
and not what it currently isIs it possible for a macro to aggregate daily workbooks we get from our bank to a single workbook?
Our bank emails us a daily log of our transactions for our accounts, however rather than looking at the individual 28+ days in workbooks can it all be compiled into a single workbook? This macro would need to pick up any new worksheets that are added daily within a folder. I'm not sure if this matters or not but each file is named "BofA 2021.06.28" and obviously the date changes to each new day within the month.
If we need to keep all the files within a single folder or however it is needed to store to make the macro work, we can adjust where we save the files.
Thanks in advance for your assistance!