Hi Babs,
I am working on this code for you. Basically you need something that will sort the data, look through the groups, grab each bit of data in the columns and then export them to a new worksheet on their own row. Then go to the next group. If each group has about 8 rows each for estimation, your results should be around 3000 rows. I plan on having it written today.
|