I am using the macro from this answer, which allows you to split up a file based on the values of a specified column. I adjusted it to add Dim sMonthYear As String ' Month & Year of report sMonthYear = Application.InputBox("Enter the Month and Year of the report", "Enter […]