excel.advanced.course - Pivot Table

The UK's most regular instructor-led training courses.
Training information: excel.advanced.course · Excel training london · VBA courses London

Resolved · Low Priority · Version Standard

Pivot Table

Hari has attended:
Excel Advanced course
Excel VBA course

by - delegate Hari [2 posts] (2008 Jan 28 Mon, 11:22) Reply

How can Objects, Method, Properties aspect of VBA related to Pivot Table.

Also, can a list fuction used on Pivot table?.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Pivot Table

by - trainer Stephen gold contributer [326 posts] (2008 Feb 10 Sun, 09:44) Reply

Hi Hari

Thankyou for your question

The object model that relates to the PivotTable contains the following objects

PivotTable
PivotCache
PivotField
PivotItems
PivotChart

Each object has a range of properties and methods.

For example the PivotField object has an orientation property which is used to specify if it is in a column, row, pagefield, or data. The same object has a number of methods including Delete, AddPageItem and autosort

As to your query about list functions could you clarify what you wish to do with the list box and how you want it to relate to the PivotTable

Regards

Stephen

· Reasons Why VBA for Excel Training Fails
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Fun Things I've Done With Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Prepare for your MOS Certification with MS Excel Courses

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips