I have created many spreadsheet for other users and have tried to set them
up, as much as possible, so they add their own information into cells so
they can be in the data validation from list drop down boxes. I have had to
go back and add more room in the data validation list because it was longer
than I expected.

Is there I way I can set up the data validation so the list they get will
grow when they add more to the list?

Thanks
Mark