+ Reply to Thread
Results 1 to 4 of 4

Updating a group of cells on several sheets at the same time

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    OK
    MS-Off Ver
    Google Sheets
    Posts
    14

    Updating a group of cells on several sheets at the same time

    Hello all,

    On Google Sheets - I have a budget in calendar format with a separate sheet for each month, with 3 columns out to the side on each monthly sheet that reflect our regularly reoccurring bills that I can just copy and paste into the the calendar. From time to time those columns change as expenses change etc. Is there a way to be able to update those 3 columns from any sheet in the budget that will update each sheet after that one, including deleting cells, changing values etc.? Basically so that I don't have to go copy and paste on each subsequent sheet if say, our phone bill goes up, or I pay an item off, etc.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,844

    Re: Updating a group of cells on several sheets at the same time

    Please update your forum profile to show Google Sheets as your Office version. I am moving this to the correct forum section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    OK
    MS-Off Ver
    Google Sheets
    Posts
    14

    Re: Updating a group of cells on several sheets at the same time

    Done, and thank you!

  4. #4
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Updating a group of cells on several sheets at the same time

    It will be a lot easier to try to provide help if you can first provide a sample file.

    To share a sample Sheets file anonymously, you can use this form to create a file into which you can build your sample:

    https://docs.google.com/forms/d/e/1F...VbWiA/viewform
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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. Updating two sheets at the same time
    By Sanchay_2107 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2019, 03:55 PM
  2. Updating cells through out all the sheets
    By Viswateja in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2017, 01:26 PM
  3. Possible to group only a range of cells across sheets
    By mcdmw in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-02-2015, 07:58 PM
  4. [SOLVED] Formula updating with referenced sheets cells
    By 8r3nd4n in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2015, 03:08 AM
  5. [SOLVED] Updating Cells Automatically Between Sheets
    By mattpark1994 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2014, 01:07 PM
  6. [SOLVED] I need to Sum a group of cells that varies each time
    By TheLittlePrince in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 11:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1