Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel saving just a tab of a workbook
I would like to just save a workbook tab every time we print. It is designed
to be a packing slip and i would like to save each and every packing slip in a different folder, but i don't want to save the hold workbook Thank you PC |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel saving just a tab of a workbook
PC
No, you cannot save just one sheet. You can do a few other things though. 1) Hold down Ctrl while clicking on the sheet tab and drag it to a new location. You should see a small + which means it will copy. You could then rename this sheet tab to the number of the packing slip. 2) Right click on the sheet tab and select Move or Copy... and then select 'New Book' and check 'create a copy' this will copy the sheet to a new workbook, which can then be saved as the packing slip number. If there are formulae on the sheet you will need to 'kill' these first by highlighting the cells, copying them and then with the selection still made take editPaste special...Values (Do this after copying the worksheets as above this could be automated by macro if required, but you may find these routes suitable -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "PC Metal Fabrications" <PC Metal wrote in message ... I would like to just save a workbook tab every time we print. It is designed to be a packing slip and i would like to save each and every packing slip in a different folder, but i don't want to save the hold workbook Thank you PC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel workbook in SQL server using c# | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |