| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy all worksheet data into a new worksheet
hi,everyone:
I have a excel file of 7 worksheets. I will need create a new worksheet and copy each 7 worksheet data and paste into the new worksheet. Is there a macro to do that? thanks. Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy all worksheet data into a new worksheet
Hi Eric
I have example for you http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "eric" wrote in message om... hi,everyone: I have a excel file of 7 worksheets. I will need create a new worksheet and copy each 7 worksheet data and paste into the new worksheet. Is there a macro to do that? thanks. Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy all worksheet data into a new worksheet
with this workbook as the activeworkbook:
Sub Copy7() Worksheets.Copy End Sub this will copy the 7 sheets into a new workbook. -- Regards, Tom Ogilvy "eric" wrote in message om... hi,everyone: I have a excel file of 7 worksheets. I will need create a new worksheet and copy each 7 worksheet data and paste into the new worksheet. Is there a macro to do that? thanks. Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy & paste worksheet with print settings into new worksheet | Excel Discussion (Misc queries) | |||
| copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
| copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
Hybrid Mode
