advanced filter output|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

Weekly, I need to filter a dataset (ca. 5K lines) on a combination of criterias (and/or of both fixed values and formulas).
A short action description may then be entered in a note field within one or more lines of the filtered output.

The new filtered output is then merged with the output of the previous week analysis. If a given line was already present in the output of the previous week, and the note field was not empty, then I replace the note field with the note field of the "old" line, i.e. I retain the "old" action information.

I am using an "advanced filter" to extract the relevant data from the dataset, and was planning on using a "table" to store the weekly filtered output data. Then use a some VBA code to merge the weekly tables.

Unfortunately I am not able to store the filtered output in a dynamic "table": if I define the output range as a table, then the table has fixed dimensions and will not change depending on the number of output lines. Is there a way to send the filtered output to a dynamic table?
Or shall I address the problem differently?

I am really looking for some wise suggestions....

Thanks, Gabriele