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")
