Map Columns With Different Header Names Using A Dynamic Table

Greetings Experts!

I can't quite seem to expected results. I have hundreds of sheets coming in from customers that I need to format for uploading - so I want to map their column headings to mine. Some times they have columns I don't want. My template always has columns that must be included but don't always have input from customers. I've included a file that shows you the input, the template, the dynamic map - that could be changed as header names change on the input file and my expected results. I have found some code on the internet that does a little of what I'm looking for but that is added in a text box in the file as well.

Thanks in advance for your help
Jess

In sheet DynamicMap in Coluumn C are now the ColumnNumbers of MasterTemplate
only thing to do is fill column B with headers of InputData and run macro

Please Login or Register  to view this content.

Kind regards
Leo

Leo, you are wonderful, i will try this as soon as i get to my computer and let you know how it goes. Thank you for taking the time.

Originally Posted by LeoTaxi

In sheet DynamicMap in Coluumn C are now the ColumnNumbers of MasterTemplate
only thing to do is fill column B with headers of InputData and run macro

Please Login or Register  to view this content.

Kind regards
Leo

Leo - is it possible to have blanks in the beginning of the template?
When I put a blank in the beginning of the template (a field that will not be populated
but is used for upload to database) - it no longer works.
Is it possible to read the column number of where the data is to go in the template,
match the header name from column B in the DynamicMap - copy row 2 to end,
then paste in template based on the column number location?
I think that would work perfectly.... I just am not able to make it work.

new sample attached.

Thanks!!!

Cell B2 in Dynamic Sheet was not Emty in your file, and little modification in code

Please Login or Register  to view this content.

Kind regards
Leo

Leo, This is so close - I think my "real" data sheets are more complex than the samples I am sending, and I've been adjusting to try and make it work, but I'm not getting the expected results that I get with the sample. I'm attaching the complicated version of what I need - in hopes that there is one line of copy the column with a number at the last row and past to "ExpectedResults" page using that number as the index to locate the column number and paste starting at A2, so the ExpectedResults headers don't move. and as added info - I don't need to ever append to ExpectedResults, each upload will produce a unique output.

Thank you for your dedication to this - I'm learning so much through you code! You're my hero!
Jess

Please Login or Register  to view this content.

Kind regards
Leo