|I don't quite understand what you are trying to do, but I think that you are looking for the INDIRECT function.|
Read up on the function in the Excel Help files or DAGS.
The INDIRECT function returns the value in the cell represented by the text string used (or built) as the argument.
e.g. If I start with this:
1 Sheet1 2
2 Sheet2 5
then this will return the contents of Sheet1!B2
=INDIRECT(A1 & "!B" & B1)
If I wrap a SUM function around a couple of INDIRECT functions, I can SUM the values in the referenced cells:
=SUM(INDIRECT(A1 & "!B" & B1), INDIRECT(A2 & "!B" & B2))
would return the same value as:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.