Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba for excel training - Pivot Tables

	98.1 % recommend us
	More live stats...

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

Training information:

vba for excel training - Pivot Tables

Resolved · Low Priority · Version Standard

Reply Wed 24 Oct 2007, 13:49Delegate Carl said...

Carl has attended:
Excel Advanced course

Pivot Tables

Can I select a greater area than the current information on th espreadsheet to ensure I capture all new data

For upcoming training course dates see: Pricing & availability

Reply Fri 26 Oct 2007, 17:09Trainer Amanda said...

RE: Pivot Tables

Hi Carl

Thank you for your question.

I'm not sure whether there would be an implications associated with selecting a larger data area than necessary for the pivot table.

What you can do is set up a dynamic data range, by creating a named range which will automatically expand itself. For further details on how to do this, please see www.contextures.com/xlPivot01.html

I hope this helps.
Amanda

Excel articles

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Flexible uses for Excel at Home
· Business Forecasting With Microsoft Excel
· Creating Error Alerts In Excel Using Data Validation
· Want To Use Excel To Calculate Your Mortgage Repayments?

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips