Automatic function in Excel
 

Hi All,

I would like to solve, that I have an Excel file, and in there tw
worksheets.
If I click in the worksheet(1) for instance in the A3 cell, jump t
the worksheet(2) A3 cell.

And this function must be automaticly, so I don't want to do hyperlin
for 1500 lines.

Can anybody help me?


Thank

--
reloade
-----------------------------------------------------------------------
reloader's Profile: http://www.excelforum.com/member.php...fo&userid=2782
View this thread: http://www.excelforum.com/showthread.php?threadid=47332

Automatic function in Excel
 

Right click on the sheet tab of worksheets(1) and put in code like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if Target.column = 1 then
worksheets(2).Select
worksheets(2).range(target.address).Select
End if
End Sub

--
Regards,
Tom Ogilvy

"reloader" wrote in
message ...

Hi All,

I would like to solve, that I have an Excel file, and in there two
worksheets.
If I click in the worksheet(1) for instance in the A3 cell, jump to
the worksheet(2) A3 cell.

And this function must be automaticly, so I don't want to do hyperlink
for 1500 lines.

Can anybody help me?


Thanks


--
reloader
------------------------------------------------------------------------
reloader's Profile:
http://www.excelforum.com/member.php...o&userid=27827
View this thread: http://www.excelforum.com/showthread...hreadid=473329