Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macros

Resolved · Low Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Fri 21 Oct 2011: Automatically marked as resolved.

Excel articles

· How To Use The Subtotal Function In Excel
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Trust Excel To Protect Your Data
· Create Contrasting Coloured Rows In Excel
· How To Use Vlookup In Excel

Please browse our web site to find out more about
microsoft.excel.training and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips