+ Reply to Thread
Results 1 to 3 of 3

Cells not updating their values based on the value from another sheet.

  1. 03-02-2020, 03:23 AM #1
    Giulio Severini
    Giulio Severini is offline
    Registered User
    Join Date
    02-19-2020
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    51

    Cells not updating their values based on the value from another sheet.

    Hi,

    I have two sheets in different workbooks:

    2020.02.28 - Daily Sheet
    WAGES 06 07 24.02 - 08.03

    I would like that, for example, cells from G5:G24 in WAGES 06 07 24.02 - 08.03 get their values from cells L6:L26 in 2020.02.28 - Daily Sheet.
    I have manually added the formula in all cells and it used to work.
    This morning, however, it does not.
    Indeed, I receive the following error:

    Publication1.jpg

    Attached you can find my sheets.
    Any help would be appreciated.
    Thank you and kind regards,
    Alberto
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-02-2020, 03:37 AM #2
    Giulio Severini
    Giulio Severini is offline
    Registered User
    Join Date
    02-19-2020
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    51

    Re: Cells not updating their values based on the value from another sheet.

    Sorry, IGNORE this thread, sheets are working.
    Regards,
    Alberto
    Reply With QuoteRegister To Reply
  3. 03-02-2020, 03:38 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,448

    Re: Cells not updating their values based on the value from another sheet.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    How to paste Power Query code ( by Olly)
    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. Unique values in cells in one sheet based on another cell
    By davyd995 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2018, 11:36 PM
  2. Automatically sort cells in one sheet based on values in another
    By tubells in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-10-2016, 12:24 PM
  3. Compiling Data From Source Sheet Based on Values in 2 Cells
    By votekinky06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2015, 06:54 PM
  4. Updating multiple cells based a master sheet and showing results in a User Form
    By katkins0429 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2013, 05:18 AM
  5. Insert New row in another sheet and Loop based on values in certain cells
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-14-2013, 02:25 PM
  6. [SOLVED] VBA to Copy cells to another sheet based on two values
    By stevemills04 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2013, 05:43 PM
  7. Formatting cells in one sheet based on their values in another sheet
    By bwlodarczyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2012, 11:07 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