If a cell in a row has any of the four exact words: text, number, date or time, how can I make it paste that row into the "next available (blank) row" in another sheet (same workbook)?
As I enter row entries into the sheet called "MASTER", I'd like it to auto populate the sheet "RECORDS" with exactly the same information.
One way might be to flag the rows that are relevant, say with:
=REGEXMATCH(TEXTJOIN(,1,A1:G1),"text|number|date|time")
in MASTER copied down to suit, and then select on the basis of those flags, say with:
=query(MASTER!A:H,"select * where H=TRUE")
in RECORDS.
Assumes any addition to RECORDS will be from the bottom of MASTER, or not required in RECORDS.
