ExcelBanter - Complex Matching

I can write a macro but need to verify what you want done. Please read my
description below and make comments as necessary

It is looking like you want to add a summary worksheet to your workbook
which merges together all your Range Names and puts them on the summary sheet
and then sorts the summary sheet.

It look like you have 5 worksheets.

a) One sheet containing I have a list of products and their unit value.
don't think this is need to solve your problem.
b) Four sheet containing the columns A - J (Possibly A - K) shown in your
posting. There appears to be multiple tables on these four sheets with each
table being a different date and product code. Each table is a Range Name.
The sheet name is included as part of the named ranges. You need to copy all
the columns from these ranges to the summary sheet. All the tables start in
column A which isn't important because all the tables are in the named ranges
and the method I will use is just copy the data in the named ranges.

There are two ways of doing this.
1) Create an array of the Range Names and then copy each of the Ranges to
the summary sheet. then sort.
2) If the only named Ranges in your workbook are the Date/Product Tables
then a macro can be written to get all the named ranges and copy them to the
summary sheet in one continuous table.

I assume you want all the columns from the Date/Product Table copied to the
summary table. I can't tell which columns to sort becasue I'm not sure which
is the SITE column. Iassume the value column is the last column which is
column K. I had problems with the table you posted because you had 10 header
columns A - J, but had 11 columns of data in the next row.

"Matthew" wrote:

Thank you first,
I am off to bed as this has taxes me for the last 8 hours !!!!! but I
know some one will give me this on a plate, if I can describe it;

1) I have a list of products and their unit value
2) I have a list of product ordered by site, this list is on 4 work
sheets (each with a range name), they are the same (difference is date
& product code)
a b c d e
f g h
i j
CCCODE| C No |Div |Reg |C Name | DESCRIP |ORDER_REF |DATE |UNITS |
UNIT_DESC |value

I am looking for a simple way to list what each site has ordered, by
product by value. The kicker is they may have ordered the same thing
multiple times, which apears on different sheets......

A little bit of VBA code would work.........................I Hope
'cos I can not make any thing else work

Help please I am stuck

Matthew