Each day I get a new/updated dataset in a new WS (all columns stay the same). I manually cut/paste the new data over the old data (number of rows/records may change up or down).
My thought is if I have it in a range name (OriginalData) and that the range would automatically expand or contract to accommodate the new/updated data records.
Then I think I need a Macro to extract 2 subsets of data that requires two passes. The first pass simply identifies a data element in a particular column. It may be able to be set up using Filtering (or Advanced Filtering) to Identify the particular selection (YELLOW in my Example). The first pass result is then copied and pasted into Sheet2 with a Data Range (ResultsData).
The second pass is a little more complicated. I have to take the remaining data (i.e. that data that is left over when the records/rows that are selected in the first pass that are extracted) and do a text search using two text strings on a different column (BLUE in my Example). The results are then placed in Sheet2 as additional record/row results.
I have put together a good example of what I'm looking for. I believe that a macro that defines an initial range (Originaldata) and an output range (ResultsData) along with a way to automate the two passes and place the result in a separate sheet (sheet2) would do the trick.
Much thanks in advance.