Hi All,
I want to create pivot table with macro. I want to select Table/Range (marked rows) and Where I want to the pivottable report(Existing Worksheet Location in same sheet). I added my file and codes with pivot table field list . Could you please help me regarding this case. Thank you in advance.
Last edited by elevisse; 10-25-2012 at 02:05 AM.
Hi All,
I would like to share below codes with you. It works after one's own hear but I want to use same sheet for pivot table (for example Data1 or Data2), If I select some rows (for example between 1-5), run pivot table only for this rows. I also want to select where is locate the pivot table in Data1 or Data2 ( for example message box write B10). Lastly I want to use same macro for Data1 and Data2. I mean sometimes I have to use Data1, sometimes Data2. I hope My explanations are clear for you. I have already updated file. Could you please help me regarding this topic. Thank you in advance.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks