B
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!
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!