DaSandmanCometh
New Member
- Joined
- Nov 27, 2016
- Messages
- 1
I have a worksheet (B) that I use to keep track of additions to facilities and I have the address/facility name as the main header. Now I have about 35 facilities on this worksheet which makes the worksheet kinda long. On a different worksheet (A) I have totals for facilities, the list is just the address/facility name. I have been using the hyperlink from A to a cell on B so I can go to the facility and look up what I need to. However my company has been doing a bunch of renovations/upgrades/improvements to their property's and I seem to be adding another row to B daily. Which throws off my hyperlinks to the where the address/facility header is.
Is there a way to hyperlink to a dynamic cell? Can I hyperlink to a certain name/sting of words/etc... Something that will allow me to go to the address/facility header on worksheet B even when I'm added rows?
Thanks in advance for your help.
Is there a way to hyperlink to a dynamic cell? Can I hyperlink to a certain name/sting of words/etc... Something that will allow me to go to the address/facility header on worksheet B even when I'm added rows?
Thanks in advance for your help.