Hi Guys,
Is it possible to add to an existing data validation list the value I just entered into the cell and then have that value available from the dropdown selection next time, even if it means using a macro button to add the value, without having to readjust the list each time I have a new value to add to the list.
My only thought at the moment would be to record an update to the list then try and modify this to suit my needs. Any ideas?

regards
Trevor