you wont get sheet2!$A$3,sheet2!$B$3 etc by dragging down,dont you mean
across???
you need to make each formula absolute then do a copy then paste special,and
tick the transpose box.Your source range and destination range cannot
overlap,perhaps you could then delete the original range and cut the newly
transposed range up a cell or two
--
paul
remove nospam for email addy!



"Sal" wrote:

Hi
I am trying to link values between 2 worksheets. I have to pick up several
cells and repeat the value in another cell in another worksheet. I have data
in, for example cells A3 to Z3 in a spreadsheet which needs to be picked up
in another workbook area. I am sure there is a way of setting an absolute
formula so that when I drag the formula down it shows =BREAKDOWN!A3,
=BREAKDOWN!B3,=BREAKDOWN!C3 ETC and not =BREAKDOWN!A3, =BREAKDOWN!A4,
=BREAKDOWN!A5. No matter where I put the $ it does not work. Anybody any
ideas please.
Thank you very much. S