Hey AlphaFrog,

I am currently saving each file individually.

I have a drop down list in C2 on my 'Config' tab that is based off of O17:O159, I want the macro to go to the next number in the drop down and save the report to the location listed below, the file name will change based off of cell B1 on the new excel worksheet that is created.

Thanks again for all your help!

newWkb.SaveAs Filename:="H:\1_School Support\RBR FY17\Monthly Reports\October\" & Range("B1").Text & " - Monthly Report - October.xlsx"