R
Ryan Vande
I have a workbook with several sheets within it, the first page is, we will
call it my main interface page. The all the other sheets are my backend
sheets. Now on my main interface page I have hyperlinks that are directed
tothe backend sheets.
If I was to add a row to one of the sheets in the back end all of my
hyperlinks on my main interface page are now incorrect... I would have to
update all hyperlinks on my main interface page to reflect the new hyperlinks
pointing to the backend, all becase I added a row or column on a backend
page. so all my hyperlinks (If I added one row or colum) would be one letter
or nmber off.
Is there anyway to add a row or column and have the hyperlinks dynamically
follow?
My only option (having the knowledge base I have) Is to just add any rows to
the bottom of my backend sheet this way any row and or column would never
have to be added. This however keeps my backend sheet all messy and
disorganized
call it my main interface page. The all the other sheets are my backend
sheets. Now on my main interface page I have hyperlinks that are directed
tothe backend sheets.
If I was to add a row to one of the sheets in the back end all of my
hyperlinks on my main interface page are now incorrect... I would have to
update all hyperlinks on my main interface page to reflect the new hyperlinks
pointing to the backend, all becase I added a row or column on a backend
page. so all my hyperlinks (If I added one row or colum) would be one letter
or nmber off.
Is there anyway to add a row or column and have the hyperlinks dynamically
follow?
My only option (having the knowledge base I have) Is to just add any rows to
the bottom of my backend sheet this way any row and or column would never
have to be added. This however keeps my backend sheet all messy and
disorganized