Hi All,
I was wondering what would be the best way to filter thru multiple sheets to find the earliest dates and populate a new sheet with the 10 values.
I've attached the sheet that I'm working on. Basically, on a separate sheet, I want to go thru each tab(EQ5A, EQ5B, EH1, etc) and search for the earliest date. I'm thinking it would populate an array of some sort, then filter out the earliest 10 from the new array. I need the date, along with all other values in the row.
Any ideas if a formula would work for this, or should i go thru VBA?
Thanks for any help you can provide.
Bookmarks