Loop in excel - any suggestions? (1 Viewer)

[pangx623]

I'm trying to write a loop in Excel, the trouble i'm having is trying to cut and paste the records from each loop to another excel worksheet without overwriting the data, For example:

1st loop cuts and paste 5 rows/records of data from "sheet1" to "sheet2", 2nd loop cuts and pastes 5 rows/records of data from "sheet1" to "sheet2" etc....consequently it overwrites my previous 5 records.... Anyone have any ideas?

Thanks

-- Off to work now, I'll check this periodically hoping for a solution

 

[Surjer]

Please post your code and we can advise. It would seam to me you would simply keep track of where you are pasting data and count the amount of data you have copied. Once its copied you would move up to the next available range. Are you not doing that?