Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
Is there a quick way to copy 1 sheet into a 100 sheet workbook?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
Copy from where?
Gord Dibben MS Excel MVP On Tue, 3 Oct 2006 08:47:02 -0700, STEVE wrote: Is there a quick way to copy 1 sheet into a 100 sheet workbook? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
€śInsert€ť €śWorksheet€ť On the Standard toolbar.
"Gord Dibben" wrote: Copy from where? Gord Dibben MS Excel MVP On Tue, 3 Oct 2006 08:47:02 -0700, STEVE wrote: Is there a quick way to copy 1 sheet into a 100 sheet workbook? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
1. €śTools€ť €śOptions€ť on the €śView tab€ť click €śSheet tabs€ť.
2. Right click the Tab (at bottom of sheet) you want to copy. 3. Select move or copy (you can even choose where to place the copied sheet). 4. Rename the new sheet. Lou "STEVE" wrote: Is there a quick way to copy 1 sheet into a 100 sheet workbook? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
Duplicate 1 sheet in workbook "A" to 100 sheets in workbook "A".
A QUICK way!!! (not answers below since that is very slow and manual) "Gord Dibben" wrote: Copy from where? Gord Dibben MS Excel MVP On Tue, 3 Oct 2006 08:47:02 -0700, STEVE wrote: Is there a quick way to copy 1 sheet into a 100 sheet workbook? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 SHEET into 100 sheet Workbook.
Sub SheetCopy22()
Dim i As Long Application.ScreenUpdating = False For i = 1 To 100 ActiveSheet.Copy Befo=Sheets(1) Next i Application.ScreenUpdating = True End Sub Gord On Wed, 4 Oct 2006 05:15:02 -0700, STEVE wrote: Duplicate 1 sheet in workbook "A" to 100 sheets in workbook "A". A QUICK way!!! (not answers below since that is very slow and manual) "Gord Dibben" wrote: Copy from where? Gord Dibben MS Excel MVP On Tue, 3 Oct 2006 08:47:02 -0700, STEVE wrote: Is there a quick way to copy 1 sheet into a 100 sheet workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet to worksheet . . . | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
Table of Contents Sheet in Workbook | Links and Linking in Excel | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |