Doug,

Give us the formula and tell us where it goes and someone will translate
that into code.

Mike

"Doug S" wrote:

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!

--
Doug S