Is there something specific you need here? You'll get more help if you
post some code and ask for specific help, rather than asking for the
code to be written for you.

To start, try recording your steps to see what the recorded code looks
like. You would then need to generalize the macro to always act on the
active workbook.

--JP

On May 25, 12:34 am, Macca wrote:
Hi,

I want to create a macro that will allow me to use a shortcut that will:

(1) copy the values & the format (i.e. not the formulas) of the active
worksheet to a new workbook; and

(2) save that new workbook as "Claim" in a specified file location.

Hope someone can help