TedX
Board Regular
- Joined
- Apr 18, 2021
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I'd like to create a macro, but I am not sure how to go about it. I have a workbook that I update every day which creates some new worksheets and corresponding new connections. Please see the image below. After I have taken a copy of the relevant data, I have to delete the worksheets and Connections each day manually. The worksheets always have 'Append1', whilst the other worksheets I don't need all follow the naming convention of 'Table 5' as an example. I never know how many tables there will be, each day is different, but they are all variations of the word Table a space and a number. It's the same with the connections. Can anyone create the VBA code for this macro for me please?
I'd like to create a macro, but I am not sure how to go about it. I have a workbook that I update every day which creates some new worksheets and corresponding new connections. Please see the image below. After I have taken a copy of the relevant data, I have to delete the worksheets and Connections each day manually. The worksheets always have 'Append1', whilst the other worksheets I don't need all follow the naming convention of 'Table 5' as an example. I never know how many tables there will be, each day is different, but they are all variations of the word Table a space and a number. It's the same with the connections. Can anyone create the VBA code for this macro for me please?