How Do I Change Column Name As Per The Mapped Sheet

Question

3.00/5 (1 vote)

See more:

I have 3 sheets named 'sheet1', 'sheet2' and 'mapping' sheet.

'Sheet1' consist the actual data (Can say raw data and column numbers/header name can be different)

'Sheet2' Consist the master sheet columns (Sheet1 data header should be as per the sheet2)

'mapping' consist the mapping between sheet1 and sheet2

| AB| AF| AL|   | C1| C2| C3|   |sheet1 column_name |  Sheet2 column_name|
|-----------|   |-----------|   |     AB            |    C1              |
| 1 | f | y |   |   |   |   |   |     AL            |    C2              | 
|---------- |   |---------- |   |     AF            |    C3              | 
| 2 | g | Q |   |   |   |   |   -----------------------------------------
|---------- |   |---------- |   
| 6 | i | e |   |   |   |   |   
-------------   -------------   
       "Sheet 1"     "Sheet 2"                  "Mapping"

I am looking for code which can update sheet1 columns as per the mapping sheet. Like if mapping sheet says "AB" = "C1" then sheet1 column should be updated as "C1"

I have tried it using matchfunction but didn't get success.any other idea?

Thanks in advance.

Posted 28-May-14 21:25pm

Member 10851479

Updated 28-May-14 21:38pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-07-17T02:06:00

Solution 1

If you're talking about XML mapping, have a look here: Creating an XML Mapping Schema in Excel 2010[^], Importing XML Data into a Mapped List in Excel 2010[^].
If not, let me know and i'll try to improve my answer.

Posted 17-Jul-14 2:06am

Maciej Los