Hi Roger,

Please can you explain a little more about once your data is validated.

Generally you cannot automatically move data to other locations.

There are some ways to do it and I would suggest that you use a userform to
enter the data validate it and then put it in the desired location.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Roger" wrote:

how do i automatically move data to a seperate sheet once a specific cell is
validated?