I have a table with the Columns: Date, Col1, Col2, Col3.
I want to copy all the rows with the same date into a new workbook. The date is in order. I have a code written that works. However, it takes forever to run, because it is looping through each row. I have A LOT of rows.
Is there no way to just select and copy a chunk and then paste it all just once? I think it takes long because it is pasting each individual row separately.
Thanks.
Here is my code:
Please Login or Register to view this content.
Bookmarks