Searching and Pulling from a Range VBA

[HTMLGhozt]

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.

	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!

 

[hiker95]

HTMLGhozt,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.