Excel help

raptormonkey

raptormonkey

raptormonkey

Permabanned
Joined
14 Jun 2009
Posts
1,110
I have produced one 'sheet' with weekly data on it in Exel. Now, i want to make 52 'Sheets' available. Is there an easy way to do this rather than selecting sheet 2 and then pasting all the contents of sheet one on it and doing every 52 sheets the same!! Thanks
 
Am i allowed to kiss you online?

Now, each sheet has been saved i will be adding different data to each page so i don't want the 'data' to be saved the same on each 'Sheet' as each week will produce different data. If i save one sheet, will the data be saved on all the others? I don't want this to happen as the data for each week will vary.
 
Last edited:
That is what i have done. Made a template, run the Macro as you instructed. This has produced 52 sheets for me.

Now, as i work on one sheet at a time (per week) and then save it, it won't put that data onto the other 51 sheets will it? I don't want that as each week will be different. Thanks mate
 
You must log in or register to reply here.
Back
Top Bottom