software

Im using this function.........

INDIRECT($A$2 amp; quot;!Q1quot;)

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!

Hi!

Try this:

=OFFSET(INDIRECT(A$2amp;quot;!Q1quot;),,(ROWS($1:1)-1)*1)

When copied down will return references to:

Sheet!???Q1
Sheet!???R1
Sheet!???S1
Sheet!???T1
etc

Biff

quot;ChronicTigerquot; lt;u17652@uwegt; wrote in message news:5a5b756ad125f@uwe...
gt; Im using this function.........
gt;
gt; INDIRECT($A$2 amp; quot;!Q1quot;)
gt;
gt; When I drag it down a column I want the Q to increment.
gt;
gt; If anyone can help me with this it would be much appreciated!
Thanks I'll keep that one in my arsenal. I am also trying to modify your
equation to get it to return references to:

sheet!???Q1
sheet!???Q2
ect....

can you help with that?

Thanks Biff..................

Biff wrote:
gt;Hi!
gt;
gt;Try this:
gt;
gt;=OFFSET(INDIRECT(A$2amp;quot;!Q1quot;),,(ROWS($1:1)-1)*1)
gt;
gt;When copied down will return references to:
gt;
gt;Sheet!???Q1
gt;Sheet!???R1
gt;Sheet!???S1
gt;Sheet!???T1
gt;etc
gt;
gt;Biff
gt;
gt;gt; Im using this function.........
gt;gt;
gt;[quoted text clipped - 3 lines]
gt;gt;
gt;gt; If anyone can help me with this it would be much appreciated!

Hi!

Try one of these:

=INDEX(INDIRECT(A$2amp;quot;!Q:Qquot;),ROWS($1:1))

=OFFSET(INDIRECT(A$2amp;quot;!Q1quot;),(ROWS($1:1)-1)*1,)

Biff

quot;ChronicTigerquot; lt;u17652@uwegt; wrote in message news:5a5cb72708eef@uwe...
gt; Thanks I'll keep that one in my arsenal. I am also trying to modify your
gt; equation to get it to return references to:
gt;
gt; sheet!???Q1
gt; sheet!???Q2
gt; ect....
gt;
gt; can you help with that?
gt;
gt; Thanks Biff..................
gt;
gt; Biff wrote:
gt;gt;Hi!
gt;gt;
gt;gt;Try this:
gt;gt;
gt;gt;=OFFSET(INDIRECT(A$2amp;quot;!Q1quot;),,(ROWS($1:1)-1)*1)
gt;gt;
gt;gt;When copied down will return references to:
gt;gt;
gt;gt;Sheet!???Q1
gt;gt;Sheet!???R1
gt;gt;Sheet!???S1
gt;gt;Sheet!???T1
gt;gt;etc
gt;gt;
gt;gt;Biff
gt;gt;
gt;gt;gt; Im using this function.........
gt;gt;gt;
gt;gt;[quoted text clipped - 3 lines]
gt;gt;gt;
gt;gt;gt; If anyone can help me with this it would be much appreciated!
Biff,

Your the man.

signed,
Mcfly

Biff wrote:
gt;Hi!
gt;
gt;Try one of these:
gt;
gt;=INDEX(INDIRECT(A$2amp;quot;!Q:Qquot;),ROWS($1:1))
gt;
gt;=OFFSET(INDIRECT(A$2amp;quot;!Q1quot;),(ROWS($1:1)-1)*1,)
gt;
gt;Biff
gt;
gt;gt; Thanks I'll keep that one in my arsenal. I am also trying to modify your
gt;gt; equation to get it to return references to:
gt;[quoted text clipped - 28 lines]
gt;gt;gt;gt;
gt;gt;gt;gt; If anyone can help me with this it would be much appreciated!