Excel help

[koolpc]

I have done one 'work sheet' in excell that i am going to name 'week 1' and want to duplicate that to make 52 work sheets, going from week 1 to week 52.

Now, i really dont want to copy paste for 52 sheets so anyone know of a formula where i can instantly make those 52 individual work sheets, keeping the data on each sheet the same? Looked on google but i am a noob and need step by step help. Thanks

 

[Kris_90]

You can right click on the tab and copy the work sheet, it will copy everything but you will have to do it 51 times. There might be another way but I don't know it

 

[koolpc]

You can right click on the tab and copy the work sheet, it will copy everything but you will have to do it 51 times. There might be another way but I don't know it

I know how to do that as stated in opening thread.

 

[Participant]

It'll be quicker to do it manually than find out a macro and create it etc. Get right-clicking!

 

[koolpc]

I am sure someone on here mentioned how they did it but i cant find the link

 

[Participant]

You could have done it by now, stop being lazy . Don't forget that once you have a few, you can ctrl-click multiple sheets and copy them as a batch.