I only have basic skills in excel and am currently trying to find a new way to improve an exsiting excel file. It is a file that needs to be updated often and I seem to be having to edit the formatting every time.

I want to know if it is possible to have each page automatically default to a new sheet and have the sheet named Page 1 for page 1, page 2 for page 2 etc.

I have made a template of the main formatting I want for each sheet and I want it to stay the same for each sheet and not be able to be modified as I add data.

I apologise I am not very skilled in this area and struggle with formulas and have not used a forum before.

Please let mw know if you have any suggestions.

Much appreciated.

One way would be to use SaveAs and save the file with a new name
whenever you want to start fresh, then just clear any existing data so
the formatting remains intact. With VBA, this could be automated!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion