Excel help

[psu1]

How can i copy a page of lines / columns etc as i want to make 52 weeks (sheets) so that i can input data for each week. I don't want to copy and paste for every week! I know there is a way to make the 52 sheets in excell but forgotten how to do it!! Thanks

[SiM]

Use VBA. Rather than me write the code for you it's a good idea to learn yourself.

Post your code here if you get stuck.

http://www.google.co.uk/search?q=vba+copy+sheet

[psu1]

I know that i have seen a command that will copy what i have on sheet one onto 52 sheets. Not sure how to do it though. Have looked online but useless at that!

[fuddam]

well, to create the sheets, SHIFT+F11 will produce new ones

you could then group them (SHIFT + CLICK the last sheet tab you want to group together)

then, anything you do on the uppermost sheet will carbon copy to the other 51 sheets in the group.

afterwards, click on any sheet tab outside the group to ungroup them, or if all are grouped, simply click any of the tabs to do so.

[SiM]

Try using the record macro function to copy & paste a sheet. Then use a for loop.

I don't have excel on this pc so have not tested this but try something like this:

sub copy_sheet()
For i = 2 to 52
Worksheets("Week1").copy
activesheet.name = "Week"&i
next i
end sub

e.g. you have made the first sheet and called it "Week1".

[psu1]

Now, that looks very familair. That is very much like what i used a while ago.