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.
Posted this anywhere else paradise?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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/cre...6/#post-208501 and https://www.excelforum.com/excel-pro...ml#post4688854Originally Posted by Aussiebear
I am still waiting. Hoping a positive response.
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
Never done it but I would start here
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I have tried that but could not able to do so ?
It looks like you need to set up your tables in a particular way. Your sample does not show that configuration.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
yeah I think so.Plz close this thread.
Closed as requested.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
