My earlier post was obviously too wordy or difficult.
Perhaps an example of what I am trying to achieve may help.

Have a look at the attached workbook. It has two worksheets:
Item history, which has an items history and the priority of quotes
that the current information takes preference on.
Current Data is the worksheet I would like to achieve by filtering,
looping through cells???? This row represents the most prefered data
for a particular item.

Ideally, by selecting this item the user will be presented with a
variety of options for viewing the items information. (filter by
supplier, or by quotes etc)

Any ideas of how I can achieve this?


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4896 |
+-------------------------------------------------------------------+

--
QuickLearner
------------------------------------------------------------------------
QuickLearner's Profile: http://www.excelforum.com/member.php...o&userid=35483
View this thread: http://www.excelforum.com/showthread...hreadid=552634