I have linked two excel worksheets together so whatever data I input into worksheet 1, will appear in the proper cells of worksheet 2. Next month, I will receive a new worksheet which will have a new source name.
How do I edit the new source name into worksheet 2 so that I don't have to copy+paste repeatedly for the entire sheet?
For example, currently the source name is:
"='C:\Users\Sue''s\Desktop\[DEXCOM_GSPM 0113.xls]GSPM'!$S$6:$S$8"
The new worksheet will be named DEXCOM_GSPM 0213.
How I update this?