Re: Reference to another worksheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: cradino <cradino.1q0duh_1117731923.6384@xxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 2 Jun 2005 11:18:30 -0500

Ron Coderre

That's great.
But now I want to paste my workbook*** names in the first row of the
first *** and that formula in the seond row.

Like this: sheet1!A1:sheet1A200 SheetNames
Sheet2!A1 =INDIRECT(A1&"!A1") Right Filled till
Sheet1!A200 That formula is great!!!!!!!!!!!

And now the quastion: How can I automaticaly fill
sheet1!A1:sheet1!A200 with MySheetNames????????????????????

Best regards

--
cradino
------------------------------------------------------------------------
cradino's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18521
View this thread: http://www.excelforum.com/showthread.php?threadid=375741

.

Follow-Ups:
- Re: Reference to another work***
  - From: cradino

References:
- Reference to another work***
  - From: cradino
- RE: Reference to another work***
  - From: Lowkey

Prev by Date: RE: SumIF Formula
Next by Date: RE: Logical Function
Previous by thread: RE: Reference to another work***
Next by thread: Re: Reference to another work***
Index(es):
- Date
- Thread