I have a workbook with three worksheets. The first is a list of employees
with employment details and the first worksheet is a summary page. I have
set up a drop down list for the employees and use this as a reference to
select the employee with links set up, I now have the informations showing
from the employees worksheet - all ok. My problem is the sales worksheet. I
have a list of the employees (in a column) with different supplier's name
(another column and then seperate columns for clothing items with the
purchase costs.

With a filter, it looks like this :

Employee Supplier Trousers Shirts Jumpers
Tom Jones Coles $125.00 $50.00 $54.00
Tom Jones K-Mart $25.00 $15.00 $25.00

My problem is I am trying to show the items purchased by Tom Jones as
seperate lines ie Coles and then K-Mart with the purchase price in a row. I
can show the first line of Coles but if I copy down it still shows Coles and
not K-mart. I have used VLookup, Lookup, and Match but I can't seem to get
it to work. Also the first line doesn't show the correct amounts he spent on
the items he purchased. What am I doing wrong. Thanks in advance.