Save a single worksheet in Excel as a single file.

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
 
G

gls858

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Insert Existing Worksheets into a new Workbook 2
Sending a single worksheet as an attachment 3
Using VBA to copy data into another worksheet ??? 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
display worksheet name in a cell 0
Best way to set up Excel customer list? 5
need to extract data from a few worksheets to another 3

Top