+ Reply to Thread
Results 1 to 5 of 5

(How to) If cell value changes, copy value to another cell?

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    (How to) If cell value changes, copy value to another cell?

    Hi there,

    I would like to know if its possible to do the following:

    As the title says I want to copy a value from one cell to another if that value changes. In this case I have a timer in cell E5 which counts down each second therefore changing the value each second. I'd like to use this as a trigger of sorts to copy the value of other cells when the value in E5 changes e.g. When E5 changes value copy value of J5, O5 etc.. into a new column. I have 10 cells in total that I would like to copy the data from using E5 as the trigger to do so.

    In addition to this I don't want the updated value to overwrite the previous value, for instance if I choose cell H20 as the destination cell for the data to be copied into when the value changes again and gets copied I'd like the data from the previous update to move down one row so the data in H20 would move down to H21 and so on down with each update. This would mean if the value updates 60 times at once every second I would then have 60 rows of data to analyse.

    I have zero coding experience and this is rather daunting to me so I hope I've explained clearly enough what I want to achieve.

    Thanks for your time
    Pat

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: (How to) If cell value changes, copy value to another cell?

    @PatR78

    What is differant to the earlier asked question in the link below.

    https://www.excelforum.com/excel-gen...ml#post4720386
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Re: (How to) If cell value changes, copy value to another cell?

    Hi,

    Its a completely different approach. I realise now I was over complicating things that way and probably wasn't been very clear.

    This way would be copying data from one cell as opposed to copying rows of data.

    That thread can be closed as I think this is the way to go.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: (How to) If cell value changes, copy value to another cell?

    You can mark the question solved yourself.

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

  5. #5
    Registered User
    Join Date
    08-10-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    11

    Re: (How to) If cell value changes, copy value to another cell?

    Ok done thanks

+ 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 Cell From One Cell and Paste to next blank cell, Loop until last row/column
    By Beginner Level in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2020, 02:38 AM
  2. [SOLVED] Loop copy cell of range to 1 cell, and so on till cell empty
    By countryfan_nt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2017, 02:33 AM
  3. Replies: 13
    Last Post: 11-26-2014, 05:29 PM
  4. Replies: 1
    Last Post: 11-06-2013, 02:56 AM
  5. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  6. copy a specif cell value, find another like that in sheet copy adjacent cell and pate
    By smwaqas89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 10:00 AM
  7. Replies: 3
    Last Post: 07-15-2010, 08:49 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