Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same work
I am recording a simple macro to insert a new worksheet and copy the content
of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same work
I find that it is simpler to make an exact copy of the existing worksheet.
To do this make the worksheet you want to copy the active worksheet, hold the Ctrl button down while you click on the active worksheet tab and drag/drop it next to it. Then release the Ctrl button. This creates an exact duplicate of the active worksheet. -- Betty H Salem, OR "queenmaam" wrote: I am recording a simple macro to insert a new worksheet and copy the content of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same work
Either post your code, or use this code (I think this will pretty much do
what you want): http://www.rondebruin.nl/copy2.htm Lots of other copy/paste/merge examples he http://www.rondebruin.nl/tips.htm Regards, Ryan--- -- RyGuy "queenmaam" wrote: I am recording a simple macro to insert a new worksheet and copy the content of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same
Thanks. I figured it was pretty simple, but I'm very new at macros.
"ryguy7272" wrote: Either post your code, or use this code (I think this will pretty much do what you want): http://www.rondebruin.nl/copy2.htm Lots of other copy/paste/merge examples he http://www.rondebruin.nl/tips.htm Regards, Ryan--- -- RyGuy "queenmaam" wrote: I am recording a simple macro to insert a new worksheet and copy the content of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same
Thanks, Betty. I know I can do it that way, I'm just trying to automate it as
much as I can for others on my team. "Betty H" wrote: I find that it is simpler to make an exact copy of the existing worksheet. To do this make the worksheet you want to copy the active worksheet, hold the Ctrl button down while you click on the active worksheet tab and drag/drop it next to it. Then release the Ctrl button. This creates an exact duplicate of the active worksheet. -- Betty H Salem, OR "queenmaam" wrote: I am recording a simple macro to insert a new worksheet and copy the content of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying the active worksheet to another worksheet in the same work
I would say that the macro has the original sheet name hard-coded due to the
macro recorder steps. Change any hard-coded name to Activesheet. i.e. original code Sheets("Sheet1").cells.copy etc. Change to ActiveSheet.cells.copy etc. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 11:13:02 -0700, queenmaam wrote: I am recording a simple macro to insert a new worksheet and copy the content of the active worksheet to it. Using the macro recorder, it works fine the first time, but if I try to use the same macro to copy the second sheet (the one just created) to a third sheet, it still copies from the original (first) sheet. I can see why that happens, but I'm not sure how to rework the macro to copy from the active sheet rather than from the original sheet. The goal is to copy information from one week's sheet to create a sheet for the next week for the duration of a project. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula from one worksheet to another worksheet | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Copying all formats from worksheet to worksheet | Excel Worksheet Functions | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) |