Macro to copy active worksheet to new workbook
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 |
Macro to copy active worksheet to new workbook
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 |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com