| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatic copy a worksheet,
Hi,
Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. |
|
#2
|
|||
|
|||
|
Automatic copy a worksheet,
Record a macro while you move or copy the sheet and you will get the code.
You say "automatically". Do you mean you want this to happen without any direct action from you to execute the macro? If that is the case, post back and provide details about when you want this to happen. HTH Otto "bioyyy" wrote in message ... Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. |
|
#3
|
|||
|
|||
|
Automatic copy a worksheet,
You can ctrl-click on the master worksheet tab and drag it to copy that
worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson |
|
#4
|
|||
|
|||
|
Automatic copy a worksheet,
I'm Not getting this Dave; Can you communicate it again, with added help?
Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson |
|
#5
|
|||
|
|||
|
Automatic copy a worksheet,
Hi Jim
If you press the ctrl key when you drag the master sheet tab with your mice to the left or right you make a copy of the sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:jHs4f.1113$mV4.1102@dukeread02... I'm Not getting this Dave; Can you communicate it again, with added help? Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson |
|
#6
|
|||
|
|||
|
Automatic copy a worksheet,
Just to add to Ron's reply...
If you click on that worksheet, you can drag it to a new location (it just moves the worksheet). Ctrl-clicking and dragging will copy the worksheet. Jim May wrote: I'm Not getting this Dave; Can you communicate it again, with added help? Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson -- Dave Peterson |
|
#7
|
|||
|
|||
|
Automatic copy a worksheet,
Thanks Ron, made clear (as a bell)..
Jim "Ron de Bruin" wrote in message ... Hi Jim If you press the ctrl key when you drag the master sheet tab with your mice to the left or right you make a copy of the sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Jim May" wrote in message news:jHs4f.1113$mV4.1102@dukeread02... I'm Not getting this Dave; Can you communicate it again, with added help? Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson |
|
#8
|
|||
|
|||
|
Automatic copy a worksheet,
Thanks Dave
Almost daily I've been using the full 1) right-click on tab 2) Select copy 3) Choose before whatother tab VERSUS Now 1) Ctl+Click/Drag/Drop Net Gain 2 (less clicks)!!! Thanks for pointing out. Jim "Dave Peterson" wrote in message ... Just to add to Ron's reply... If you click on that worksheet, you can drag it to a new location (it just moves the worksheet). Ctrl-clicking and dragging will copy the worksheet. Jim May wrote: I'm Not getting this Dave; Can you communicate it again, with added help? Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson -- Dave Peterson |
|
#9
|
|||
|
|||
|
Automatic copy a worksheet,
And remember if you arrange your windows nicely, you can move/copy between
workbooks, too. Jim May wrote: Thanks Dave Almost daily I've been using the full 1) right-click on tab 2) Select copy 3) Choose before whatother tab VERSUS Now 1) Ctl+Click/Drag/Drop Net Gain 2 (less clicks)!!! Thanks for pointing out. Jim "Dave Peterson" wrote in message ... Just to add to Ron's reply... If you click on that worksheet, you can drag it to a new location (it just moves the worksheet). Ctrl-clicking and dragging will copy the worksheet. Jim May wrote: I'm Not getting this Dave; Can you communicate it again, with added help? Jim "Dave Peterson" wrote in message ... You can ctrl-click on the master worksheet tab and drag it to copy that worksheet. bioyyy wrote: Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#10
|
|||
|
|||
|
Automatic copy a worksheet,
Otto,
Thanks for your help! Oh, Dave too. Yes, after the information is filled out in the Master sheet, the macro will generate a copy of that sheet or ctrl + something to excute that. thanks again. "Otto Moehrbach" wrote: Record a macro while you move or copy the sheet and you will get the code. You say "automatically". Do you mean you want this to happen without any direct action from you to execute the macro? If that is the case, post back and provide details about when you want this to happen. HTH Otto "bioyyy" wrote in message ... Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. |
|
#11
|
|||
|
|||
|
Automatic copy a worksheet,
Hi Otto,
I got it. Did not know that is very simple! Greatly appreciated your help. "Otto Moehrbach" wrote: Record a macro while you move or copy the sheet and you will get the code. You say "automatically". Do you mean you want this to happen without any direct action from you to execute the macro? If that is the case, post back and provide details about when you want this to happen. HTH Otto "bioyyy" wrote in message ... Hi, Is there any way that a macro can automatically generate another copy of Master worksheet? So, I don't have to use "move or copy sheet" everytime. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy a Password Protected Excel Worksheet | Excel Worksheet Functions | |||
| copy page setup from worksheet to another within workbook | Excel Worksheet Functions | |||
| automatic copy cells into other worksheet?? | Excel Discussion (Misc queries) | |||
| copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Linear Mode
