copy the worksheets, to another file. copy them to the same file.
---------- Post added at 11:26 PM ---------- Previous post was at 11:24 PM ----------
Moving a Worksheet to Another Workbook (Tips.Net)
Summary: It is easy to move an Excel worksheet to another workbook following this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
As you develop more and more Excel workbooks, you may have the necessity of moving a worksheet from one workbook to another. You can do this by following these steps:
1. Make sure both the source and target workbooks are open.
2. Display the worksheet you want to move.
3. Choose Move or Copy Sheet from the Edit menu. This displays the Move or Copy dialog box. (Click here to see a related figure.)
4. Using the To Book pull-down list, choose the name of the target workbook. The list of worksheets in the Before Sheet list will change to reflect the workbook you selected.
5. In the Before Sheet list, select the worksheet that should come after the worksheet you selected in step 2.
6. Click on OK. The worksheet is moved.
__________________
I don't care if you are black, white, purple, green, Chinese, Japanese, Korean, hippie, cop, bum, admin, user, English, Irish, French, Catholic, Protestant, Jewish, Buddhist, Muslim, indian, cowboy, tall, short, fat, skinny, emo, punk, mod, rocker, straight, gay, lesbian, jock, nerd, geek, Democrat, Republican, Libertarian, Independent, driver, pedestrian, or bicyclist, either you're an asshole or you're not.
|