Worksheet Help req PLZ

  • Thread starter Thread starter Mag\(\)\(\)
  • Start date Start date
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()()
 
Try

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
worksheet change macro activation 5
Excel Highlighting duplicates 0
trying to create a link to a link in Excel (2007) 3
Excel lookup across entire workbook 1
Copy a worksheet to a new workbook 6
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to delete ALL cells containing the same data 1

Back
Top