How to get this to work

[cptkoble]

Hi all

I am wondering if excel (and you) can help me with this situation:

I have the worksheet and on one page I have 7000 rows of data.

eg:
09-09-2006 Supplier1 Customer1 Product Price
10-09-2006 Supplier2 Customer2 Product Price
11-09-2006 Supplier1 Customer3 Product Price

I use the filter to get some nice sorted lists, but now they made me to create a new page which will show me all these data for one customer.

So: on another tab i need a drop down box with all the customersnames mentioned in column C. Then it needs to read all information as given in the raw-data tab, specific to this customer.

Right now, I use the autofilter to get the information sorted, then start copying/pasteing but I would be so nice if that could be easier...

Anyone please???

Amanda

 

[onlyadrafter]

Hello,

Look into Pivot tables.