+ Reply to Thread
Results 1 to 7 of 7

How To Record Changing Values In A Cell In Excel

  1. #1
    Registered User
    Join Date
    04-23-2019
    Location
    Kuwait
    MS-Off Ver
    2013 - Excel
    Posts
    4

    Post How To Record Changing Values In A Cell In Excel

    I have a excel sheet where the stock values are updated on daily basis and a total sum is available of all stocks.

    How can I record the daily values (The total sum) in a different cell with dates on daily basis.

    Appreciate your help.

    data.png

  2. #2
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: How To Record Changing Values In A Cell In Excel

    Are you inputting the data manually?

    It would be helpful to attach a sample of what you're wanting with "fake" results. Label it according to what you want to happen.

    Based on the picture you attached... you want C5 to be saved below in C8 on a daily basis?

  3. #3
    Registered User
    Join Date
    04-23-2019
    Location
    Kuwait
    MS-Off Ver
    2013 - Excel
    Posts
    4

    Re: How To Record Changing Values In A Cell In Excel

    Thanks for the update.

    Data in Column C1 to C3 are getting updated daily. (I just refresh the data whenever i open excel)

    You got it right....C5 to be saved in below C8..C9..C10 & so on, on a daily basis.

    Thank you

    Attachment 678532

  4. #4
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: How To Record Changing Values In A Cell In Excel

    Your attachment didn't open. I recreated your picture.

    Probably not the textbook way of doing it, but it's a start. I changed your layout to put the newest date on top in C8. Once you have your new data input in C2:C4 hit the Archive button.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-23-2019
    Location
    Kuwait
    MS-Off Ver
    2013 - Excel
    Posts
    4

    Re: How To Record Changing Values In A Cell In Excel

    jme1013, that works absolutely perfect. Bravo for getting me right!

    I have a bigger lines of data. How you have coded the archive button. Would you mind in sharing the code.

    Thank you so much and i appreciate.

  6. #6
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Re: How To Record Changing Values In A Cell In Excel

    ivans26, glad it worked for you. With the workbook open, press alt + F11, this will step you into the VBA code.

    Here's what you're looking for.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-23-2019
    Location
    Kuwait
    MS-Off Ver
    2013 - Excel
    Posts
    4

    Re: How To Record Changing Values In A Cell In Excel

    Great. Thanks again.

+ 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. Record Changing cell value in excel .
    By debonilsaha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2019, 04:19 AM
  2. Record Changing Values In A Cell
    By watermasa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2019, 07:32 AM
  3. [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
  4. [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
  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

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