I am trying to figure out how to filter data in one spreadsheet and have the results display live on another. Here's a description:
Spreadsheet one has about 200 rows of data, columns A through L. Let's say columns C and D have dates in them. What I'd like is that for every row, if the date in column C is less than today's date (in the past) and Column D is blank, for that entire row to appear in a different spreadsheet (or worksheet within the same spreadsheet if that's not possible). Also I would like this to update live....so if I enter a date into Column D on spreadsheet 1, that row would no longer appear on the new spreadsheet.....or if a few days go by and the date in Column C is now in the past (and Column D remains blank), that row would now appear in the new spreadsheet.
Any help would be appreciated. Thank you.
Spreadsheet one has about 200 rows of data, columns A through L. Let's say columns C and D have dates in them. What I'd like is that for every row, if the date in column C is less than today's date (in the past) and Column D is blank, for that entire row to appear in a different spreadsheet (or worksheet within the same spreadsheet if that's not possible). Also I would like this to update live....so if I enter a date into Column D on spreadsheet 1, that row would no longer appear on the new spreadsheet.....or if a few days go by and the date in Column C is now in the past (and Column D remains blank), that row would now appear in the new spreadsheet.
Any help would be appreciated. Thank you.