Worksheet Formula
Thanks!! That's just what I needed! You saved me a lot of work. I have
several of the same type workbooks with the same amount of worksheets in them
and this is going to be the best thing since slice bread!!
"Domenic" wrote:
Assuming that the formula will be entered in A2, and copied down, try...
=INDIRECT(TEXT(ROWS($A$2:A2),"000")&"!C8")
Hope this helps!
In article ,
Kelly wrote:
I have a workbook with 100 worksheets. I need to have the data that populates
letΓ’¬’s say field C8 in all 100 worksheets in my Log Sheet. How can I copy this
down the rows in my log sheet and have the formula change to each sheet.
An example would be:
=+Γ’¬’001Γ’¬’!C8
=+Γ’¬’002Γ’¬’!C8
=+Γ’¬’003Γ’¬’!C8
Thanks
Kelly
|