Okay, thats a little more complicated, and need to know if you want to use the same dropdown,but as I expected that may be the next question , I did think about it..
(This assumes you are starting the table transfer in A2, if your starting it somewhere else, change the $A$2 and A2 references in the rows() & columns() functions to the starting cell):
Revised (3 times!!.... )
Formula:
=INDIRECT("'W"&$A$1&"'!"&ADDRESS(ROWS($A$2:A2)-1+9,COLUMNS($A$2:A2)-1+1))
Hope this helps
EDIT-
Missed a ')'
Edit2-
Missed the column reference as being column 1, see revised again
AND MISSED the Absolute referencing.($)....grr...
Bookmarks