I've not tried it with charts, but whenever you do a find/replace (ctrl-h) there is an option to look in formulas.
You could copy the sheets, then use find/replace to replace references to Info4 with Info3, etc. Paul ________________________________ From: David Lanne <djl99_28...@yahoo.com> To: excel-macros@googlegroups.com Sent: Thu, April 7, 2011 5:51:07 PM Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro I have a similar issue. I have 4 workbooks basically (dumb info 1, dumb info 2, etc). The layout/format of the four are the same. The first 76 sheets of each book contains the data. Another 5-10 sheets are use to consolidate. With dumb info 4 I got playing around with graphs and charts. So I have additional 16 pages (1 for each widget) that contains the 76 line item results of each. Since dumb info 4 has only used 30 of its 76 sheets I've been using dynamic cells to update my charts and stuff. Now I want to go back to the earlier 3 wookbooks and incorporate the new sheets I made in dumb info 4. When I go to copy and paste. All the formulas still reference dumb info 4. Without having to go into each formula and change the dumb info 4 line, there must be an easier way? --- On Wed, 4/6/11, ashish koul <koul.ash...@gmail.com> wrote: >From: ashish koul <koul.ash...@gmail.com> >Subject: Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro >To: excel-macros@googlegroups.com >Date: Wednesday, April 6, 2011, 11:36 PM > > >see if it helps > > > >On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH <comeonove...@gmail.com> wrote: > >Here is the file: >> >> >> >> >>On Wed, Apr 6, 2011 at 7:01 AM, qcan <comeonove...@gmail.com> wrote: >> >>Hi, >>> >>>I have this great Monte Carlo Simulation program for blackjack. I am >>>not all that good in VBA, but would like a small macro to run this >>>program, the copy and paste the results to another sheet, then repeat >>>that task again for as many times as I wish. >>> >>>Any takers ? I can forward the spreadsheet to you as I cannot seem to >>>attach it here. >>> >>>Thanks. >>> >>>-- >>>---------------------------------------------------------------------------------- >>> >>>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 >akoul.wordpress.com >My Linkedin Profile > >PBefore 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 > -- ---------------------------------------------------------------------------------- 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
