Referencing a Moving Range on One Worksheet in Another Worksheet

[SDruley]

I have two worksheets A and B
Worksheet A has a range of values as follows:
R S
4 2.1 3.1
5 1.9 3.2
6 2.4 3.9
7 2.3 3.6

The above range has an INDIRECT REFERENCE as follows R4:S7 stored in cell W1
As data is added to columns R and S, the INDIRECT reference may read, for example,
R21:S24, so, we are keeping track of the last 4 sets of numbers.

How can I get this moving range of numbers to appear in a fixed location somewhere in Worksheet B? My repeated attempts have only brought over zeros.

[Cutter]

Assuming your data starts in R2 and all values are numeric

Use this to get first value (4th from last):
=INDEX(SheetA!R:R,COUNT(SheetA!R:R)-2)
For 3rd last:
=INDEX(SheetA!R:R,COUNT(SheetA!R:R)-1)
For 2nd last
=INDEX(SheetA!R:R,COUNT(SheetA!R:R))
For last:
=INDEX(SheetA!R:R,COUNT(SheetA!R:R)+1)

Select those 4 cells and drag to right one column

[SDruley]

Mr. Cutter,

You are the cutting edge. WOW!

[Cutter]

Glad it works for you.

Don't forget to mark it as SOLVED (see FAQ for directions).