On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote: > > I posted this yesterday...it seems it did not get through..so posting once > again > > Hello All, > > I am using Excel 2010. I have a List of Names in Sheet name “List” > > > I have attached a file with two modules. > > > *Module1* Macro creates separate sheet with the names listed in the sheet > name List and copies Sheet Data for each name. > > > *Module2* makes Pivot Table on the Active Sheet. > > > My requirement is to amend the *Module2* as follows: > > 1) * **Module2* should loop through each name and create Pivot Table for > each sheet created and name it viz. Pivot created for Name1 should be > PivotName1, Pivot created for Name2 should be PivotName2 and so on. > > 2) The macro should exclude Data and List sheets. > > Any help would be appreciated. > > Thanks > > Rashid Khan >
-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
