Trying to get data from two workbooks onto the same sheet
I am trying to do similar as here (with some basic VB code), in trying to copy data from two workbooks onto the same sheet, prior to processing the data. Unfortunately the second file doesn't have all the columns the first does. So file 1: A, B, C, D and E, while file 2 has: C, D and E. I have a macro that installs and processes file 1 ok, but if I try and run it on file 2 it returns incorrect data (having imported and processed the data as A, B, C rather than C, D, E).
If anyone thinks this code may be of use or how to improve it let me know.
Accounting 4417; do you this software would be useful for running two files (rather than 500+)
This user has not written any comments yet.