Swarv
02-24-2010, 02:28 AM
Hi all,
I have a sheet with quite a few records.
In Column A is the title of the person but there are some gaps. i.e. Row 5228 might not have a title in it.
when I get to this row can I copy the cells B5228, C5228, D5228, E5228, F5228 and place them in L5227, M5227, N5227, O5227, P5227 ?
Then Delete the line 5228?
Im sure this is possible but not sure how.
Thanks
Martin
I have a sheet with quite a few records.
In Column A is the title of the person but there are some gaps. i.e. Row 5228 might not have a title in it.
when I get to this row can I copy the cells B5228, C5228, D5228, E5228, F5228 and place them in L5227, M5227, N5227, O5227, P5227 ?
Then Delete the line 5228?
Im sure this is possible but not sure how.
Thanks
Martin