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) |