automation /VB code to extract data from a list table

[Birinder]

Hi all,

I need help to extract data out of a piviot table automatically.

I have the pivot table as a table :

suplier (All) ----------> drop down list to select customer name

table1: table 2

clum 1 clum 2 clum 3 clum1 clum2 clum3

vol

rate

%


so if i select (ALL) and drop down and select single customer ,, both table values change for that selected customer.


Right now i have to select one customer at a time , copy that table, and send that information to that customer.

I need some type of automation where a macro can select each customer at a time, and save the tables for that customer in seperate excel sheet.

Any help will be appreciated.

Thanks!!!

 

[vrunda]

hello Birinder,

http://forum.chandoo.org/threads/cr...sing-entries-in-a-data-validation-list.11701/
See if this helps

 

[Debraj]

Hi Birinder..

Can you please upload a sample file..

Infact.. double click on any customer name .. will do the same for you.. extract the customer data for the same..

I know.. Pivot Table already have that feature to extract each customer's data separately..
Play with this feature.. no VBA required..

 

[Birinder]

Hi Birinder..

Can you please upload a sample file..

Infact.. double click on any customer name .. will do the same for you.. extract the customer data for the same..

I know.. Pivot Table already have that feature to extract each customer's data separately..
Play with this feature.. no VBA required..

View attachment 8361

Hi Debraj,

I want to save each customer information on separate PDF. I know in excel within pivot table there is a option that split each customer information on separate tab. But I want it to save it as individual sheet or pdf for each customer. here is a sample pivot table:



Broker Number (All)
Values Col1 Col2 Grand Total
Volume 15.00 22.00 37.00
Numeric Rating 1.00 0.91 0.95
Premier Service % 100.00% 90.91% 94.59%



Appreciate any help.

Thanks,

Birinder