I'm just beginning the long road in learning VBA and already have an immediate need for some code that is quite beyond me.
I have an excel worksheet that contains thousands of rows of data in columns A thru U, and another workbook with multiple worksheets that are blank and waiting to receive data. 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, but did not post it yet because it's very sloppy right now. I tried doing the copy/paste one row at a time, then ran into trouble with the subsequent rows. Besides, doing it one row at a time seemed inefficient.
This is something that I will need to do monthly so I really appreciate any help that you can provide.