I am helping a user who has a Workbook which contains multiple worksheets of
demographic information from the state. Each worksheet is from a different
county. They are wanting to select a random number of records from each
county (worksheet) for a mailing.

I tried the rand() command but that didn't do what we needed. I then
selected all worksheets and then selected every fifth record (holding ctrl)
but wasn't able to copy to another worksheet. So I named that range, thinking
I could merge into Word or Access selecting the range, but the named range
didn't appear when I tried to import.

Any ideas?