how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

Maybe you need to try the Programming group then - could be a way to do all
at once using VBA. Sorry can't help more
Sheila

"Irish" wrote:

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

Irish

When you say copy one worksheet to 65 worksheets, what do you mean?

Do you want to copy just a range from sheet1 to all other sheets or copy the
entire sheet1 to all the other sheets?

I can provide a macro that will copy/replicate sheet1 65 times, but it doesn't
"copy to the other existing sheets".

Maybe look at Ron de Bruin's site for macros to copy from one sheet to others.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 09:58:02 -0700, Irish
wrote:

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

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" wrote:

Irish

When you say copy one worksheet to 65 worksheets, what do you mean?

Do you want to copy just a range from sheet1 to all other sheets or copy the
entire sheet1 to all the other sheets?

I can provide a macro that will copy/replicate sheet1 65 times, but it doesn't
"copy to the other existing sheets".

Maybe look at Ron de Bruin's site for macros to copy from one sheet to others.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 09:58:02 -0700, Irish
wrote:

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.

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 InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 12:46:01 -0700, Irish
wrote:

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" wrote:

Irish

When you say copy one worksheet to 65 worksheets, what do you mean?

Do you want to copy just a range from sheet1 to all other sheets or copy the
entire sheet1 to all the other sheets?

I can provide a macro that will copy/replicate sheet1 65 times, but it doesn't
"copy to the other existing sheets".

Maybe look at Ron de Bruin's site for macros to copy from one sheet to others.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 09:58:02 -0700, Irish
wrote:

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.



Gord Dibben MS Excel MVP

I created a blank attendance tracker for my employees basically like a blank
form for 65 employees. I want each employee on a seperate worksheet in one
workbook. so basically I have one master copy I want 65 copies of for each
employee where I can edit there name, employee number, etc for each
individual.

"Gord Dibben" wrote:

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 InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 12:46:01 -0700, Irish
wrote:

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" wrote:

Irish

When you say copy one worksheet to 65 worksheets, what do you mean?

Do you want to copy just a range from sheet1 to all other sheets or copy the
entire sheet1 to all the other sheets?

I can provide a macro that will copy/replicate sheet1 65 times, but it doesn't
"copy to the other existing sheets".

Maybe look at Ron de Bruin's site for macros to copy from one sheet to others.

http://www.rondebruin.nl/copy1.htm


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 09:58:02 -0700, Irish
wrote:

move and copy will only copy that worksheet and add it to the list of other
worksheets in the work book, I want to copy one work sheet and paste it to 65
other work sheets at the same time, I can only get it to work doing that one
at a time

"Sheila D" wrote:

Right mouse click on the worksheet name and choose the Move or Copy command.
Check the box Create a Copy. You can copy to the current workbook or another
workbook
Sheila


"Irish" wrote:

how can I copy a single worksheet to several other worksheets in the same
workbook or another workbook? I cannot paste as the paste command is grey'd
out when I select 2 or more worksheets.



Gord Dibben MS Excel MVP