Hello,
I'm trying to find some VBA to do the following steps in excel:

1. Look down column A for similar values (will be in alpha order).
3. Group rows that have similar values in column A
4. Search for worksheet named with value in column A.
4a. If worksheet exists, insert new rows at end of file (don't overwrite existing rows).
4b. If worksheet does not exist, create new worksheet and name for value in column A and then copy new rows into that worksheet.

I see the "copy and paste" method recommended quite often and that's great if you have just a few values, but i have over 370 values with 50,000 plus rows of data and new data comes in every month, so i reallly need some robust VBA to get this done.

Can anyone help me out?

Thanks!
Steph