Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name
- by Arul Servin
I need to copy and paste the data from one Excel spreadsheet to another based on column name.
For example, one shreadsheet has columns named like Asset, Asset owner.
Another spreadsheet has column named like Application, Application Owner.
Now I want "Asset" column data to copy and paste into the "Application" column in another spreadsheet. The same way "Asset owner" column data should copy and paste into the "Application Owner" column in the other spreadsheet.