Hi guys I have a question or should I say i have a big fu*** problem.
Sory about that word :) ok one of my employee is getting every week a
excel document looking like the picture you can see it. Now here is the
problem. Each document has always at leas 1000 rows, so don't even think
abaut moving cells manually :)

Now is it possible to move every second row (however it's not alwasy
the second row :( ) to a row above in the firs empty cell. So is is
possible to move cells in range A2:E2 in the row above that meen in
first row in the firs empty cell in this case would be this range
B1:F1... and so on for the next 1000 rows every week... :(



+-------------------------------------------------------------------+
|Filename: New Picture (1).jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3950 |
+-------------------------------------------------------------------+

--
jgregor
------------------------------------------------------------------------
jgregor's Profile: http://www.excelforum.com/member.php...o&userid=28361
View this thread: http://www.excelforum.com/showthread...hreadid=479421