sbishops
10-28-2008, 10:23 AM
Hello,
I'm trying to find some VBA to do the following steps in excel:
I have a file in excel 2007 with roughly 50K rows of data with 30-40 columns.
I'd like to group by the values found in column A and copy all rows that share column a value to a new worksheet.
pseudo code below:
1. Look down column A for similar values (will be in alpha order).
2. Group rows that have similar values in column A
3. Create new worksheet and name for value in column A and then copy grouped 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
I'm trying to find some VBA to do the following steps in excel:
I have a file in excel 2007 with roughly 50K rows of data with 30-40 columns.
I'd like to group by the values found in column A and copy all rows that share column a value to a new worksheet.
pseudo code below:
1. Look down column A for similar values (will be in alpha order).
2. Group rows that have similar values in column A
3. Create new worksheet and name for value in column A and then copy grouped 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