Hey All,
I have a small issue where I have created a worksheet called data and in
Cell A3 I have a linked cell to another worksheet and cell "WK48!A2" In
Cell A4 in the "data" worksheet I need a link to "WK49!A2". I would like
to link all cells in Column A to consecutively "WKxx" worksheet once I add
them to the workbook. I thought I could drag them mouse down but al I get is
links to consecutive cells in "WK48" work sheet.

Please help

mag()()

Try

=INDIRECT("'WK"&ROW(48:48)&"'!A2")

--
Regards,

Peo Sjoblom

(No private emails please)


"Mag()()" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hey All,
> I have a small issue where I have created a worksheet called data and
> in Cell A3 I have a linked cell to another worksheet and cell "WK48!A2"
> In Cell A4 in the "data" worksheet I need a link to "WK49!A2". I would
> like to link all cells in Column A to consecutively "WKxx" worksheet once
> I add them to the workbook. I thought I could drag them mouse down but al
> I get is links to consecutive cells in "WK48" work sheet.
>
> Please help
>
> mag()()
>
>
>

Worked a treat.............THANX


mag()()


"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:Ogw5HXH$(E-Mail Removed)...
> Try
>
> =INDIRECT("'WK"&ROW(48:48)&"'!A2")
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Mag()()" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hey All,
>> I have a small issue where I have created a worksheet called data and
>> in Cell A3 I have a linked cell to another worksheet and cell "WK48!A2"
>> In Cell A4 in the "data" worksheet I need a link to "WK49!A2". I would
>> like to link all cells in Column A to consecutively "WKxx" worksheet once
>> I add them to the workbook. I thought I could drag them mouse down but al
>> I get is links to consecutive cells in "WK48" work sheet.
>>
>> Please help
>>
>> mag()()
>>
>>
>>
>