View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tinkerbellsmyhoe tinkerbellsmyhoe is offline
external usenet poster
 
Posts: 8
Default i need to record a macro to....

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.