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