Hello everyone,
I am a new user and this probably is a basic question.
I have approx 10 excel files, each having only one worksheet but the headers in all these worksheets are different. I would like to map these to a template file, which has a tab i want each of the files to map too. If that makes sense, I currently do this VLookup & Copy and Paste. Essentially 10 input files(that change each time) that have their data map to one template(output file)
Can this be done?
Thank you very much for your assistance on this!
