+ Reply to Thread
Results 1 to 2 of 2

Help a brotha out on linking to other worksheets!

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    Wakarusa, Indiana
    MS-Off Ver
    2010
    Posts
    9

    Help a brotha out on linking to other worksheets!

    Hey guys, so I am trying to create a workbook that links a certain row from a worksheet to a certain row on another worksheet. However, the kicker is that I need it to be able to link to worksheets that have not been created yet. For example, I need the code to logically read like "If A3 (A job identification number) is equal to a worksheets name (the same job identification number) then link cells from that worksheet to this one." Also, if this helps, the new worksheets that will be created are created using a template. Thanks so much for your help in advance! And if I need to clarify anything please let me know!

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Help a brotha out on linking to other worksheets!

    This will pull the data from cell A1 from the sheet named in cell A3. If the sheet named in cell A3 does not exist, then the cell is blank.
    =IFERROR(INDIRECT(A3 & "!a1"),"")
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. Replies: 0
    Last Post: 04-04-2012, 08:12 AM
  2. Linking Worksheets
    By Pelican in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-09-2010, 12:06 PM
  3. Replies: 3
    Last Post: 02-11-2007, 10:17 AM
  4. [SOLVED] Linking worksheets
    By ghost635 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-19-2005, 04:06 PM
  5. Linking worksheets
    By ghinton in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-08-2005, 03:09 PM

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