PDA

View Full Version : Creating a Pivot table from two or more worksheet



paradise
07-02-2017, 01:52 AM
Hi,

I have a two worksheet name PI and An.How can I create a Pivot with the help of a macro taking into the assumption the label are matched to the extent in one or the other based on availability of the data.Here,currently,I have highlighted which is required but I would require further so feasibility of code also would be preferred.

Thanx in advance.

Aussiebear
07-02-2017, 02:16 PM
Posted this anywhere else paradise?

paradise
07-02-2017, 07:16 PM
Posted this anywhere else paradise?
Yes.Still over few forums posted but I could not be able to achieve the results.The links where I have posted are :http://forum.chandoo.org/threads/creating-a-pivot-table-from-two-or-more-worksheet.34916/#post-208501 and https://www.excelforum.com/excel-programming-vba-macros/1191210-pivot-table-from-two-or-more-worksheets.html#post4688854

paradise
07-03-2017, 09:01 AM
I am still waiting. Hoping a positive response.

Aussiebear
07-06-2017, 07:03 PM
It seems to me that you might have received a better response if you had indicated (in your first post to this thread), that you had posted the issue on other forums.

paradise
07-06-2017, 07:15 PM
No,I haven't recd any response to my queries raised till now including any other forums posted so far,otherwise it would have marked as solved.
I am still eagerly waiting for the response specifically for this post.

mdmackillop
07-07-2017, 01:27 AM
Never done it but I would start here (https://support.office.com/en-gb/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5)

paradise
07-07-2017, 04:13 AM
Never done it but I would start here (https://support.office.com/en-gb/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5)

I have tried that but could not able to do so ?

mdmackillop
07-07-2017, 04:50 AM
It looks like you need to set up your tables in a particular way. Your sample does not show that configuration.

paradise
07-07-2017, 10:06 AM
yeah I think so.Plz close this thread.

mdmackillop
07-07-2017, 10:45 AM
Closed as requested.