Right-click on the worksheet tab and select "Move or Copy", then use the
dialog box that appears to specify where you want to paste the worksheet
copy. Be sure to check the box that says "Create a copy". If you have data in
the worksheet that you don't want to have in the other worksheets, make one
copy of it, delete the data from the copy, and then use the copy to create
the other 149 worksheets.

GwenH
Master MOS

"Mick M" wrote:

I am wanting to copy a worksheet that is set up to show student results,
targets and achievements into approximately 150 other worksheets in the same
workbook. Is there a quick way of doing this other than copying and pasting?
I want formats, colours and column widths etc to stay the same. In other
words I want to produce about 150 identical copies of my layout as quickly as
possible with the minimum of effort.
I am using Excel 2003.
Thanks in advance for any help and advice offered