Copy to new worksheet

  • Thread starter Thread starter KAP
  • Start date Start date
K

KAP

I have a workbook that I add a new sheet to every day. How can I copy a
formula to the new worksheet only, then fill down to the last row?

Thank you
 
Last row of which sheet.........new one or last row of previous sheet?

I don't think you need 1000000+ cells with a formula.

Without code I would create a sheet with the formulas already in place.

Then each day I would simply copy that sheet.

Or open a new workbook..Delete all but one sheet.

Enter your formula in A1 and copy down as far as you wish.

Save the workbook as SHEET.XLTX into your XLSTART folder.

This would become the template for Insert>Sheet.


Gord Dibben MS Excel MVP
 
Back
Top