Filter/copy based on criteria
 

Hi all,

Im at the beginning and at a loss as to the right path to follow
Imagine this:

Product PLACE HERE P PP PLV PPLV
LTTLV

100 2 x x
x
350 4 x x x
x x
500 6 x x
800 8 x
x


Product PLACE HERE P PP PLV PPLV
LTTLV

100 2 x x
x
350 4 x x x
x x
500 6 x x
800 8 x
x

Basically, the x represents if a product is available, based on th
2,4,6 and P,PP,etc. What i need is a way to filter the info. If an
(Price) exists in the cell after the user has selected the item (mayb
from combo box on user form)IE 4,PLV, then the price in that row copie
to 'place here'. reason for this is that the 'place here' is beside
product and those 2 columns will copy to a new sheet. I know it sound
strange but im open to suggestions otherwise thats what i wa
considering.

ppplllleeeaaasseeee...can someone shed some light. See attached boo
for example.

CHeers!!

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

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