+ Reply to Thread
Results 1 to 8 of 8

Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id based)

  1. #1
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id based)

    (Sheet Attached for clear view)..
    I have sheet1 having 4 columns which stores large data about tasks we perform.
    First column stores id (number) of the task, 2nd column stores TITLE, 3rd- Completed work, 4th- Remaining work.

    In sheet2 There are same 4 columns but only one row.
    Assume that row is changing after every two minutes. The id, title, completed work and Remaining work is changing.
    What i want is, whenever any change happens in this row. i.e. cells A2, B2, C2 and D2 in sheet2,
    The task only with the same id in Sheet1 Should also change its other information. i.e. Title, completed work and Remaining work in sheet1 with same id only should change.
    So we have to first search for the same id in Sheet1, Column A which was changed in cell A2 in Sheet2 And then make other changes in row.

    Please give me some idea how do i do it...
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    Changing Values in 4 cells in Sheet1
    Attached Files Attached Files
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  3. #3
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    Thank you Kamboj that works...
    But is there any way to do it without hitting enter button every time value changes.
    Actually some other function is changing the values in sheet2, row 2.
    I want that automatically sheet1 data should update without having to hit enter button.

  4. #4
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    if you want to change value without button then use this code in worksheet change event
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    if you want to change value without button then use this code in worksheet change event
    Please Login or Register  to view this content.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    Maybe this:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    Thanks for the help

  8. #8
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Changing Values in 4 cells in Sheet1 Whenever value in 4 cells in Sheet2 changes(Id ba

    Glad to help you.

+ 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. [SOLVED] copy cells from sheet1 to specific cells in sheet2 based on date and time of day
    By Dj Duck in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2016, 06:01 PM
  2. Replies: 3
    Last Post: 09-24-2015, 08:20 AM
  3. [SOLVED] Macro to compare Sheet2 values with Sheet1 cells range (combined with Name Manager)
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2014, 08:26 AM
  4. Replies: 3
    Last Post: 10-09-2013, 02:29 PM
  5. [SOLVED] Look for values in sheet1 (input) and paste output in dedicated cells in sheet2
    By dnlwstr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 06:38 AM
  6. Compare 2 cells on sheet1 with 2 cells on sheet2 and copy unmatched rows to sheet3
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2010, 07:56 AM
  7. Transpose values all cells from Sheet2 to Sheet1
    By bdb1974 in forum Excel General
    Replies: 2
    Last Post: 12-16-2008, 10:47 AM

Tags for this Thread

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