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.