Hello John -
I hope you are doing well. Your macro has been running great!
So there are ~15 contractors who input their receipts each day in separate spreadsheets in separate User folders. The macro you wrote opened the spreadsheets that had a certain name
xFile = Dir(xStrPathArg & "\*InputData*. ... Show more