at the top of code
'declare s as worksheet
Dim s As Worksheet
Set s = ActiveSheet
replace Sheets("BASE") with s in code with find and replace
note before running the macro select the data sheet
On Sun, Jul 10, 2011 at 12:34 AM, Susan <sunni...@gmail.com> wrote:
> 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
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
http://akoul.posterous.com/
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
P Before printing, think about the environment.
--
----------------------------------------------------------------------------------
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
