View Single Post
 
Old 01-19-2006, 02:23 PM
kent kent is offline Windows XP Office 2007
Novice
 
Join Date: Jan 2006
Posts: 4
kent
Default 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
Reply With Quote