Nicolaf
10-21-2011, 06:25 AM
Hi,
Starting from Sheet2 I would like to have a macro that looks for number 1 in column A in Sheet1 and when it has found it goes to columns K,L and M and performs an F2 (from keyboard) function on each of those cells.
Basically it refreshes them.
So if number 1 is found in cell A4 then the F2 function is performed on cells K4, L4 and M4.
How do I do that?
:dunno
Thanks,
Nix
Starting from Sheet2 I would like to have a macro that looks for number 1 in column A in Sheet1 and when it has found it goes to columns K,L and M and performs an F2 (from keyboard) function on each of those cells.
Basically it refreshes them.
So if number 1 is found in cell A4 then the F2 function is performed on cells K4, L4 and M4.
How do I do that?
:dunno
Thanks,
Nix