VBA - copy data from one sheet to Specific Cells

[jcicero57]

Is there a way to copy the contents of D in sheet 2 to C sheet 3 and B in sheet 2 to D sheet 3 ?
What modifications need to be made to the follwing?

Sheets("sheet2").Range("B1:B6000,D1:D6000").Copy Sheets("sheet3").Cells(Rows.Count, 3).End(xlUp).Offset(1, 0)

NOTE: I am using a VLookup in sheet 3

Thank you.

[AB33]

D in sheet 2 to C sheet 3

Please Login or Register  to view this content.

B in sheet 2 to D sheet 3

Please Login or Register  to view this content.

[jcicero57]

This works thank you for your help