View Single Post
  #8   Report Post  
Jim May
 
Posts: n/a
Default 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