Need more details here sucha as-

Are these lists on the same worksheet or different?
Are these lists from different workbooks?
are these lists at a specific location on each worksheet or at random
location?
Are these named ranges?

based on answers to the above, the solution will chagne.
But in most likely situation, a macro needs to be created.

--
Pranav Vaidya
VBA Developer
PN, MH-India


"jackysoh" wrote:

I have a few lists: (columns and rows)
List1 List2 List3
apple red 10 apple red 30 apple blue 30
apple red 10 orange red 30
apple blue 20 apple blue 30
orange red 20 banana 10

These list are updated periodically, either adding more data or erasing
them. I'd like to combine them into a single list data so that i can sort
them according to the "fruit" and "color", then add up the subtotal in each
change in "color".
The problem is i have about 80 lists, to copy and paste them one by one is
time consuming.

Is there a simple way to copy and paste these lists in the desired order for
sorting and subtotal?