How do I make a complete copy of a worksheet, and insert a n

[Glyder]

With the exact data and charts? I have a spreadsheet, basically a template that I want to use, and create multiple worksheets within the same book based on this first sheet.

It has a chart in it, but everytime I try to copy, the chart doesnt copy.

 

[shades]

Right-click on the worksheet tab. In the pop up, select "Move or Copy" (in the lower left corner of that dialog box, check "Make copy." Click Okay. You have an exact reproduction of the entire sheet, charts and all.

 

[Glyder]

Excellent, I don't know how I missed that part! Now, if only you could help me with my other problem that I had posted hehe

 

[BigC]

Glyder
An alternative (shortcut) way to copy a sheet within the same workbook is to select the source sheet, hold down CTRL and drag the sheet tab to the right.
This command (same as Edit / Move or copy sheet described above) creates a complete clone (an identical twin) of the source sheet, with page set up settings, formats, column widths, etc, etc......

HTH