Hello all.. first off I would like to say how pleased I am to find this board... I have undertaken trying to build a spreadsheat, but it appears that my vision and ability do not coincide with each other....

I have built the first page of my spreadsheat the way I want so far with drop down list and input ranges... my question now though is this..... at the far left on the spread sheet I have a dropdown list that includes what statues the information to the right currently is in rather the job information is waiting to begin currently being worked and finally that the work has been completed.. Upon completion I know longer need this information on the front page or on the list with the jobs currently ongoing or the one pending.... but yet I need to keep the information for future reference.. billing etc..

which leads me to my question... IS there away to automatically move all the cells to the right to another page when I select Completed on the drop down list.

Thanks again hope someone can help me out with this.