sagarsangani
New Member
Hello,
Thank you for sharing some of the "slickest" excel tricks ever. I have been impressing my managers a lot lately after I discovered this website. But today, I am here because I'm stuck on something.
I have 2 tables which have at least 1 common category in them. I would like to filter Table2 based on how I filter Table1.
To make it simple, Table1 has Comp# and Cost and Table2 has Comp# and Comments. If I filter Table1 by Comp#, I would want Table2 to filter out automatically as well.
I'll appreciate any help!
Thanks
Thank you for sharing some of the "slickest" excel tricks ever. I have been impressing my managers a lot lately after I discovered this website. But today, I am here because I'm stuck on something.
I have 2 tables which have at least 1 common category in them. I would like to filter Table2 based on how I filter Table1.
To make it simple, Table1 has Comp# and Cost and Table2 has Comp# and Comments. If I filter Table1 by Comp#, I would want Table2 to filter out automatically as well.
I'll appreciate any help!
Thanks