June 6, 2021
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....