Hello - This is going to take some explaining so I hope you all catch what I'm getting at...
On Sheet 1 I have a table. In this table I have several column headings and rows, etc. as in any table.
An example is:
ID | Name | Date 1 | Date 2 | Date 3
Then, in my second sheet I want to be able to filter this table and only display rows which have values in one of the Date columns (As not all of them will).
Is this possible? I imagine i will need to use VB, but thought I would check on here to see where everyone thinks I should start.
Once that has been achieved I would like to order the filtered list with the earliest date, and show how many days have past since that date. But One step at a time...
Thanks for reading!
Bookmarks