Forum Discussion

Maksim757040's avatar
Maksim757040
Copper Contributor
Oct 12, 2021
Solved

Save Previous Cell Value Of A Changed Cell In Excel

I don't know English enough, but I will try to write quite good I wrote mtarler  in comments for the same topics.  I use Excel 2019 I need a macro for my job files. There is Excel book(For exam...
excel
Macros and VBA
  • mtarler's avatar
    mtarler
    Oct 15, 2021

    Maksim7570  I'm sorry, you did say you have Excel 2019.  see attached:

    I created formulas for 30 columns to see up to 30 days but you could fill right for more if needed.

    That said, in  previous post you said you wanted another value to the right of those cells and you said for example the data is in A:K and you would have something in L but that would have to be in AF or so to have up to 30 columns available for the data. Or incorporate that cell information as an alternative formula/data in the formula I created based on it being X columns more than then total requested...

     

mtarler's avatar
mtarler
Silver Contributor
Oct 13, 2021
can i ask you why you want to delete the older values/dates instead of just ignoring them?
My experience is that historical records can be very helpful to explain and or show proof later on.
Why not have a running list and on another sheet just present the latest 30?
  • Maksim757040's avatar
    Maksim757040
    Copper Contributor
    Oct 13, 2021
    It sounds interesting, and I think I don't mind this...
    But I want to change meanings(Now I want 30 meanings, next month I want to see 14 meanings etc.)
    If you can make it, I will be excited
    • mtarler's avatar
      mtarler
      Silver Contributor
      Oct 13, 2021

      Maksim757040  i still don't know what you really need but here is an example of what I mean.

      In the 1st sheet is a data entry table with date (you can enter today's date by holding CTRL and typing ; ).  Then maybe a couple columns of data (e.g. units sold, price/unit) then a column that has a formula to give you that final value you are interested in.

      On the 2nd sheet I have an input cell to easily change how many you want to view the last X number from the previous sheet).  

      • Maksim757040's avatar
        Maksim757040
        Copper Contributor
        Oct 13, 2021

        mtarler I explain,
        I work in a construction company. For example there is one work - Pile driving. Every day on a construction site workers drive piles and 1st day they drive 5 piles, 2nd day they drive 10 piles and etc. After I compare the actual work with the plan and change the percentage (percentage of completion) every day. the percentage - this is a formula and it changes automatically. And I want to save every the percentage every day. I want to save every day and meanings into my calendar.
        And sometimes I want to see history of 30 days, sometimes history of 14 days.
        And I want to date changes automatically every day(because it's a formula =NOW())
        For example
        Today 13.10.2021(A1) - 5 piles(B1). Tomorrow I want to see new date in A2 - 14.10.2021 and new B2 - 6 piles. This is a history of 2 days. In B1, B2 ... etc. there is formula and meanings update automatically from other files Excel. But the range is limited because the column E2(for example) contains today's value. And we have for example range between A2 and E2 (5 columns-5days). E2 should be always today's value. If columns A2-E2 contain the value of the latest dates, then tomorrow I want to see E2 = dates tomorrow, D2 = dates today, C2 = dates yesterday and values for each date, respectively
        And I want to change value of history's days(30days or maybe 14days).
        Excel book TV should show history of days, but meanings should update from Excel book PLAN.
        And if now day comes I want to Excel make a new columns


Resources