+ Reply to Thread
Results 1 to 7 of 7

Linking cell references

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Cambridge
    MS-Off Ver
    2010
    Posts
    4

    Linking cell references

    I have a workbook, basically of individual account details, but I also need a summary sheet with some information from the account details page. A bit difficult to explain but I shall try:

    The individual account details sheets would have name, address (in 4 separate fields) and a total box being the sum of sales on that sheet. These sheets would be added to as new accounts were set up.

    The summary sheet would have have columns for names, addresses and total boxes.

    The initial link would be in the format of =Example!E1 for the name, followed by =Example!F1; =Example!G1; =Example!H1; =Example!J1; etc for the details on each account.

    My question is: having entered the first link (E1) what formula could I use for the subsequent F1, G1, H1, J1 linked cells without having to link each cell from the new? For subsequent accounts I would then enter =Example2!E1 then copy across the relating cells from the row above.

    I hope this is clear!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Linking cell references

    Unless I'm totally mistrading your request; select your first linked cell. Click and hold (left button) on the small rectangle at the bottom riight of the cell and drag across. If I have mis-read your request, please post a sample worksheet.


    Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-25-2015
    Location
    Cambridge
    MS-Off Ver
    2010
    Posts
    4

    Re: Linking cell references

    Sorry, but I hadn't mentioned that there are details which aren't in the same row or column. Your suggestion will work for adjacent cells but not for the non-adjacent cells.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Linking cell references

    I'm not sure what you mean, then. So, please attach a sample sheet.

  5. #5
    Registered User
    Join Date
    11-25-2015
    Location
    Cambridge
    MS-Off Ver
    2010
    Posts
    4

    Re: Linking cell references

    OK, specimen attached.
    Attached Files Attached Files

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Linking cell references

    The information is a bit scattered!! I used a series of formulae using INDIRECT. They capture the sheet name from column J and copy the data across utomatically, but remain blank until a sheet name is entered and the sheet exists.

    Ttpical formula:

    =IFERROR(IF(INDIRECT("'"&$J2&"'!C1")=0,"",INDIRECT("'"&$J2&"'!C1")),"")
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-25-2015
    Location
    Cambridge
    MS-Off Ver
    2010
    Posts
    4

    Re: Linking cell references

    Thanks. I'll investigate more when I'm back in the office next week.

+ 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. Linking workbooks with absolute references
    By ppalmerirs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2014, 10:06 AM
  2. Replies: 0
    Last Post: 02-11-2013, 08:12 AM
  3. Linking or autocalculation for references in VBA functions
    By Mick S in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2011, 07:54 PM
  4. linking cell references to data in other worksheets
    By quanah in forum Excel General
    Replies: 2
    Last Post: 11-08-2009, 01:02 PM
  5. Replies: 1
    Last Post: 06-08-2009, 08:54 AM
  6. Macro Linking Checkboxes to Cells with Relative References instead of Absolute
    By nameyers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2007, 03:00 PM
  7. [SOLVED] How to rename references from range names to cell references
    By Abbas in forum Excel General
    Replies: 1
    Last Post: 05-24-2006, 01:25 PM

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