View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bpotter bpotter is offline
external usenet poster
 
Posts: 28
Default Looping through workbook

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!!!