saving template
I created a book which I saved as a template. The book has 3 sheets: an
invoice, a customer list, and a "shipping list". I used validation to create some drop down lists in the sheet named invoice. I want to be able to save each invoice in a separate book, without copying the other two pages. I'm not sure how to do this. thank you |
You can right click on the invoice worksheet tab and choose move or copy.
Click that copy checkbox in the bottom and copy that worksheet to a new workbook. Then save that new workbook. Marlis wrote: I created a book which I saved as a template. The book has 3 sheets: an invoice, a customer list, and a "shipping list". I used validation to create some drop down lists in the sheet named invoice. I want to be able to save each invoice in a separate book, without copying the other two pages. I'm not sure how to do this. thank you -- Dave Peterson |
When I copy the page to another book, I get an error message "value". I know
it is because of the validation, but I don't know how to fix it. As long as I have the original template open, it's fine, but as soon as I close the original, I get the error. Thank you "Dave Peterson" wrote: You can right click on the invoice worksheet tab and choose move or copy. Click that copy checkbox in the bottom and copy that worksheet to a new workbook. Then save that new workbook. Marlis wrote: I created a book which I saved as a template. The book has 3 sheets: an invoice, a customer list, and a "shipping list". I used validation to create some drop down lists in the sheet named invoice. I want to be able to save each invoice in a separate book, without copying the other two pages. I'm not sure how to do this. thank you -- Dave Peterson |
If it is caused by data|Validation, maybe you could enter the values in the
data|validation dialog--or move the list to a hidden spot on the same worksheet. Marlis wrote: When I copy the page to another book, I get an error message "value". I know it is because of the validation, but I don't know how to fix it. As long as I have the original template open, it's fine, but as soon as I close the original, I get the error. Thank you "Dave Peterson" wrote: You can right click on the invoice worksheet tab and choose move or copy. Click that copy checkbox in the bottom and copy that worksheet to a new workbook. Then save that new workbook. Marlis wrote: I created a book which I saved as a template. The book has 3 sheets: an invoice, a customer list, and a "shipping list". I used validation to create some drop down lists in the sheet named invoice. I want to be able to save each invoice in a separate book, without copying the other two pages. I'm not sure how to do this. thank you -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com