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 ?
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: