Hi,

I'm very new at this but it seems like I'm in the deep end already (at least to me).

I have an excel worksheet that contains over 10,000 rows of data in columns A thru U, and another workbook with multiple, named worksheets that are blank. I need to search the value in column A of the first worksheet (let's say it's valued with the words "Bird", "Cat", "Dog", etc.) - I will search for all "Birds" - and copy/paste those rows into the worksheet of the other workbook that's named "Birds" and so on, until I've copied all of the records on the first worksheet to their proper worksheets in the other workbook (that workbook may have up to a hundred or so worksheets). The one good thing is that the first spreadsheet is sorted by column A, so it might be easy to get chunks of records at a time, if I knew how.

What is the best way to do this in VBA? I have started some code and tried using a range but was not very successful after copying and pasting the first row. Anyway, I was trying how to figure out how to copy and paste multiple rows at one time to make the process more efficient and that's where I really ran into a wall.

This is something that I will need to do monthly so I really appreciate any help that you can provide.

Thanks!