Adding row to sheet; having hyperlinks follow

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
 
J

Jacob Skaria

Hi Ryan

Try the below in your master sheet

'Reference to Sheet2 cell C3...Once you copy the formula; try and insert
rows/cols in Sheet2. and retry..
=HYPERLINK("#"&CELL("address",Sheet2!C3),"target")

If this post helps click Yes
 
R

Ryan Vande

Quick question would this have something to do with absolute / relative
coding within excel?

If I try a name column A in a sheet it does not change the name from A to
whatever I named it. However I was thinking does it change the column name in
the VBA code? Like I can reference this column by the name I choose as
opposed to the letter A?

So If I added a column/row I can always refer to my column/row by that
logical name I gave it, as opposed to column A for example...



Also from the looks of what your asking to do is this sort of the same
thinng as what I'm asking
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top