hello,

i have the following problem :

i am using extremely large excel sheets with specific data in it.
i can report approx 10 weeks into one sheet before it is full. then i
need to use a 2nd sheet.

i want to combine those sheets into 1 pivot table, but the layout of
the sheets is exactly the same (and that should stay this way)

when creating a pivot table with multiple ranges i get an error
message that there are similar column names. is there a away to allow
this and to combine those columns ?

for example in sheet 1 there is a lot data from week 1 to 9.
sheets 2 is containing data from week 9 to 19.

so for week 9 there data in both sheets.
i want to create a pivot table that combines this.
so 1 column name with week 9 and from there the calculation from both
sheets.

is that possible ?

thanxxx a million !!!

The only option I can think of is to import those two tables into Access,
create a Union query and run the pivot table off that union query as your
data source.

You may be able to use Excel's MS Query tool to do a similar thing, however
I've never used it.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"(E-Mail Removed)" wrote:

> hello,
>
> i have the following problem :
>
> i am using extremely large excel sheets with specific data in it.
> i can report approx 10 weeks into one sheet before it is full. then i
> need to use a 2nd sheet.
>
> i want to combine those sheets into 1 pivot table, but the layout of
> the sheets is exactly the same (and that should stay this way)
>
> when creating a pivot table with multiple ranges i get an error
> message that there are similar column names. is there a away to allow
> this and to combine those columns ?
>
> for example in sheet 1 there is a lot data from week 1 to 9.
> sheets 2 is containing data from week 9 to 19.
>
> so for week 9 there data in both sheets.
> i want to create a pivot table that combines this.
> so 1 column name with week 9 and from there the calculation from both
> sheets.
>
> is that possible ?
>
> thanxxx a million !!!
>
>