JansiJansi
New Member
- Joined
- Jun 22, 2022
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
Hiya guys.
I am trying to build some conversion files for exports from other sites to match my company's imports. I am going to have to identify which header exists in the other company's export and match it to my company's header.
For example:
Export contains header "Product Name"
Import contains header "Title"
These are the same thing, so I'd want to copy the column containing the Product Name header and paste it into the column in the other workbook which contains the header Title.
I'm new to VBA and would appreciate any help. I've looked at some similar files from searches, but can't get it to work for mine. This leads me to believe my brains are dookie because it's a simple macro, I think.
Thank you!
I am trying to build some conversion files for exports from other sites to match my company's imports. I am going to have to identify which header exists in the other company's export and match it to my company's header.
For example:
Export contains header "Product Name"
Import contains header "Title"
These are the same thing, so I'd want to copy the column containing the Product Name header and paste it into the column in the other workbook which contains the header Title.
I'm new to VBA and would appreciate any help. I've looked at some similar files from searches, but can't get it to work for mine. This leads me to believe my brains are dookie because it's a simple macro, I think.
Thank you!