Hi, I currently have about 10,000 rows of data and need to filter and copy
and past certain amounts of data onto different workbooks. I need to filter
by column A and copy and paste all the filtered numbers onto a different
workbook. In total there will be about 60 different workbooks each
containing a different number of rows. I need to save the workbooks as
something different everytime I I dont know how to go about doing this....can
anyone help?