Spreadsheet help with VBA GoTo

New Contributor

Hi

 

I am desperate for some help with this spreadsheet. I need a way of entering a store number into cell c6 and the corresponding column being jumped to. I have a mass number of questions to track stores in the A,B,C Columns followed by a freeze pane. I need to input a value into C6 that relates to a store number, the document will then jump to this stores Column. I will have 1000+ stores going horizontally so this will be used as a navigation tool more than anything. I know I could use Find but I need to make this document foolproof.

 

Thanks in advance

 

Tom

 

 

1 Reply

@Tomtoung 

You can use the Hyperlink() formula.

As I don't know how you are identifying your stores, I developed the attached example considering store 1,2,...

Find attachment