how do i automatically move data to a seperate sheet once a specific cell is validated?
R Roger Feb 7, 2007 #1 how do i automatically move data to a seperate sheet once a specific cell is validated?
M Martin Fishlock Feb 7, 2007 #2 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.
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.
