Basically I have a Table with products on it, each product has multiple serial numbers, Lets just say Serial A, Serial B, and Serial C. There are a lot more columns of other information related to the products , but the main focus are those serial Numbers.

So what I need to do is search all of the Products with Serial A = 268. So i filter out my tabe for 268, cool. Now I need to get all of those results Serial B column. ( should be different) and search for all of the products in the Full table for all of the results on Serial B ( the results that i copied from the initial Serial = 268 search). Normally I would just Copy the Serial B's, one by one , and manually adding it to the filter on the table( this filter is of Serials B, Column). Sometimes there are over 90 Products, so this task gets very grindy.

Is there any way i can automate this using VBA vodoo magic , or is that more in the line of a super formula with a helper column?

I dont know alot of VBA ( Can analyze the code and make corrections to adapt it, but i cant just go from scratch and start typing away, Im coming from a C++ background :/ )

This post was edited by Pino38 on Aug 4 2016 03:28pm