Saving one sheet within a workbook

Is it possible to save one sheet tht is contained within a workbook of 50+
sheets? Since I have to attach the saved sheet to a record in another
application it will save almost 2MB of space.

If, however, I have to re-open the newly saved workbook to make changes I
will need it to be "re-inserted" into the master workbook in order for the
multiple lookups to work.

I have tried to use 2 workbooks to facilitate the lookups and that is
working - until I have to reload a saved workbook, because it has a name that
is not recognized by the lookup workbook.

I do not like links (maybe because I am not as familiar with them as I
should be) and would like to have a way for the lookup workbook to
automatically recognize the main workbook - regardless of its name.

Hi David,
If you right click on the sheet tab and select Move or Copy then click for
make a copy you create a new workbook containing only that sheet. Since you
made a copy the original workbook is intact. You can continue to make changes
in the original and overwrite the copied sheet when you save
HTH


"David Vollmer" wrote:

> Is it possible to save one sheet tht is contained within a workbook of 50+
> sheets? Since I have to attach the saved sheet to a record in another
> application it will save almost 2MB of space.
>
> If, however, I have to re-open the newly saved workbook to make changes I
> will need it to be "re-inserted" into the master workbook in order for the
> multiple lookups to work.
>
> I have tried to use 2 workbooks to facilitate the lookups and that is
> working - until I have to reload a saved workbook, because it has a name that
> is not recognized by the lookup workbook.
>
> I do not like links (maybe because I am not as familiar with them as I
> should be) and would like to have a way for the lookup workbook to
> automatically recognize the main workbook - regardless of its name.

Thank you, Ray. That worked fine. I do have a question about later opening
that copied sheet if I need to make changes. If I create a new sheet in the
master workbook and copy the previously saved sheet into it I don't know if
the lookups will work. I will have to combine both workbooks (the master and
the lookup) first and see what happens.

If that works I will need to automate the process of creating a new workbook
and then if it is reopened for editing, automating the process of inserting
it back into the master workbook. There are 8 of us who will be using this
process.

Any additional suggestions will be appreciated.

Thank you,
David

"Ray A" wrote:

> Hi David,
> If you right click on the sheet tab and select Move or Copy then click for
> make a copy you create a new workbook containing only that sheet. Since you
> made a copy the original workbook is intact. You can continue to make changes
> in the original and overwrite the copied sheet when you save
> HTH
>
>
> "David Vollmer" wrote:
>
> > Is it possible to save one sheet tht is contained within a workbook of 50+
> > sheets? Since I have to attach the saved sheet to a record in another
> > application it will save almost 2MB of space.
> >
> > If, however, I have to re-open the newly saved workbook to make changes I
> > will need it to be "re-inserted" into the master workbook in order for the
> > multiple lookups to work.
> >
> > I have tried to use 2 workbooks to facilitate the lookups and that is
> > working - until I have to reload a saved workbook, because it has a name that
> > is not recognized by the lookup workbook.
> >
> > I do not like links (maybe because I am not as familiar with them as I
> > should be) and would like to have a way for the lookup workbook to
> > automatically recognize the main workbook - regardless of its name.