rschmidt46
New Member
- Joined
- Aug 24, 2015
- Messages
- 46
- Office Version
- 2010
- Platform
- Windows
One tab of a spreadsheet contains about 3,000 formulae that reference data in another tab in the workbook. The name of the referenced tab changes on a weekly basis when it is refreshed and then it reflects the new date in the form of "YYYY-MM-DD"). The referenced tab currently is named "All Volunteer MASTER 2022-08-05". The tab that refers TO this tab is named "Members by Voice Part". Is there a way to mass update the formulae with VBA in the "Members by Voice Part" tab such that every formula referencing "All Volunteer MASTER 2022-08-05" would be changed to reference "All Volunteer MASTER 2022-08-12"? Hard-coding all the formulae would be a formidable task! I have not tried anything yet, in hopes that I'll start out on the right foot with input/advice from some of you Excel VBA experts out there. A typical formula is copied below.
='All Volunteer MASTER 2022-08-05'!A2 & ", " & 'All Volunteer MASTER 2022-08-05'!B2 |