Excel, Save A Sheet Out Of Worrk Book

[flg@access4less]

I have a work book with 10 sheets in it.I would like to find a way t
save a sheet from it ,wih out saving the whole work book.I do now yo
can cut ,and paste it also create a copy of it. This is what im talkin
about.this sheet has to stay in the work book. I' JUST WANT A COPY OF I
EVERY TIME I SAVE THE SHEE

 

[AlfD]

Hi!

Worksheets don't exist outside workbooks. So your process has to be t
copy the required sheet and insert it in a new (empty) workbook.

Edit > Move or Copy Sheet... On the form, check Create a Copy and giv
the target book a name.

The original workbook will be unchanged. The new one may have som
empty sheets (depends on your default settings as to how many) but the
can all be deleted if you wish. To all intents and purposes you now hav
a saved sheet.

Al