How to make PivotTables from data in one workbok and present it in another

[acidtest]

Hi,

I have this problem, sorry for bad English.

In one file there are data from which I want to have pivot table presented in another workbook. It should work like this:

Macro asks where is workbook from which pivot table will be created, what is the name of worksheet, than makes a pivot table from data from that worksheet (but the headings are in row 4) and paste it into source workbook (from which I stared a macro, in defined worksheet). Data for pivot table may have different number of rows, but the same number of columns.

Another thing is how to set up a pivot table the way I need using macros, cos it will be nice to have not one pivot table but different couple of them (which presents data differently).

Apart from that I need to copy the name of the source file, from which the data are taken into destination workbook, but different sheet from the one that pivot table are created? Lets say that the sheet is called "INFO" and the file name should be stored in A1 cell. And of course all of that in one macro.

I would appreciate any help!!

Jarek

[arlu1201]

It will be good if you attach a sample workbook with dummy data and also the structure of the pivot(s) that you need.