Macro to filter columns based in table of fields

Anka

New Member
Joined
Oct 20, 2012
Messages
45
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
Hello everybody,

Well, I will try to explain in more detail.

In Sheet 1, I have data starting with row 21 (rows grow every day because new rows are added).
Based on these data I have three tables that do some calculations. (U2:AA13, AD2:AK13, AT2:AY2)

In Sheet 2 columns B to M, I have a table of fields that need to be filtered. One of the big issues is that this table can reach more than 5,000 combinations of fields.
In column A, I have some kind of code for each field's combination.

I need a macro to filter columns (in Sheet1) based on combination of fields what I have in all rows in that table.

After each filter is applied, the macro, must copy these three tables and paste them into Sheet 2 starting with cell Q1, one below the other.
In front of each copied table (in column P) should be placed the filter code that was applied.
English is not my home, and I have great difficulty explaining better what you want, but if you have any questions, I will try to answer.

Thank you in advance.

EDIT: I upload here a dummy example of what i need.



PS:Why I can not post attachments ?
 
Last edited:
Hope dies last, my friend !
Thank you very much for your time. You solved my problem.
 
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Glad to help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,214,648
Messages
6,120,726
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top