ExcelBanter - Match and copy rows from 2 sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Match and copy rows from 2 sheets (https://www.excelbanter.com/excel-programming/401437-match-copy-rows-2-sheets.html)

Luther

Match and copy rows from 2 sheets

Hello,

Here is the task I need to perform:

* I have 2 sheets that have a common column, ID. (example data: 32A2VH)

What I need to do is this.

1. Match the ID from sheet2 to sheet1
2. Once found, copy the row from sheet1 to another blank sheet

Is there some way to accomplish this, please?

All times are GMT +1. The time now is 02:02 PM.