D
dyun1dyun1
Hello All,
This is my first post, so here goes.
I have simple links between tabs in my spreadsheet but the reporting
software I use is called YSL, and it changes the name of tabs when it
is run.
So if any simple links I make (ex. ='t-prop'!e1) changes to ='prop'!e1
and I get an error before the report even finishes running.
Ideally I don't want to add the tabs after the report, due to the
volume of reports and the only solution I can come up with (using my
limited excel knowledge) is creating a simple Macro to edit replace a
value in these simple links after the report is ran.
I appreciate any ideas.
Thanks.
This is my first post, so here goes.
I have simple links between tabs in my spreadsheet but the reporting
software I use is called YSL, and it changes the name of tabs when it
is run.
So if any simple links I make (ex. ='t-prop'!e1) changes to ='prop'!e1
and I get an error before the report even finishes running.
Ideally I don't want to add the tabs after the report, due to the
volume of reports and the only solution I can come up with (using my
limited excel knowledge) is creating a simple Macro to edit replace a
value in these simple links after the report is ran.
I appreciate any ideas.
Thanks.