yes/ No on multiple sheet

[Muskrat24]

I am trying to make a spread sheet so if for example on sheet 1 I have

A B C D
1 Big $5 3
2 Medium $3 5 yes
3 Small $1 4

I have a "yes" for the Medium row, How do I make it so that only the medim
row shows up on sheet 2 but if the other 2 would have "yes" in the D column
they would too?

 

[Muskrat24]

it came up as error, there are not the same number of grouping brackets

 

[Ashish Mathur]

Hi,

I have something similar in question 7 of the following link -
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com