Couldn’t you just edit the sheet name “BASE” to the new sheet name, from the VBA screen?
Or See this link on how to copy macros to other worksheets. http://office.microsoft.com/en-us/excel-help/copy-a-macro-module-to-another- workbook-HP010014116.aspx ~S From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Saturday, July 09, 2011 10:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ***Macros require to create Pivot Table*** Hi Ashish, Thanks, It is working prefect! A small request, It is working only the data sheet name is "BASE" Can you help me if the name of the sheet is different, then how to use this macro. Because same workbook am adding the data on daily basis. Kindly do the needful. Regards, Prabhu -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel