Macro on attached should extract unique records from the DATABASE sheet that meet the four criteria on the MEASURE sheet
It filters the database for the two criteria in D2 and D6 of the Measure sheet.
It then recognises the MAXDATE and MINDATE in D10 and H10 of the Measure sheet, but is closing all the rows on the DATABASE sheet.
Hopefully someone can see the problem?Please Login or Register to view this content.
All solutions and suggestions received gratefully as ever.
Ochimus
Bookmarks