Why do you want to copy the entire sheet to 65 existing sheets.
The 65 sheets' data would all be overwritten and you would have 65 copies of
sheet1
If you want 65 copies of sheet1 use this macro.
Sub SheetCopy()
Dim i As Long
On Error GoTo endit
Application.ScreenUpdating = False
shts = InputBox("How many times")
For i = 1 To shts
ActiveSheet.Copy after:=ActiveSheet
Next i
Application.ScreenUpdating = True
endit:
End Sub
If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime..........
First...create a backup copy of your original workbook.
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project by name and select it.
Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run the macro by going to Tool>Macro>Macros.
You can also assign this macro to a button or a shortcut key combo
Gord Dibben MS Excel MVP
I want to copy the entire sheet 1 to all 65 other sheets, which is possible
one at a time but I can't select all the other sheets and paste because
"paste" is grey'd out when you select two or more sheets.
Gord Dibben MS Excel MVP