Cell Reference to Display Data in Reverse Order?

I have some data on a sheet and want to display that same data on another sheet but IN REVERSE ORDER.

When you fill downward, each cell automatically refers to a cell that is one row BELOW the reference of the cell above it.

How can I make each cell refer to a cell that is one row ABOVE reference of the cell above it?

So, I start by saying B23 refers to B23...but then I want B24 to refer to B22, B25 to refer to B21, B26 to refer to B20, etc...

I obviously want to automate this so I don't have to manually create each cell reference individually.

Thanks!

Hi,

just put this in Sheet2!B23 and copy it down as far as you need (assuming that your data is in Sheet1):

=OFFSET(Sheet1!$B$23,23-ROW(),,,)

- Asser

C23 formula =INDIRECT("B" & 2*ROW(C$23)- ROW())

Problem solved...thank you!