How to use address from relative reference across worksheets?
 

I need help with a problem - there's probably a simple solution, but it
totally escapes me. I've got a worksheet populated with data, and I
want to reference the data from a second worksheet within the same
workbook. Worksheet A has data groups in columns:

1 11 21
2 12 22
3 13 23
4 14 24

31 41 51
32 42 52
33 43 53
34 44 54

On worksheet B, I want to set up cell A1 to directly reference the
value in the first row of one of the groups of data on worksheet A
(value will be 1, 11, 21, 31, 41, or 51), and then use the address
referenced in cell A1, together with the offset function, to set cell
A2 to the value of the second row of the data group chosen in A1. For
example, if A1 value is 21, A2 will be 22. If A1 is 41, A2 will be 42.
How do I set up the offset formula to use the address (including the
worksheet) contained in the reference in cell A1?


--
Kncuda
------------------------------------------------------------------------
Kncuda's Profile: http://www.excelforum.com/member.php...o&userid=28967
View this thread: http://www.excelforum.com/showthread...hreadid=567464