D
Doug S
I am using VBA to create a new worksheet with summary totals in several
columns that I then want to move over to an already established roll-up
worksheet (on a new row).
I've accomplished the first part (new worksheet) and have successfully added
the new row on the roll-up worksheet. I am now trying to write the "Do Loop"
that will write the formulas into the roll-up worksheet. Formulas are
required so that when the underlying info changes on the new sheet the
roll-up worksheet will automatically reflect the changes.
I am using relative references in the code (e.g. R1C1) so that I can
increment the column number with each loop. I am drawing a complete blank,
however, on what to enter into the cell to get it to work.
Help!
columns that I then want to move over to an already established roll-up
worksheet (on a new row).
I've accomplished the first part (new worksheet) and have successfully added
the new row on the roll-up worksheet. I am now trying to write the "Do Loop"
that will write the formulas into the roll-up worksheet. Formulas are
required so that when the underlying info changes on the new sheet the
roll-up worksheet will automatically reflect the changes.
I am using relative references in the code (e.g. R1C1) so that I can
increment the column number with each loop. I am drawing a complete blank,
however, on what to enter into the cell to get it to work.
Help!