IF statements that shifts to right.
Hi.
I am trying to run an IF statement, that will check if a cell is empty and if so, will shift the data in the same horizontal row only 1 space to the right.
I would do this manually, but there are around 800 rows to look through.
Would this be easier or posible with a macro?
thanks
|