how to automatically display data from moving cells

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of copy/pasting data and retrieving results 0
How do I clear a form? 0
Pull Data With IF Statement And Sort. 1
display text in a cell in a range of cells 1
Excel: want a cell reference to another sheet that won't move! 2
Automatically plotting one cell from newly completed sheets 1
Can the data validation list range of one cell be driven by thecontents of another cell? 3
Zeros Display On Chart 0

Top