Getting data from a sub-totalled list to other lists
 

I have some sub-totalled data in the following format:

Part # Location Qty Comment
Part 1 Bin 1 5
Part 1 Bin 2 6
Part 1 Bin 3 2
Part 1 Total 13 Text of Part 1 comment

Part 2 Bin 2 4
Part 2 Bin 3 6
Part 2 Total 10 Text of Part 2 comment

This data is my master list of all parts but I also have separate lists
for each location (ie. a Bin 1 list, a Bin 2 list, etc.) sorted by part
number.

Using the sample data from Bin 2, here is an example of what I want to
do on all my Bin lists:

Part # Qty Comment
Part 1 6 Text of Part 1 comment
Part 2 4 Text of Part 2 comment

The question: how do I get the comment (which is on the sub-total row
of the master list) on to the individual lists?

I tried a Pivot Table but I had to remove the sub-totals and when that
happened I also lost my comments.

Garth