Hello,
I would say I'm relatively new to VBA in particular, and this site as well (it's my first post!).
I am working with Excel 2010.
I need help designing a macro to search a range (B, C in the case of the table below) and based on if a cell in the range has text (B1, B3, B5, B7, C1, C4, C5), for the macro to copy that cell and a cell from column A (A1 & B1, A1 & C1, A3 & B3, etc.) to paste into output in the order of column A then the other column.
<tbody>
</tbody>
If you have any questions please ask!
I would say I'm relatively new to VBA in particular, and this site as well (it's my first post!).
I am working with Excel 2010.
I need help designing a macro to search a range (B, C in the case of the table below) and based on if a cell in the range has text (B1, B3, B5, B7, C1, C4, C5), for the macro to copy that cell and a cell from column A (A1 & B1, A1 & C1, A3 & B3, etc.) to paste into output in the order of column A then the other column.
A | B | C | Output | |
1 | John Smith | Not Paid | Not in Payroll System | John Smith Not Paid |
2 | James Smith | John Smith Not in Payroll System | ||
3 | Matthew Smith | Not Paid | Matthew Smith Not Paid | |
4 | Michelle Pfeiffer | Is an actress | Michelle Pfeiffer Is an actress | |
5 | HTMLGhozt | Not Paid | Is me! | HTMLGhozt Not Paid |
6 | Stacy Keibler | HTMLGhozt Is me! | ||
7 | Apples Galore | Is Apples | Apples Galore Is Apples |
<tbody>
</tbody>
If you have any questions please ask!
Last edited: