Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive.
https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102
In the attachment you will find a list of products named "list." The first column is the product number i.e. 111.32 The following 9 columns are SKU numbers. To the right of the list is a section titled "criteria." This is the criteria of which I am using to run the advanced filter on the product list. Below the criteria section, is the section to where I would like the advanced filter to copy the results to. Sounds easy but as you can see in the criteria section, there are multiple product numbers that match (111.32), BUT have different sets of SKU #'s. When excel goes to filter the table, it is only finding the one match for each column, and copying to the section below. As you see in the results table.
It is grouping similar strings and grouping them as one. I DON'T want it to group.
As you can see in the "criteria" section, there are 4 sets of critera (each outlined in a different color) that form the "criteria" section. So, there should be 4 sets of SKU #'s in each of the columns in the "copy to" section. BUT THERE IS NOT! Again, it is grouping the like items.
Is this achievable? I would like to stay away from VBA, being the novice I am. But, if that is how I must do it, than I have no choice.
Thanks everyone!
https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102
In the attachment you will find a list of products named "list." The first column is the product number i.e. 111.32 The following 9 columns are SKU numbers. To the right of the list is a section titled "criteria." This is the criteria of which I am using to run the advanced filter on the product list. Below the criteria section, is the section to where I would like the advanced filter to copy the results to. Sounds easy but as you can see in the criteria section, there are multiple product numbers that match (111.32), BUT have different sets of SKU #'s. When excel goes to filter the table, it is only finding the one match for each column, and copying to the section below. As you see in the results table.
It is grouping similar strings and grouping them as one. I DON'T want it to group.
As you can see in the "criteria" section, there are 4 sets of critera (each outlined in a different color) that form the "criteria" section. So, there should be 4 sets of SKU #'s in each of the columns in the "copy to" section. BUT THERE IS NOT! Again, it is grouping the like items.
Is this achievable? I would like to stay away from VBA, being the novice I am. But, if that is how I must do it, than I have no choice.
Thanks everyone!