VBA

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Microsoft excel training · VBA courses London

Resolved · Low Priority · Version 2003

VBA

Jonathan has attended:
Excel VBA course
Excel VBA course

by - delegate Jonathan [1 post] (2008 May 1 Thu, 16:49) Reply

how do you change the fields in a pivot table without knowing the data field's exact name?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

Fields in a Pivot Table

by - trainer Carlos gold contributer [479 posts] (2008 Jun 3 Tue, 10:14) Reply

Hi Jonathan

I'm not too sure what you mean by this but, When a pivot table is created the headings found in the first row of the table are taken by Excel to be the Field Names and placed in the Pivot Table's Field Name List.

So by draging these names onto the Pivot table it will produce the required results

Hope this helps

Carlos

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· How to Create Better Excel Spreadsheets: Part Four
· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Microsoft Excel Features and Functions for Accountants

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips