So, i can't figure out how to copy an entire row to a different page based on the entry in one cell.
Like, if the cell value is 2 the row goes to sheet 2, if the cell value is 3 the row goes to sheet 3. I'de really like to use words and a drop down menu though... but think that will be considerably more confusing.
It's for a number of logs. ie sheet 1 is the master log, and the other sheets are just status tracking logs.
thank you,
srh5454
Like, if the cell value is 2 the row goes to sheet 2, if the cell value is 3 the row goes to sheet 3. I'de really like to use words and a drop down menu though... but think that will be considerably more confusing.
It's for a number of logs. ie sheet 1 is the master log, and the other sheets are just status tracking logs.
thank you,
srh5454