I am working on a spreadsheet that I use to figure an inventory results. I
need to email only part of the information. I have thought of two methods to
acheive my result. One is create a macro that would delete the un-needed
worsheets and save the file to a new name. My other idea was to just create
a macro that would just hide the un-needed and show the sheets that our
accounting department needs for their records. Any suggestions on how to
best get this done

Hi Tim

I would just copy the sheet you want to another file.
Right click on Sheet tabMove or CopyDropdown Move to select New
workbookSelect Create a copyOK

If you switch on the macro recorder as you do this, then just run the
macros each time it is required.

Regards

Roger Govier



Tim wrote:

I am working on a spreadsheet that I use to figure an inventory results. I
need to email only part of the information. I have thought of two methods to
acheive my result. One is create a macro that would delete the un-needed
worsheets and save the file to a new name. My other idea was to just create
a macro that would just hide the un-needed and show the sheets that our
accounting department needs for their records. Any suggestions on how to
best get this done