Unique, random selections from one sheet to another

Good day all,

I'm using Excel 2007 at work and am having issues with my current macro. The first one should be a simple fix, I hope. The macro creates two sheets in a workbook. The length of sheet1, 'checklog,' varies based on the total items imported. I need to have cell D2 be the total of blanks and dates over one year old based on Column E.

Second, on sheet2: I need to either select a random sample, from sheet1, of IN USE items (column D) equaling 5% of the the total inventory. Or, 100% of the blanks and over one year old items, whichever will give the larger sampling. These need to populate sheet2 starting in cell A5

Third, I'd like to have the items imported from above be numbered in column A

With the attachments:
Checklog.txt will import with 12 total items. One is over a year old and three have missing dates. The checklog tab cell D2 counts only 1, but I need it to have 4.

Thank you so much for your help. I've been struggling with this for days.

Thanks to MarvinP, I've been able to select a random portion of my total to populate sheet 1 of my workbook. I'm still struggling with how to ensure they are unique samples, no duplicates, from my total inventory.

I also need to be sure the sample includes all the items last accounted for over 1 year ago (checklog!d2).

I was thinking of copying the lines after using the advance filter, but can't figure out how to get it working. I've commented out my feeble attempt in Sub Random().

These latest attachments should generate an inventory list of 116 pieces, one over 1 year old. The total to validate is 6. Anyone have any suggestions?

Does anyone have any thoughts on how to prevent duplicate lines?

You can have the duplicates deleted if there are some common fields to compare with.

The duplicates would show on the created sheet. The easiest piece to compare is the Entry Number (Column A or B, depending on when you look).

While you're looking at this, what's the best way to ensure anything over 1 year old is always a part of the created, random list?

Thank you.