How to combine/consolidate data

[Bart Galkowski]

Hi,

I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered.

All data is organized in same sort of tables accross several sheets - each sheet representing different product group.

So, lets say I have table organized like below:

ColumnA ColumnB ColumnC
Product Price Order
Prod1 10 1
Prod2 20
Prod3 20 2

And I have several of such tables on different sheets corresponding to each prodcut category.

Now, on the first sheet, I would like a summary of all items ordered - so all the items where the customer entered a value in ColumnC.

How do I do that?

THANKS!

 

[Bart Galkowski]

I forgot to add one thing - I would like consolidated data to "refresh" automatically if anyone changes the number of ordered products

 

[Don Guillett]

I forgot to add one thing - I would like consolidated data to "refresh" automatically if anyone changes the number of ordered products

send me a file with a complete explanation and examples
dguillett1 @gmail.com