Linking to cells on worksheet from drop-down box?

[JumboCactuar]

Hi,
Can this be done without VBA?

I have freeze panes (columns A and rows 1)

Dates are labelled across columns

I want to select date from drop-down box and immediately jump to the appropriate column with the active column to the top left of the view.

Sorry if I've not explained this well

Appreciate any help

 

[James006]

Hi,

Short answer to your question : NO ...

My question would be : Why are you saying Without VBA ?

 

[JumboCactuar]

Just wondering if it could be done. As you can set up hyperlinks to other sheets/cells without VBA

 

[James006]

Just wondering if it could be done. As you can set up hyperlinks to other sheets/cells without VBA

You are right ...

But sadly not from within a drop-down box ...