+ Reply to Thread
Results 1 to 8 of 8

Cell references across several sheets rolling into another

  1. 07-01-2019, 09:22 AM #1
    Malcolm66
    Malcolm66 is offline
    Registered User
    Join Date
    07-01-2019
    Location
    Aberdeen, Scotland, UK
    MS-Off Ver
    O365, Excel 2016
    Posts
    11

    Cell references across several sheets rolling into another

    Hi all,
    I'm trying to get to a point where I can add a worksheet to an existing workbook and have a sheet/cell reference auto populate. For example I have a sheet "Summary" which takes a value from cell c7 on sheet 123456-1. I need to make a copy of 123456-1 (call it -2 for this example) and change the data on that sheet. I want the Summary sheet to populate the data from 123456-2 cell c7 in the cell immediately below that where the -1, cell 7 data is. I'm using a listsheets function to update the summary sheet as new worksheets are added.

    Thanks
    Malcolm66
    Reply With QuoteRegister To Reply
  2. 07-02-2019, 09:30 AM #2
    Malcolm66
    Malcolm66 is offline
    Registered User
    Join Date
    07-01-2019
    Location
    Aberdeen, Scotland, UK
    MS-Off Ver
    O365, Excel 2016
    Posts
    11

    Re: Cell references across several sheets rolling into another

    After re-reading my post, I'm not sure I understood it myself..

    I've attached an example, what I need is to have the Sourcing Summary page automatically put the same formula as currently sits in cell C7 into cell C8 when the sheet is created. Is there a way to do that please?

    Thanks
    Malcolm66
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 07-02-2019, 09:32 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is online now
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Cell references across several sheets rolling into another

    I guess this thread should be placed in the VBA forum?
    I'll move it
    Cheers
    Reply With QuoteRegister To Reply
  4. 07-02-2019, 09:37 AM #4
    Malcolm66
    Malcolm66 is offline
    Registered User
    Join Date
    07-01-2019
    Location
    Aberdeen, Scotland, UK
    MS-Off Ver
    O365, Excel 2016
    Posts
    11

    Re: Cell references across several sheets rolling into another

    Ah, sorry about that, thank you
    Reply With QuoteRegister To Reply
  5. 07-05-2019, 01:41 PM #5
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,542

    Re: Cell references across several sheets rolling into another

    As the worksheets in the file attached to post #3 are in the same workbook, the following will work:
    Paste the following into cell C7: =IF(ISTEXT(B7),INDIRECT("'"&B7&"'!R3"),"")
    Drag the fill handle down to cell C8
    Note that this assumes that the quantity of sourcing costs is in cell R3 on every sheet.
    Let us know if you have any questions
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  6. 07-08-2019, 03:31 AM #6
    Malcolm66
    Malcolm66 is offline
    Registered User
    Join Date
    07-01-2019
    Location
    Aberdeen, Scotland, UK
    MS-Off Ver
    O365, Excel 2016
    Posts
    11

    Re: Cell references across several sheets rolling into another

    JeteMc - Thanks very much for your response, It worked exactly as I wanted it to.
    Reply With QuoteRegister To Reply
  7. 07-10-2019, 07:08 PM #7
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,542

    Re: Cell references across several sheets rolling into another

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
  8. 07-11-2019, 02:57 AM #8
    Pepe Le Mokko
    Pepe Le Mokko is online now
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Cell references across several sheets rolling into another

    Moved back to Formula forum
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linked sheets, cell references help
    By Jetstar77 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-08-2018, 05:30 AM
  2. How to save cell references when replacing sheets in a workbook
    By bcsapper in forum Excel General
    Replies: 3
    Last Post: 12-30-2010, 05:23 PM
  3. cell references between sheets
    By cheyenne10 in forum Excel General
    Replies: 5
    Last Post: 11-12-2009, 09:08 PM
  4. Putting formula in a cell which references other sheets
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-11-2009, 09:54 PM
  5. Changing Cell References after copying sheets
    By ChemistB in forum Excel General
    Replies: 5
    Last Post: 10-16-2007, 04:40 PM
  6. rolling sheet references
    By ScottyC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2006, 03:55 AM
  7. cell references to different sheets with lists
    By TheIrishThug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2005, 10:44 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1