I need to select and copy 100 random cells from an external workbook that has
data arranged in columns. The columns contain roughly 25,000 entries,
including a few blank cells. From the column I need to select 100 random
unique cells (non-blank) and copy them into a destination workbook. Is there
a way to use a worksheet function or a series of functions to achieve this
result?