Held dragging INDIRECT FUNCTION
Hi!
Try this:
=OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1)
When copied down will return references to:
Sheet!???Q1
Sheet!???R1
Sheet!???S1
Sheet!???T1
etc
Biff
"ChronicTiger" <u17652@uwe wrote in message news:5a5b756ad125f@uwe...
Im using this function.........
INDIRECT($A$2 & "!Q1")
When I drag it down a column I want the Q to increment.
If anyone can help me with this it would be much appreciated!
|