Cycle Count Excel Work Book

I need a marco to randomly select 42 or so lines from 2 different columns and put them into a template on a new sheet in the same workbook with fields for QTY and DATE, the item numbers and bin locations will come the first sheet. The items selected have to be different everytime unitl the list is complete, then start all over