Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have a sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my master data sheet (Sheet1) every week containing data in a similar manner, but with new numbers.
I would like to know, if I do this and I integrate the upcoming sheets (which will be named Sheet1 (2), Sheet1 (3) and so on unless I decide to manually rename them), is there any kind of formula/VBA code/macro that I can use, so the data automatically gets thrown into my pivot table?
I would truly appreciate some assistance here! Whichever solution can make this run as automatically as possible would be amazing
Thank you very much everybody!!
Kind regards,
Jyggalag
I currently have a sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my master data sheet (Sheet1) every week containing data in a similar manner, but with new numbers.
I would like to know, if I do this and I integrate the upcoming sheets (which will be named Sheet1 (2), Sheet1 (3) and so on unless I decide to manually rename them), is there any kind of formula/VBA code/macro that I can use, so the data automatically gets thrown into my pivot table?
I would truly appreciate some assistance here! Whichever solution can make this run as automatically as possible would be amazing
Thank you very much everybody!!
Kind regards,
Jyggalag