Worksheet Help req PLZ

M

Mag\(\)\(\)

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()()
 
P

Peo Sjoblom

Try

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
M

Mag\(\)\(\)

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


mag()()


Peo Sjoblom said:
Try

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

--
Regards,

Peo Sjoblom

(No private emails please)
Click to expand...
 
Top