Now I see what happened. It only does it if I type something into QRST
I have formulas there that result in data from other cells, so since i
was already there it didn't move over. When I do type something int
those cells it moves it over but not up. So what I need is the cells i
QRST to move over and up assuming that the data is already there s
there are no spaces. Basically what I have is a list of tools, if th
tool is broken it moves the info to QRST the I have 3000 rows that hav
data or not and I want all the data in an easier format with no spaces
I'm doing this the hard way for now since there is probably an easie
way but i'm still learning

--
Optitro
-----------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=47333