This is a bit complex so I'll try and be as clear as I can, I really
hope someone can help as my job is at risk at the moment and a lot
depends on me getting as much work done as quickly as possible

I have attached a workbook with some raw data as an example.

I need to copy the data to a New Worksheet called Base_Data_2 so that I
don't lose the original data.

Then I need to find the top 20 code groups based on the total Value in
Column H. I have used a sumif in column O. But I expect there is a
better way.

Code VS has the highest overall value and I need to copy all of the
rows with a VS in column N to a new worksheet called Category_01.

I then need to sort the data by column H Descending and delete any data
below row 10 leaving me with the top 10.

Then move on to the code with the second highest overall value and copy
all of the rows with a CJCR code (just one in this case) in column N to
a new worksheet called Category_02.

I need to do this for the top 20 groups of codes in descending value.
(Note: for some of the data there might not be 20 groups of codes)

At the end I need to bring all of the data into a Summary Sheet copying
from Category_01, Category_02 ect to a Summary sheet.

All help much appreciated.


+-------------------------------------------------------------------+
|Filename: Example.xls |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=26|
+-------------------------------------------------------------------+

--
Timbo
------------------------------------------------------------------------
Timbo's Profile: http://www.thecodecage.com/forumz/member.php?userid=24
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35230