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.
|