software

I have several different xls with multiple worksheets in each I have
written the report that generates the data but I must manually go into
each field and change the worksheet reference each time the sheet
changes.

Could I have an additional colum which specifies which sheet to pull
data from? Then in each function sepecifiying how to create the value
needed the worksheet referance updates too.

Let me know if I need to clarify.--
adiss
------------------------------------------------------------------------
adiss's Profile: www.excelforum.com/member.php...oamp;userid=33939
View this thread: www.excelforum.com/showthread...hreadid=537156You can use

=INDIRECT(quot;'quot;amp;A1amp;quot;'!H10quot;)

which pulls the value in H10 from the sheet specified in A1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;adissquot; gt; wrote in
message ...
gt;
gt; I have several different xls with multiple worksheets in each I have
gt; written the report that generates the data but I must manually go into
gt; each field and change the worksheet reference each time the sheet
gt; changes.
gt;
gt; Could I have an additional colum which specifies which sheet to pull
gt; data from? Then in each function sepecifiying how to create the value
gt; needed the worksheet referance updates too.
gt;
gt; Let me know if I need to clarify.
gt;
gt;
gt; --
gt; adiss
gt; ------------------------------------------------------------------------
gt; adiss's Profile:
www.excelforum.com/member.php...oamp;userid=33939
gt; View this thread: www.excelforum.com/showthread...hreadid=537156
gt;

Thats just what I needed thankyou!--
adiss
------------------------------------------------------------------------
adiss's Profile: www.excelforum.com/member.php...oamp;userid=33939
View this thread: www.excelforum.com/showthread...hreadid=537156