I have been reading all the advice and tips posted on this group and it
is fantastic!! I now have a query of my own:

I have one sheet where these calculation I am doing go down onto forty
rows say:

Sheet1
A
1 0.1
2 0.4
3 0.8
4 1
5 1.5
6 2
7 4

Than I want to reference that list in another sheet but they should
move along columns so:
A B C D E
F
1 0.1 0.4 0.8 1 1.5 2

So far i tried by writiing

=Sheet1!$A1 and then dragging it along the other columns with the
hope it fills all the others up and changes accordingly. Unfortunatly,
it doesn't change ! If Ii drag it downwards (along rows) it does work
so I assume its not mean to do it but I wonder if there is a way?

Can someone please help with any advice!!!

Thanks

Deba