| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
error on update
I have a template that I created with a drop down list using validation from
within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you |
|
#2
|
|||
|
|||
|
Maybe you could type the list into the data|validation dialog.
Maybe you could put the list on the same sheet (in an out of the way spot) so it, too, gets copied. Maybe you could copy the other sheet (with the validation) at the same time. Marlis wrote: I have a template that I created with a drop down list using validation from within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you -- Dave Peterson |
|
#3
|
|||
|
|||
|
No, I need to be able to move it to another book. I have clients, each
having their own book, into which I move each of their invoices. Is it possible for me to be able to to somehow accomplish this without the error? "Dave Peterson" wrote: Maybe you could type the list into the data|validation dialog. Maybe you could put the list on the same sheet (in an out of the way spot) so it, too, gets copied. Maybe you could copy the other sheet (with the validation) at the same time. Marlis wrote: I have a template that I created with a drop down list using validation from within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you -- Dave Peterson |
|
#4
|
|||
|
|||
|
You have to get that list into the other workbook some way.
Can you explain why none of the suggestions would fit? Marlis wrote: No, I need to be able to move it to another book. I have clients, each having their own book, into which I move each of their invoices. Is it possible for me to be able to to somehow accomplish this without the error? "Dave Peterson" wrote: Maybe you could type the list into the data|validation dialog. Maybe you could put the list on the same sheet (in an out of the way spot) so it, too, gets copied. Maybe you could copy the other sheet (with the validation) at the same time. Marlis wrote: I have a template that I created with a drop down list using validation from within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you -- Dave Peterson -- Dave Peterson |
|
#5
|
|||
|
|||
|
I have tried copying and pasting the list into the new workbook, but I still
get the error. "Dave Peterson" wrote: You have to get that list into the other workbook some way. Can you explain why none of the suggestions would fit? Marlis wrote: No, I need to be able to move it to another book. I have clients, each having their own book, into which I move each of their invoices. Is it possible for me to be able to to somehow accomplish this without the error? "Dave Peterson" wrote: Maybe you could type the list into the data|validation dialog. Maybe you could put the list on the same sheet (in an out of the way spot) so it, too, gets copied. Maybe you could copy the other sheet (with the validation) at the same time. Marlis wrote: I have a template that I created with a drop down list using validation from within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you -- Dave Peterson -- Dave Peterson |
|
#6
|
|||
|
|||
|
If you copy and paste the list, you'll have to reassign data|validation.
If the list is on the same worksheet, when you copy the sheet (edit|move or copy sheet, not copy the cells), then the data|validation will point at the new sheet) Marlis wrote: I have tried copying and pasting the list into the new workbook, but I still get the error. "Dave Peterson" wrote: You have to get that list into the other workbook some way. Can you explain why none of the suggestions would fit? Marlis wrote: No, I need to be able to move it to another book. I have clients, each having their own book, into which I move each of their invoices. Is it possible for me to be able to to somehow accomplish this without the error? "Dave Peterson" wrote: Maybe you could type the list into the data|validation dialog. Maybe you could put the list on the same sheet (in an out of the way spot) so it, too, gets copied. Maybe you could copy the other sheet (with the validation) at the same time. Marlis wrote: I have a template that I created with a drop down list using validation from within the same book. How I can get the validation to work when I move the sheet to another book? (I get a value error when it updates) Thank you -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update links prompt not wanted | Excel Discussion (Misc queries) | |||
| keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
| Stock Update | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Edit Links: make update manual | Excel Discussion (Misc queries) | |||
Hybrid Mode
