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