Hello,

I have five rows of data in a table used to input data monthly for charting:

Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13
Parts Shipped 1713 1755 2456 2454 1687 1481 1887 1475 2060 1615 1133 4561
Parts Rejected 2 15 7 0 0 2 8 1 4 0 13 8

Actual Percentage 9.88 99.15 99.71 100.00 100.00 99.86 99.58 99.93 99.81 100.00 98.85 99.82
Average Percentage 99.88 99.51 99.58 99.69 99.75 99.77 99.74 99.77 99.77 99.79 99.71 99.72

The percentage rows both contain code for calculating percentage. I want to copy, not cut, March thru January data, and paste it over February thru December data, then clear contents of January's parts shipped, parts rejectedactual and average percentages without any of the formulas being changed. I cannot for the life of me figure it out, nor can I find a solution.

Please help me with this and thanks in advance.