Wed 12 Oct 2011, 09:56Delegate Lesley said...
Lesley has attended:
Excel Advanced course
Macros
we have to select random files for audit from existing databases, would a macro be able to be used for this purpose of random sampling
Fri 14 Oct 2011, 11:34Trainer Anthony said...
RE: macros
Hi Lesley, thanks for your query. That is possible, but it depends how random you want it! I would put hyperlinked filepaths in a series of cells in Excel and then use the walkthrough below to pick one at random.
http://www.ozgrid.com/Excel/excel-random-pick.htm
To open it, or pick it from a folder you'll need to pick up some VBA!
Hope this helps,
Anthony
