Home » Forums » Open Source Learning Center » Question and Answer

Auto fill Sheet names in Excel 2013

Submitted by leigh3980 on 24 August, 2014 - 16:39

I am trying to auto fill the cell references 'S8' from each of my workbook sheets onto a final summary.
I have tried using the INDIRECT function but am getting a 'REF' error each time. The first sheet is called '01-07 Sep 2014'
Any suggestions would be great.
thanks
Leigh

‹ formula for a.date Macro to append excel files ›
»