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 InsertSheet.


Gord Dibben MS Excel MVP


On Mon, 2 Nov 2009 09:16:02 -0800, KAP
wrote:

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