Thread: how to automatically display data from moving cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mike CBA mike CBA is offline
external usenet poster
  
Posts: 1
Default how to automatically display data from moving cells
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?
Reply With QuoteReply With Quote