MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Filling down across several workbooks


Posted by Skeletor on October 05, 2001 3:51 PM

How does one fill down based on the name of the workbook, i.e.

A1:='Sheet1'!$A$1
A2:='Sheet2'!$A$1
A3:='Sheet3'!$A$1
.
.
?

Thanks.


Posted by Skeletor on October 05, 2001 3:52 PM

No. That should read 'worksheets' not workbooks.

Posted by Henry Root on October 05, 2001 8:15 PM

Re: No. That should read 'worksheets' not workbooks.

=INDIRECT("Sheet" & ROW() & "!$A$1")