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?

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?

Hi Pranav,
The original lists are from a same worksheet. And i want to perform my
subtotals calculation to a different worksheet. But they are all a same
workbook.

The list locations are standard, eg:
List1 A2:C21
List2 E2:G21
List3 I2:K21
List4 M2:O21
List5 A24:C43
List6 E24:G43
....
List80 M150:O169 something like this

To clarify my requirement, these are actually my stocks, where it contains
customer, model and qty column. The different list indicates the locations
they are stored, pallets by pallets in the location.
Once a week, i want to know my total stocks for the models, hence i have to
copy them all into a new worksheet, sort (by model) and perform a subtotal
(by model).

Has anyone got a solution yet?

Try Tools, Macros, Record new Macro

jackysoh wrote:

Has anyone got a solution yet?