1. I have a macro that I would like to run on multiple files in a folder. Each file may have between 1 to 400 records in it. 2. I will need the macro to be able to copy and paste values in Columns G, H, and I (values after macro runs) to the end of the file if the file no matter how many rows it has Again some files only have 1 record, some 10 records, etc. See macro in the attached file.
Currently the macro removed 2 columns; adds 3 columns, do calculations in the 3 columns (G-I) and remove all columns after column i.