Sort descending by the downtime column, select and copy all the lines that
are greater than 50, select your special workbook, right click on a line and
select 'Insert'.

To me that sounds like what you need, and would take more time to code than
to do that simple task, but if you really need it to be coded let me know and
I can list that out in code =).

"bpotter" wrote:

I have a woksheet that has around 50 lines. In one column I have
downtime for each entry. I am trying to loop though each entry looking
at the downtime and if it is greater than 50 then I want to transfer
the whole line into a special workbook. But here is the catch! I want
to move the previous day lines down as I am adding entries into the
workbook. I am not very good at macros so if you help me please dumb it
down a little. I would appreciate any help at all. Thanks in advance!!!