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.