I have 8 separate spreadsheet files with a list of document numbers in them as follows: Column A is 'Doc #', Column B is 'Doc Title', Column C is 'Rev #' and Column D is 'Effec Date' (these are the header row). Unfortunately, the majority of the date fields are formatted as text though they'd need to be converted to date to allow a useful sort.
What I need to do is move the information in each of these separate 8 spreadsheets into just one spreadsheet then have anything with an effective date within the last 2 years removed and have it sorted by effective date (column D). The purpose of this is to determine which documents haven't been revised for more than 2 years.
Is it possible to do this so this new spreadsheet which we'd create always updates itself by taking the information from the 8 separate spreadsheets which themselves are constantly updated.
Thank you!
What I need to do is move the information in each of these separate 8 spreadsheets into just one spreadsheet then have anything with an effective date within the last 2 years removed and have it sorted by effective date (column D). The purpose of this is to determine which documents haven't been revised for more than 2 years.
Is it possible to do this so this new spreadsheet which we'd create always updates itself by taking the information from the 8 separate spreadsheets which themselves are constantly updated.
Thank you!