right click on the sheet tab on sheet1 and select view code.

Put in code like this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if Target.count 1 then exit sub
if Target.column = 6 and Target.row 3 and Target.row < 256 then
worksheets("sheet2").Select
worksheets("Sheet2").Cells(2,Target.row+1).Select
End If
End Sub

--
Regards,
Tom Ogilvy


"tinkerbellsmyhoe" wrote:

hello,

i have looked endlessly on a way to perform a simple task. PLEASE
HELP!

when i click on a cell in sheet 1, i would like to move to a certain
cell of sheet 2.

if i click on F4 in sheet 1, the i would like to select cell E2 in
sheet 2.
if i click on F5 in sheet 1, the i would like to select cell F2 in
sheet 2.
if i click on F6 in sheet 1, the i would like to select cell G2 in
sheet 2.

and so on.


THANKS IN ADVANCE!!!
Mike C.