Originally Posted by
6StringJazzer
You will need to tweak the formatting in the New file to be how you want it. I only tested this with one sample file. It does not appear that your code replicates the column headings for each new file, and that the ones in your New file were put in manually. Not quite sure what you wanted to do there.
Hello, In testing this is working with a few issues. I may not have been clear on the end results. For each file opened I need it to copy the data as shown below. I know this code will not work but this is the additional needed data from each file. The heading would be replicated for each new file on the next row down. Hope that explains a bit more.
Bookmarks