Select specific part number in one excel tab and the other tab changes accordingly for this selected part

[happymacro]

Hi all:

Very new to the VBA. Here is the goal I want to do.

I have to two data set in two excel tabs.

One tab has part attributes for specific part number and the other tab has sales information. So, my question is how can I filter one part number in part attributes tab and the sales information tab also changes to the part that I have filtered in part attributes tab. Which means whatever I filter in part attribute tab and the sales tab changes accordingly.

Thank you for your help.

HM

 

[Yongle]

Thanks for the feedback

 

[happymacro]

Hi Yongle:

Another question for this coding you mentioned that this is only work on 1 selection. What if the part number has some kind of different colors with same prefix such as PN123-Black, PN123-Red.

Will this possible to filter all the parts start PN123-xxx?

HM

 

[Yongle]

This thread has a question and a solution.
I suggest you start a new thread - the question in post#12 requires a modified approach

 

[happymacro]

Ok, thanks.