Excel Programming using Macro- making totals the starting point and then adding a new set

Hi all

I am looking for help in creating a macro. I have a spreadsheet that uses unit rates and hours and calculates a budget using the first few columns.
The next two columns are used to add hours and claculates their values using the unit rates. The last two columns sum up the original calculations and the added values

A B C D E F G
Orig Hours Unit rates Orig Value= Orig Hours x Unit Rates Added hours E= DxB F = A+D G= C+E


I am looking for a macro to copy F and G into A and C to get a new starting point to calculate D and E for the next time giving me a new F and G

This is for Excel 2007 and 2010

Thank you in advance

FCorp

Hi fcorp
Put some data into you worksheet...before and after...perhaps we can help.