VBA loop and paste cell balue based on IF condition

[alqulal]

Hi all, am a beginner at VBA and would like to seek help regarding working this out. Have tried looking at certain threads but I am unable to find something similar to what I want to perform.

Currently, I have two separate workbooks as below:

'Customer Info' Workbook, 'Customer' sheet

Customer Name	John
Customer ID	456

as well as 'Compiled Customer' Workbook, 'Compilation' sheet (full table is 1000+ rows long)

ID	Name
123
456
789

As you can see, the 'Name' column is empty. Therefore, would wish to cross-check if the ID in 'Customer Info' workbook matches in 'Compiled Customer', and if it does, copy the Customer Name into the corresponding row.

If able, my preference is that 'Compiled Customer' workbook has to be open, but 'Customer Info' workbook does not and has to be activated.
Many thanks in advance!

Quote Reply

 

[Fluff]

Duplicate to: VBA Loop and paste cell value based on IF condition

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.