Macro To Replace Existing Data With Newly Copied Data

[MarkStrong]

Hi guys,

I wasn't able to find this question in any of my searches so it would be great if you could help me out.

I want to create a macro that will copy a set of data (identified by common field, ie. Coffee Type in this example) and replace existing data in a separate worksheet.

I.e.:
Worksheet 1:

A	B	C
Coffee Type	Temperature	Size
Latte	Medium	Large

<tbody>
</tbody>

Copy data (A2:C2) and then paste in the following worksheet, if Latte is pre-existing then overwrite Latte data else paste a new row at the end.

Worksheet 2:

If Latte data is already there, find and replace over it (i.e. it would update Small to Large)

A	B	C
Coffee Type	Temperature	Size
Latte	Medium	Small

<tbody>
</tbody>

Or if Latte is not there, paste at the end (in red):

A	B	C
Coffee Type	Temperature	Size
Espresso shot	Hot	Small
Latte	Medium	Large

<tbody>
</tbody>

This has been doing my head in for a couple days so thank you for any help you could offer.

 

[skywriter]

Cross Posted.

 

[MarkStrong]

Quite right! I have removed cross post. Thanks skywriter.