hyperlink to a specific excel column

[rleach]

Hello -

I am trying to create a hyperlink in excel, that when clicked will open
another excel sheet and highlight, or direct focus to a specific
column. Any ideas on how this can be done using basic excel
functionality or by writing a simple macro?

Example:

Hyperlink = Results/myresults.xls ---I want to go to column J.
Thx,

rleach

 

[Gord Dibben]

Another sheet in same workbook...........

Right-click on cell and "Hyperlink"

From dialog select "place in this document"

Select the sheetname and type a cell address in the address box.

If, on the other hand, you want to link to a column in a sheet in another
workbook......

Right-click on cell and "hyperlink" and "Existing file or webpage".

Browse to the other workbook and select it then "bookmark" and select a
sheetname and type a cell address in the box.


Gord Dibben Excel MVP

 

[bobertx3]

Thx so much!