Filter and copy
 

Hi all,

I am reposting from previous but simplified nd without attachment. I a
after a way of filtering info from columns and rows, then copying th
matching cell entries into other designated cells. IE: column d-
contain numbers and multiple rows contain parts (there are multipl
parts). For each part, there are 5 options (rows-r2,r4,etc)

SImply, I need to filter/cross reference, lets say column f and th
rows containing R2. If the matching cells contain an 'x', then a pric
listed in that row, column B copies to a nominated cell, for al
parts.

Summarised, there are 20 parts, each one has a possible configuratio
(column) and spec (row) after the filter of column and row, if the cel
is marked with 'x', then the price in that row, columnB copies to th
cell next to the part......ideas????

My brain is lacking but im sure there is plenty of brain power ou
there!!!!

Cheers in advance!!

--
gavme
-----------------------------------------------------------------------
gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666
View this thread: http://www.excelforum.com/showthread.php?threadid=26669