Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a copy of a sheet and add it into a new workbook?
Hello, I know how to copy and paste data from one sheet to another with ranges
but I'm just wondering if there is an easier way by simply stating something like Workbooks("Backup.xls").Sheets("Data") = Workbooks("Project.xls").Sheets("Data") Thanks in advance!! Nate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
can I make a specified sheet as startup sheet in a workbook? | Excel Discussion (Misc queries) | |||
Copy hidden sheet and then make copy visible HELP? | Excel Programming | |||
How do I make a copy of a entire workbook? | Excel Discussion (Misc queries) | |||
How do I make Excel copy entries from 1 workbook to a new one | Excel Programming |