inserted worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have 15 spreadsheets saved. I have to add 14 of them to the 1st one as inserted worksheets. I have figured out how to insert a new/blank worksheet, but cannot figure out how to add the ones I already have saved as an inserted worksheet. Is this even possible? Any help would be appreciated. Thanks, Michelle
 
Michele
I take it you have 15 workbooks (files). You have at least one sheet in
each workbook that you want to copy to the first workbook. Is that correct?
If it is, do this. Open the destination workbook (what you call the
first one) and at least one of the other workbooks. I say at least one
because you may not have the memory to open them all. If you can open them
all, then do so.
With a source file open and the source sheet on the screen, Do Edit -
Move Or Copy Sheet. In the "To book:" box, select your destination file.
Check the "Create a Copy" box. In the "Before sheet:" box select where in
the sheet sequence of the destination file you want to put this sheet.
Click OK. Done. Repeat this process for each of other 13 files.
If this task is just a one-time thing then do the above. However, if
this is something that you do repeatedly, you might consider automating the
process with a macro. HTH Otto
Michelle said:
Hi. I have 15 spreadsheets saved. I have to add 14 of them to the 1st one
Click to expand...
as inserted worksheets. I have figured out how to insert a new/blank
worksheet, but cannot figure out how to add the ones I already have saved as
an inserted worksheet. Is this even possible? Any help would be appreciated.
Thanks, Michelle
 
Thank you. I was able to complete this & it looks great. Unfortunately, when I attempt to save it, I get the following message:

"The selected file type does not support workbooks that contain multiple sheets.
-to save only the active sheet, click ok.
-to save all sheets, save them individually using a different file name for each, or choose a file type that supports multiple sheets
OK CANCEL
********if click ok then…***********
MYNAMEquizzes.scv.cvs may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?
-to keep this format, which leaves out any incompatible features, click yes
-to preserve the features, click no. Then save a copy in the latest Excel format.
-to see what might be lost, click help
help yes no"

If I click yes, It will only save the main quiz & the other 14 do not appear. If I click no, then I don't know how to save in "the latest Excel format". I'm using excel 2002 (10.2614.2625). Any ideas? By the way, this is a one time deal & I don't intend to have to complete this type of task anytime again. I do apprieciate the advice if I was, though :)
 
Michelle
I understood that you had Excel files in the .xls format. Apparently
you don't. What are the formats of the 15 files? If they are not .xls, can
you save them as .xls files? HTH Otto
Michelle said:
Thank you. I was able to complete this & it looks great. Unfortunately,
Click to expand...
when I attempt to save it, I get the following message:
"The selected file type does not support workbooks that contain multiple sheets.
-to save only the active sheet, click ok.
-to save all sheets, save them individually using a different file name
Click to expand...
for each, or choose a file type that supports multiple sheets
OK CANCEL
********if click ok then.***********
MYNAMEquizzes.scv.cvs may contain features that are not compatible with
Click to expand...
CSV (Comma delimited). Do you want to keep the workbook in this format?
-to keep this format, which leaves out any incompatible features, click yes
-to preserve the features, click no. Then save a copy in the latest Excel format.
-to see what might be lost, click help
help yes no"

If I click yes, It will only save the main quiz & the other 14 do not
Click to expand...
appear. If I click no, then I don't know how to save in "the latest Excel
format". I'm using excel 2002 (10.2614.2625). Any ideas? By the way, this
is a one time deal & I don't intend to have to complete this type of task
anytime again. I do apprieciate the advice if I was, though :)
 
Back
Top