VBA: Copy column to another workbook based on cell value

[JennV]

Hello there,

In workbook1, I have data in column A for 'Name1'.

2019-04-18
2019-04-19 (cell filled in with blue)
2019-04-20 (cell filled in with red)
2019-04-21

In workbook2, I have columns in row 1:

Name1 ...... Name2 ...... Name3

I'm wondering if there's a code that will search for 'Name1' in workbook2 and then copy the data I have in workbook1 underneath 'Name1' in workbook2. In addition, if there is already data underneath 'Name1' to simply override what's there with the new data.

Thank you in advance!

 

[JLGWhiz]

The parameters are not clear. Why search for Name1 in workbook2, we know it is the first column? Do you mean search for Name1 in workbook 1 then copy data beneath Name1 from workbook 1 to the Name1 column in workbook 2? If the latter is what you really mean, then can you give a better example of what column A in workbook 1 looks like? Would column A of workbook 1 also have Name2 and Name3 listed with data beneath?