Posted to microsoft.public.excel.programming

Chetu[_2_] Chetu[_2_] is offline

external usenet poster

Posts: 4

Creating Pivot through VBA

Hi I have an excel sheet linked to a database it gets updated every
week. I need to run a Pivot to get only the details of Supplier no.,
Material no and Product class out of 10 columns. The Pivot should come
in a new sheet. The number of rows will be dynamic.

Can anyone please give me a code with explanations.

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
Creating a pivot table	mcdanik	Excel Discussion (Misc queries)	1	April 6th 09 12:34 AM
Creating a Pivot Chart	D_Zsol[_2_]	Charts and Charting in Excel	0	October 22nd 08 06:12 PM
creating a pivot table from 4 pivot tables	phyllis W	Excel Worksheet Functions	0	October 12th 08 09:52 PM
Creating Pivot Tables	PGalla06[_11_]	Excel Programming	4	August 31st 05 10:26 PM
Creating Pivot Table with VBA	Eric Lecocq	Excel Programming	2	December 11th 03 01:53 PM

All times are GMT +1. The time now is 09:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us