View Single Post
  #1   Report Post  
G_off G_off is offline
Junior Member
 
Posts: 2
Default 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