Copy specific data from one sheet to another sheet if certain criteria

[jscorsone]

I am trying to copy data from one worksheet to another.

Specifically in the attachment, if Sheet "B" contains "x" in Column A, then in Sheet "A" propogate columns B + C with data from C + D in Sheet "B".

I'm a novice with Excel macros and unable to generate the necessary code using other examples of similar macros.

Any help is greatly appreciated, thanks!

[NBVC]

Does it have to be done with macros?

Maybe you just need the Vlookup() function? This looks up a value in a cell and finds it in a table, returning items from specified columns in same table and same row as match.

[jscorsone]

No, that was just my impression, doesn't have to been done with macros.

[NBVC]

IN B2 try:

=IF($A2="","",VLOOKUP(TEXT(A2,"@"),SheetB!$A:$D,3,0))

and in C2:

=if($A2="","",VLOOKUP(TEXT(A2,"@"),SheetB!$A:$D,4,0))

these can be copied down to accomodate values entered in A3, A4, etc...

[jscorsone]

That's the ticket.

I can't thank you enough for your timely assistance.