Hello to all!

I want to start an inventory cycle count program in my company. How can Excel be used to do random selection? The only data I currently have is a listing with the following headings:

1) Part Code
2) Part Description
3) Location Code
4) Quantity on hand
5) Unit Cost
6) Total Cost
7) Cateogry

The accounting software does not provide, currently, a usage report that I use to apply ABC method of selection items.

Any suggestions from Excel using inventory gurus would appreciated.

Thanks
SJ