I want to copy description mentioned in particular cell only when the adjacent cell (i.e. adjacent column cell) says 'YES' . I want to copy this description from one sheet to another. Is this possible through any Excel functionality or Visual Basic?
Worksheet 1 - Column R says Name of the control; Column AA specifies Yes/No; Column BB specifies description for that control if Column AA says 'Yes'
I need to copy the 'name of the control' (data in Column R) and 'description' (data in Column BB) to another workbook (Worksheet 2) if Column AA = 'Yes'.
If this is not possible, then copying data from one tab to another in a workbook would also work for me.
This is Urgent. Can any expert here please help.
Copy answers from 1 sheet to another based on condition - VB