Copy/Paste to Add Sum of Cells Across Separate Workbooks

[Ambiversion]

I have a master worksheet which is generated automatically at the end of the week by our system, which logs tips and mileage collected by each employee. We have deliveries which take place outside of our system which also need to be recorded, but cannot be logged by the system, so they need to be input manually. I've created a separate form which copies the master worksheet in format, and I'm looking for a way to copy the data in the tips and mileage columns of Worksheet 1 and then upon pasting them onto the same data in Worksheet 2A, which would add both the source cells and target cells, resulting in the data found in Worksheet 2B. Is this possible?

Worksheet 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Tips[/TD]
[TD]Mileage[/TD]
[/TR]
[TR]
[TD]Employee A
[/TD]
[TD]$50[/TD]
[TD]$20[/TD]
[/TR]
[TR]
[TD]Employee B[/TD]
[TD]$100[/TD]
[TD]$20[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 2A
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Tips[/TD]
[TD]Mileage[/TD]
[/TR]
[TR]
[TD]Employee A
[/TD]
[TD]$100[/TD]
[TD]$40[/TD]
[/TR]
[TR]
[TD]Employee B[/TD]
[TD]$200[/TD]
[TD]$40
[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 2B
[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Tips[/TD]
[TD]Mileage[/TD]
[/TR]
[TR]
[TD]Employee A
[/TD]
[TD]$150[/TD]
[TD]$60[/TD]
[/TR]
[TR]
[TD]Employee B[/TD]
[TD]$300[/TD]
[TD]$60[/TD]
[/TR]
</tbody>[/TABLE]

 

[ravishankar]

Yes, copy paste sheet1 to sheet2b. Now copy sheet2a and (right click the mouse) > pastespecial >choose operations >add > click ok. IT Adds both values
ravishankar

 

[Ambiversion]

That's perfect, thank you! Is there any way to add a shortcut for this function to the quick list?