I have a worksheet that has three columns all part of a formula. Very
simple, the first column is the beginning subtotal, the second is any
additional numbers, the last column is the total of the two previous columns.


I want to make copies of the master sheet and carry over the total from one
sheet to the next copied sheet, however I need the numbers in the Total
column to end up in the Subtotal column of the copied sheet, and so on with
multiple copies.

Can this be done?

Thank you for your valued suggestions! Carl