Autofill with falling references

[Tompanilla]

Hi!
I am doing a sheet with references taken from another sheet.

The sheet I use should look like this:

1 2 3
=sheet1!B11 =sheet1!B10 =sheet1!B9 aso.

When I use the autofillhandle I dont get the fill as I like.
Is there a simple way to autofill when the sheetselection cell is in falling order?

Brgds

Thomas

 

[onlyadrafter]

Hello,

In A1 of sheet 2 enter this formula

=INDIRECT("Sheet1!B"&13-COLUMN())

and then copy across.

Is this working as expected?

 

[Tompanilla]

Thanks!
It works fine!