cursor movement in new cell based on....

[Livio E Scalma]

hello to all. My little question:
I added some controls in few cells with formulas; I need to shift the cursor (active cell) in certain final cells, based on the orginal cell content. That means: (automaticly) based on A1 value, the active cell becomes B2 if A1=1 or C1 if A1=2 .
How without macro, but using only formulas ?
Thanks, Livio

 

[NARAYANK991]

Hi Livio ,

I think actions such as moving the cursor around , deleting rows / columns , hiding / unhiding rows / columns , are not possible using formulae ; formulae can only display different content in cells.

Narayan

 

[Livio E Scalma]

Thanks, solved via a different way
regards, livio