Please provide me a VBA code that will run and do the below task automatically. I would be grateful if you provide me a solution.
I am having around 100 to 150 excel files having different file names.
I mentioned the exact requirement in Steps:
Step:1 Sample 100 files are listed here but this...