Copying an adjacent cell text from another sheet, if cell exist [Closed]

Report

Jeff68 - Oct 11, 2016 at 05:42 AM

Hello,

I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2.

Sheet 1 has only the parameters I need but no comment on B2.
Sheet 2 has a bigger list of parameters with comment cell on B2 for each parameter.
Not all parameters from Sheet 1 exist on Sheet 2, i.e. the rows don't match. For the parameters that exist on both sheets not all of them have a comment on Sheet 2.

I want to copy the comment cell text from Sheet2 B2 to Sheet1 B2 if the parameter A2 is found on both sheets.

How can I do that? Thanks in advance!

Copying an adjacent cell text from another sheet, if cell exist
Merge adjacent cells in columns with same data/value in excel vba - Forum - Excel
Cell input to call macro in adjacent cell - How-To - Excel
Place specfic text in cell based on text in an adjacent cell ✓ - Forum - Excel
Adding two non-adjacent cells (number and text) ✓ - Forum - Excel
Get value from the adjacent cell ✓ - Forum - Office Software

Copying an adjacent cell text from another sheet, if cell exist [Closed]

Your reply

Subscribe To Our Newsletter!