Excel 2003:
I created a form for all my customers, which include a drop-down list (created drop-down list by using validation). I wanted to create an excel document for each individual customer by copying and pasting the 2 sheets into a new book for each customer. When I do that, the drop down list appears to work in the newly pasted book but once I save, exit, and reenter that same excel file, the drop down list does not work. It is quite frustrationg and I was wondering if you may help? Thanks in advance
I created a form for all my customers, which include a drop-down list (created drop-down list by using validation). I wanted to create an excel document for each individual customer by copying and pasting the 2 sheets into a new book for each customer. When I do that, the drop down list appears to work in the newly pasted book but once I save, exit, and reenter that same excel file, the drop down list does not work. It is quite frustrationg and I was wondering if you may help? Thanks in advance
