Save a single worksheet in Excel as a single file.

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

Guest

I have multipe worksheets in a single workbook. I would like to be able to
save each worksheet individually. I want to send each worksheet to an
individual, I do not want to send the entire workbook. All information must
be retained in the one workbook, but as the individual worksheets are
updated, the individual worksheet needs to be saved and sent to that
individual. Help anyone? Thanks.

Linda
 
Dakota said:
I have multipe worksheets in a single workbook. I would like to be able to
save each worksheet individually. I want to send each worksheet to an
individual, I do not want to send the entire workbook. All information must
be retained in the one workbook, but as the individual worksheets are
updated, the individual worksheet needs to be saved and sent to that
individual. Help anyone? Thanks.

Linda
Click to expand...

right click on the sheet tab, select move or copy, click down arrow
on top box that says "to book:", select new book. You now have that
sheet in a new book.

gls858
 
Back
Top