How to copy contents from one excel column to another different excel based on specific column header

Help Activities
1

Would need some guidance on how to copy data from one excel to another based on specific column headers.
For example: If excel1 has a column “ID” in it with values of IDs and another excel file named excel2 has a column “ID” in it. The data needs to be pasted from excel1 to excel2 in case the header doesnt exist than move to the next column.
Any kind of inputs is much appreciated :slight_smile:

2

Hello @aashish0398,

Have a look on this thread thight might can help you.

Thanks,
Sanjit