1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Auto-updating multiple cells with same date

Discussion in 'Business Applications' started by StoryAngel, Jul 27, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    98
    I'm experimenting with dynamic ranges in Excel. I have a workbook with multiple sheets, and there's a repeated column in several of them which always have the same dates. Is there a way that I can update just one of the sheets, and use dynamic ranges in the other sheets so they auto-update? I can't quite figure out how to do it.
     
  2. terabytecomputer

    terabytecomputer

    Joined:
    Apr 20, 2009
    Messages:
    94
    If the date is in Sheet1, Cell A1 and you want the same date in Sheet2, Cell B4, in Cell B4 on Sheet2, put the following:

    =Sheet1!A1

    Do that for all cells that should show the same date.

    Is that what you're after?
     
  3. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    98
    Sorry, I didn't actually explain myself well. The date ranges change because I add to them. You suggestion works fine if it's for a fixed cell (or range) but what about if I add a date to Sheet 1 ... can I auto update that in Sheets 2-5? I thought that dynamic ranges (which I know can expand to fit the size of data) would help but I can't see how to implement it in this case. Can you use a dynamic range in the example you give, rather than an absolute cell value?
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    I can't see how to implement it in this case (without code) either. So: have you considered (i) grouping sheets 1-6 (ii) updating on sheet1 (iii) ungrouping?
     
  5. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    98
    Didn't know you could do that! :) Thanks - it'll work in cases where the dates are in identical cells on each sheet. It's certainly a workaround. Thanks.
     
  6. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    Use it with great care. Much mess can be created by forgetting to "turn off" grouping.

    ( :) )
     
  7. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    98
    Noted. I'll heed the warning! :)
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/846802

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice