Automatic Number Increase
I have the Formula
=IF('[Power Forward 2013.xlsx]1'!$D$1"",'[Power Forward 2013.xlsx]1'!$D$1,"")
I would like to increase the number 1 to 2.3.4...and so on
the next line should look like
=IF('[Power Forward 2013.xlsx]2'!$D$1"",'[Power Forward 2013.xlsx]2'!$D$1,"")
each number is a different tab in the Power Forward Excel File. Any ideas on how to do this without copy - paste and manually changing?
I appreciate the help
|