Hello, the attached report is generated by VBA opening all files in a folder and copying specific data as shown in columns B thru L. Thank you to SixstringJazzer for the code help.
I now need the best way to get the code to populate the columns in red (M thru P) with the number of network days (with the calculations shown in red), with holidays, for each HAWB. The number of HAWB’s will differ with each file.
Our Holiday list is noted on Sheet2.
Thank you for your help.
Bookmarks