I have a sheet with approximately 1200 rows of data.
Currently, the only way for me to copy rows to different sheets is to select each row (based on specific criteria (column value)).
It all works, but it takes a while to run - because I am iterating through each of the 1200 rows, finding a value from the O column, finding the appropriate sheet to paste it into, and then pasting the entire row of data into the next available row.
So, what Im doing is looking through each cell in the O column, grabbing the value, and comparing it to the sheet names (the sheetnames were created based on the unique values from the O column). When it finds the sheet name with the same value as the cell, it pastes the row into the next available row.
But it does this for 28 different sheets (potentially). so it takes approx 30,000 searches/copies/pastes.
the O column contains 50 occurances of "Community Services", 65 occurences of "Corporate Services" etc for 1200 rows of data.
I have sheets by those two names (Community Services and Corporate Services).
Is there a way to have vba scan through all 1200 rows and select/copy all the appropriate rows, then do 1 paste into the appropriate sheet?