If the rest of the row is empty, why not just sort by blanks and delete en
masse?

--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a
way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with
cutting
and pasting. I have a lot of values and empty cells so if there is a
formula
that would be a lot quicker than cutting and pasting. Thanks.