+ Reply to Thread
Results 1 to 6 of 6

Record Changing Values In A Cell

  1. #1
    Registered User
    Join Date
    12-21-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    42

    Record Changing Values In A Cell

    Hi,
    I am getting second to second data in excel workbook. I want to record this data in another cell. The changing values keeps on going higher high or lower lows. I want highest high in one cell and lowest low in another cell. For example suppose changing value is now 15954. It keeps on changing second to second. Suppose at next second it could be 15956 or 15950. I wanted to record made if lower than previous value in one cell. And also wanted to record if it made new high than previous value in another cell.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: Record Changing Values In A Cell

    It depends on how the change in a cell hapens - is it really written there or is it a result of formula? Let's assume former one.
    Such VBA event handler in a worksheet code module would do the job
    (try changing A1 value and observe B1 and C1):
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-21-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    42

    Re: Record Changing Values In A Cell

    Thanks Kaper, I will observe in coming days. But I forgot to mention one more thing is that I need daily ( today's ) fresh high or low. Suppose yesterday's start at 15945.47 and made high 15962.59 and low made 15881.56 and if close at 15930.58. From next day it will start from 15930.58, I need today"s fresh high or low. Yesterday's high or low should show in separate row or column as previous day high or low.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: Record Changing Values In A Cell

    Then at the start of a new day copy old low/high values to different cells and clear contents (delete) B1:C1 they will be filled with that day low/high values

  5. #5
    Registered User
    Join Date
    12-21-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    42

    Re: Record Changing Values In A Cell

    Yes will do, but can we do automatic update in separate cell ?

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: Record Changing Values In A Cell

    Sure,
    It can also be done automatically.
    I'd probably use separate cells (column?) with say one month of dates and refer to today() to use appropriate cells for low/high

+ 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] Save / record dynamically changing values of a cell in a column with date time stamp
    By EEEHHH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2019, 06:50 AM
  2. Record a changing cell value at the end of each month
    By Samboco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2019, 07:04 AM
  3. [SOLVED] Save record depending on cell values and if record already exists
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2016, 06:14 PM
  4. [SOLVED] automatically record data from a changing cell
    By rhaxx in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-10-2015, 08:40 AM
  5. Continuous changing cell values - record highest and lowest values in seperate cells
    By attienel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 05:12 PM
  6. [SOLVED] VBA to record cell reference values as text and record change
    By Katie O in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2013, 12:14 PM
  7. How to record a changing cell
    By simmo86 in forum Excel General
    Replies: 2
    Last Post: 02-29-2012, 05:22 PM

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