I have a file that comes to me weekly. Within the massive amount of data, I need to extract specific rows of data containing a text string. What I need is a macro that takes a defined Range name (i.e. the raw data in the columns/rows) and finds the specific text within a particular column or row. Once it is found, it exports the specific row to another worksheet and names the worksheet with the range name.
There may be an easier way to do this (dataslicers?) but I'm thinking "macro" so that I can easily take an incoming data file, name a range, run the routine and then perform all other operations on the extracted data.
Thank you in advance.