Automatic copy a worksheet,

B

bioyyy

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.
 
O

Otto Moehrbach

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
 
D

Dave Peterson

You can ctrl-click on the master worksheet tab and drag it to copy that
worksheet.
 
R

Ron de Bruin

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 said:
I'm Not getting this Dave; Can you communicate it again, with added help?
Jim
Click to expand...
 
D

Dave Peterson

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.
 
J

Jim May

Thanks Ron, made clear (as a bell)..
Jim

Ron de Bruin said:
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
Click to expand...
 
J

Jim May

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
 
D

Dave Peterson

And remember if you arrange your windows nicely, you can move/copy between
workbooks, too.

Jim said:
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
Click to expand...
 
B

bioyyy

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.
 
Top