Automatically update formulae and add to new row

[bigjim324]

Howdy all,

I would like to find a way to have my excel sheet automatically produce a new row of formulae with a new file reference to reflect the new month. i.e. I would like the below formula to be replicated in the cell below and have the name for the document referenced changed from 'June 22' to 'July 22', preferably at the beginning of a new month.

=IF($B$1=1,ABS(SUMPRODUCT(-('Report June 22.xlsx'!$C$2:$C$200=$A$10),'Report June 22.xlsx'!$S$2:$S$200)/SUMPRODUCT(-('Report June 22.xslx'!$C$2:$C$200=$A$10))),IFERROR((VLOOKUP($A$10,'Report June 22.xlsx'!$A$1:$U$1800,19,FALSE)),0))

Thanks!
Jimbo

 

[bigjim324]

Really? Nobody knows?