Bennettski
New Member
- Joined
- Mar 7, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, I have been searching and tried a few options but cant find an answer.
I have a workbook and have used the Get Data function from Web to grab info. The web info loads 9 new tables into my worksheet in 9 new tabs named Table 0 to 8. From here my VBA uses this info to perform some calculations. This part all works fine.
The issue I have is that I need to change part of the URL each week to get the latest web data into my worksheet and overwrite the current info in the existing tabs. The only way I have been able to do this is to change the source in Power Query editor for all 9 tables which is a super long way around.
I'd like to be able to enter a new updated URL via a dropdown box to change and increment the _Round_1 part each week in the following URL using a dropdown box on sheet 1 of my workbook.
Any help would be greatly appreciated.
Cheers.
I have a workbook and have used the Get Data function from Web to grab info. The web info loads 9 new tables into my worksheet in 9 new tabs named Table 0 to 8. From here my VBA uses this info to perform some calculations. This part all works fine.
The issue I have is that I need to change part of the URL each week to get the latest web data into my worksheet and overwrite the current info in the existing tabs. The only way I have been able to do this is to change the source in Power Query editor for all 9 tables which is a super long way around.
I'd like to be able to enter a new updated URL via a dropdown box to change and increment the _Round_1 part each week in the following URL using a dropdown box on sheet 1 of my workbook.
Power Query:
https://www.topsport.com.au/Sport/Aussie_Rules/AFL_-_Round_1/MatchesAny help would be greatly appreciated.
Cheers.
