previous cell value

  1. P

    Calculation based on previous transactions

    Hi, I have a problem to solve. I have a data set of 7000 transactions and I need to calculate the amount for each transaction as per below formula. Please note that calculation will be done basis of account number. <tbody> Account Number Value Percentage Amount ABC 1000 0.1 =(B2)*C2-0...
  2. H

    Store a cells previous value

    Hello, I have a spreadsheet populated with data and some pivot tables, this then feeds a widget on a dashboard with a total. My widget has the ability to calculate the % up down and change its background colour accordingly. How can I retain the previous total of a pivot table in the...
  3. A

    Keep Previous Value of Cell

    Hi there, I have two columns, let's call them Event Date (Column A) and Previous Event Date (Column B). I would like to implement some VBA code (or use formulas if necessary) that automatically keeps the previous value of Event Date and retains it in the adjacent cell for Previous Event Date...
  4. D

    finding previous cell value when there are blank cells between

    I am looking to put a formula using VBA code into all cells of a column(column B), which would populate column B only based on the value of another cell in column A. I am having difficulty referencing the previous cell up in a column to get its value when there are blank rows involved. As you...
  5. R

    Capture Old Cell Value - VBA

    Hi Everyone! I would really appreciate some help with this one. I am trying to hide a worksheet using the old value in a cell and then unhide another worksheet using new value in the cell. I want this event to be triggered by a change in cell "O11" (generated from a formula). I have tried...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top