How do I make the defined name to be the content of the cell for hyperlinking.

juneaubugg

New member
Joined
Apr 17, 2014
Messages
1
Reaction score
0
Points
0
Can I use a vloolup in defined name or hyperlink?

I have sheet 1 with a list of stores and I want to hyperlink to a section of results for each store in sheet 2. However our stores change fairly often (opening and closing new ones) so the position of a store on sheet 2 may be A35:A44 one week and A22:31 the next. So I can't define the name of the cell to use as a link. How do I make the defined name to be the content of a cell? ie cell A35 in the first example would be store "135", so it would define the name as store 135, and in the second example the same name would be applied to cell A22.

Help!
 
Back
Top