Posts: n/a

Pivottable

1. How would I use macro to automatically update a pivot table when I have
made changes to the database sheet?

2. I have the following database,

Staff ID Dept Amount
AH100 AH 50
AH101 AH 100
LC100 LC 200

Is it possible to have a calculated field with the amount divided by the
number of staff in each department?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting in PivotTable	Aaron Howe	Excel Discussion (Misc queries)	5	July 12th 05 09:49 PM
Pivottable Dates	JayBee	Excel Discussion (Misc queries)	5	January 15th 05 08:43 PM
PivotTable canned functions	doco	Excel Discussion (Misc queries)	0	January 14th 05 03:52 PM
How do I set permanent secondary axis in PivotTable chart?	Microlong	Charts and Charting in Excel	3	January 8th 05 03:54 AM
pivottable - show all not appearing	HELP	Excel Worksheet Functions	0	November 9th 04 01:31 PM

All times are GMT +1. The time now is 09:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us