Dear André Luiz D´Avila,
Thanks for giving your valuable time for giving reply on my post. But what
you replied is very simple and known to be but not useful as because: -
1. The examplese (i.e. columns) in both purchase & sale sheet will be more
than 50 per sheets. and that too different from e
Refer below link
https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5
On 13-Mar-2015 7:12 pm, "B Sharma" wrote:
> Dear All Excel Experts,
> From a very long time, I am trying to create a pivot table using two or
>
Hello,
You have a excel sheet with table "purchase" and other one with "Sales".
In order to combine both of them, the fast way is to create a 3 sheet.
In that third one, create another table. Paste de "purchase table" and
below paste the Sales table.
After that create a Pivot using this new tabl
Dear All Excel Experts,
>From a very long time, I am trying to create a pivot table using two or
more tables, but not getting appropriate results.
Please help me , if anybody has ever done so.
For e.g. in one table there are purchase details and in another column
there are sale details..
I wan
com
> *Subject:* $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS
>
> ** **
>
> Respected Experts,
>
>
> ** **
>
> Is it possible to create a pivot table taking dat
Respected Experts,
Is it possible to create a pivot table taking data (or fields) from
different sheets of the workbook.
Regards,
P.VIJAY KUMAR
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum