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.

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.

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

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

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

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

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

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

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

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.

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.