+ Reply to Thread
Results 1 to 3 of 3

Referencing a Different Sheet for all the formulas in a copied graph

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    Detroit, Michigan
    MS-Off Ver
    2010
    Posts
    2

    Exclamation Referencing a Different Sheet for all the formulas in a copied graph

    Hi,

    I have multiple sheets with the same exact layout but different data. Let's just call the first two "Sheet Hockey" and "Sheet Football".

    I then made a line graph for Sheet Hockey and moved it to its own sheet called "Hockey Graph". Next, I created a copy of "Hockey Graph" and labeled it "Football Graph". Instead of having to go through and change every formula from "='Hockey Graph'!$D$40:$D$70" to "='Football Graph'!$D$40:$D$70" individually I have been trying to write a VBA code to do do this for me and have searched for this question here but couldn't quite find what I was looking for.

    Could someone help me with this code to replace all of the sheet references so I can make multiple graphs much quicker?

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Referencing a Different Sheet for all the formulas in a copied graph

    You can use Find and Replace for this.

  3. #3
    Registered User
    Join Date
    11-04-2014
    Location
    Detroit, Michigan
    MS-Off Ver
    2010
    Posts
    2

    Re: Referencing a Different Sheet for all the formulas in a copied graph

    This doesn't seem to work for Microsoft 2010. Maybe I'm doing something wrong but I used to use that but can't get it to work now.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copied macro keeps referencing original worksheet?
    By c2q in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2012, 10:28 PM
  2. Multi Sheet Referencing for Formulas
    By Follychops in forum Excel General
    Replies: 13
    Last Post: 05-26-2011, 03:11 AM
  3. Referencing variable sheet names in formulas?
    By Alabaster in forum Excel General
    Replies: 1
    Last Post: 04-24-2010, 11:20 AM
  4. Formulas for referencing data from another sheet
    By lukasj13 in forum Excel General
    Replies: 3
    Last Post: 11-21-2008, 02:29 PM
  5. [SOLVED] Delete the formulas of webpage, copied & pasted on excel sheet
    By Mustafa Abedin in forum Excel General
    Replies: 1
    Last Post: 06-19-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1