I was wondering if somebody could help me out with a VBA code that could delete specific columns and all the sheets except one from all the files in a folder.
For example I have a folder with more than 50 files, with multiple sheets, but I want all the sheets to be deleted except "FinalData" in each file. Now in this sheet "FinalData" I want to delete the Columns named "S-Unit", "C-Unit", "V-Unit", "P-Unit", "Lost-Unit", "***-Unit", "M-Unit", "HIS-Unit", "Local-Unit", "Local2-Unit". then save and close.
It will be great if somebody could please help me out.
Thanks in advance,