I'm starter with VBA and have managed to complete below code with some help from this forum, but have one last task to figure out for making the code as I want it to do.
I have let say 40 *.xls files in the folder, I have also a *.xlsm file with eight sheets named (PC2,4,6...-16) in the same...