I've built a very simple spreadsheet that has all the data together, but would like some of that to copy to additional pages in the same workbook, depending upon the data in one cell. For example, columns are name, DOB, etc. If I enter Yes in a particular cell in one of the rows, I would like that whole row to copy to additional page in the workbook and, in turn, be removed from that additional page if that same cell is changed from say yes, to no. I am a complete novice, so this may not even be possible. Any help would be greatly appreciated. Trying to make my new position more efficient. Hoping this makes sense. Please feel free to ask any questions for clarification. Thanks in advance!
