How can I automate copying blank worksheet?

[unsworthcl]

Hi

I have an Excel workbook, with several worksheets. A master worksheet is used every week to complete sales figures. Problem is that end user doesn't know how to copy master worksheet and asks me to do for him.

Is it possible to create a button on master worksheet to copy itself and move to the end of existing sheets?

[Fendic]

Yes, you can record a macro to copy the sheet and add a button with the macro code attached.

First try: Tool=>Macro=>Record Macro =>(do whatever u need to record and name it, e.g. CopySheet)=>Stop Recording

Second: View=>Tool Bar=>Control Panel=>(add button)

Third: Right click the added button, it will bring you to the source code in VBA editor. and then find the souce code of macro "CopySheet", copy the code to the button's 'sub' block.

Others: you can also edit the button's caption, e.g. 'Copy the Sheet' to inform user. I am sure you know how to do that.

hope that helps
Fendic