Find specific column name and paste the data from different worksheets

Hi,

I have no idea how to paste data based on column name.
Can anyone please help to guide me? Attached sample workbook for your reference.
Thanks in advanced.

This button (macro) replicates your data, but after writing it I then realized it's not quite what you asked for.

sample - modified.xlsm

I'm only searching the MasterList tab for the NAME column, and I'm assuming that GENDER and AGE will be the next two columns. (As it is in the example.)

Likewise with the RawData worksheet tab. I'm only searching for the CustomerName column, and assuming that the *** column comes immediately after.

If that IS the case, then this macro will work fine. But if the Gender and age columns could be in ANY column, the macro will have to be modified. But you might be able to modify it yourself, after viewing the code.

Originally Posted by Ed_Collins

This button (macro) replicates your data, but after writing it I then realized it's not quite what you asked for.

Attachment 235800

I'm only searching the MasterList tab for the NAME column, and I'm assuming that GENDER and AGE will be the next two columns. (As it is in the example.)

Likewise with the RawData worksheet tab. I'm only searching for the CustomerName column, and assuming that the *** column comes immediately after.

If that IS the case, then this macro will work fine. But if the Gender and age columns could be in ANY column, the macro will have to be modified. But you might be able to modify it yourself, after viewing the code.

thanks Ed_Collins . .i don't really understand after reading the code.

Do you mind to show me with simple vba, if i just want to copy column "Name" data from sheet "MasterList" and paste to next blank row in column "CustomerName" from RawData list?
One column data will do.

Do you mean like this:

Sheets("MasterList").Select
Range("A2:A6").Select
Selection.Copy
Sheets("RawData").Select
Range("A9").Select
ActiveSheet.Paste

Originally Posted by Ed_Collins

Do you mean like this:

Sheets("MasterList").Select
Range("A2:A6").Select
Selection.Copy
Sheets("RawData").Select
Range("A9").Select
ActiveSheet.Paste

but what if i want to define the criteria by column name and not cell range?
I want to copy all data from column "Name" and append the data to column "CustomerName" list.