how to automatically display data from moving cells

  • Thread starter Thread starter mike CBA
  • Start date Start date
M

mike CBA

how do i automatically display a data that comes from a moving cell in a
column. for example, cellA1 is supposed to display the last entry of
columnBn. entries in column B change daily. Day 1 : cellA1 must display data
in cellB1. day 2: cellA1 displays cellB2. day 3: celllA1 displays cellB3 and
so on. What is the formula?
 
Back
Top