If you put
$$SheetA!A2
in B1
and use the autofill button on the bottom right corner to drag to the right,
you'll see:
$$SheetA!A2 $$SheetA!A3 $$SheetA!A4 $$SheetA!A5 $$SheetA!A6...

Then you can select that row and do:
edit|replace
what: $$
with: =
replace all




Ed wrote:

Thanks Tim, but I meant to drag rather than copy-paste special, like when you
put "=" and select a entry from other sheet then drag it downwards and you
get what the other column from the other sheet has, but "transposed" when I
drag horizontally I get what is vertically in other sheet.

The thing is that I need some entries as a row that are as column in other
sheet and I can't just copy-paste special because I have some other formulas
and things that would make it more difficult... sorry for not explaining
correctly on the first post!

I need

Sheet B:
B1 = SheetA!A2
C1 = SheetA!A3
D1 = SheetA!A4
E1 = SheetA!A5

and so on!

--

Dave Peterson