I have a spreadsheet with 5 columns (A - E) and over 2000 rows 1 - 2000.
I was wondering if there is a way to take information (whole row) basiced off one cell and move it to another work sheet.
Example:
In one excel document I have two sheets, Sheet 1 titled "Everyone" Sheet 2 titled "YES"
Sheet 1 A2 has persons name, B2 Address, C2 Phone #, . . . E2 has values Yes or No
Is there a way I can copy the infromtion from sheet 1 with column E that have a value of "YES" and move it to the other sheet?
Thank you..
Bookmarks