Why want you to have so much unneccessary work?

Instead design some report sheet (probably named like CustOrdersRep or
someting like it), where in header rows you select a customer from data
validation list (and maybe enter some date interval too), and below all
orders matching those conditions are displayed. Much easier to handle, you
don't need to redesign you workbook when new customers are added, and your
workbook dont get too slow because too much complex formulas. And no VBA is
needed - worksheet formuals will do!

Arvi Laanemets


"Tomas Stroem" wrote in message
...
Hello,

I am quite new to VBA programming so I have no idea if this is possible to
create.

My problem. I have a workbook with one sheet containing all order data for
our company.
From this workbook I want to create a new workbook with extracts per
customer and description of product. Each product shoul generate an own
sheet
in this workbook.

Does anyone have an idea??

Regards
--
Tomas S