sitrah
Reputation: 11
Copying corresponding values from one sheet to another based on matching value
I have been searching internet for a solution, but I was unable to find it. Most answers somehow reference the solution, and I think my lack of knowledge on Advanced V.Basic is preventing me to come to the solution.
I have an Excel file that has Sheet1 and Sheet2. Sheet1:ColumnA contains a list of part numbers, the Sheet2:ColumnA contains similar but more part numbers, along with Sheet2:ColumnB contains description/title of respected part number. The goal is to search "Sheet1:ColumnA.Value" in "Sheet2:ColumnA" if found, copy the description (Sheet2:ColumnB) to "Sheet1:ColumnB".
Much appreciate your help.
Upvotes: 1
Views: 2663
Related Questions
- Match value in another sheet and copy data to current sheet
- Copying values from one sheet to another with VBA with a condition
- Copying values based on condition from one sheet to another
- VBA Excel Matching value's in sheets and copy rows
- Copy data from one sheet to another based on cell value
- Copying Row Info from one sheet to another based on match
- I want to copy a row based on the values from another sheet
- If value match on different sheet, then copy data from the sheet one to other sheets
- Match cell value from two sheets and paste where the value is met, starting from one cell below
- How to match values of one sheet on another sheet