Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can anyone help with a formula for excel 2003 worksheet/template to automatically number the sheet on opening?

April 26, 2017automatically Computers Excel Formula help internet Software Template worksheet

0

Posted

Can anyone help with a formula for excel 2003 worksheet/template to automatically number the sheet on opening?

2 Answers

0

Posted

What you need to do is record a macro increasing the number by 1 with the formula, if it is in C6 of =c6+1 (depending whether it is a single figure at the moment or whether you have started off higher number, and you will have to go into your options to enable circular referencing.

0

Posted

Got to http://www.mrexcel.com register for free and post your question there. It’s an excellent question forum with loads of Excel experts on hand just wanting to help.