I ran it and got good results, then realized I needed to add a field before rerunning it. That field is ID, where each NPPAYROL job is numbered HR001, HR002, etc.
I reset all the files, re-added the NPPAYROL section to the macro, and now I can't get it to run again. These are the errors I get:
Run-time error '9':
Subscript out of range.
And when I hit Debug, it highlights the line:
Set Sh_Old = Workbooks("Old-File.xlsm").Sheets(1)
I don't know what I did to it, but can you help, please?
Bookmarks