Hi,
I have two sheets of school info lists. Both have school ID numbers in column B.
Sheet 1 is all schools, sheet 2 is only certain schools.
I need sheet 1 to ONLY contain the rows that are in sheet 2.
How would I automatically delete all rows on sheet 1 that do NOT have the school ID numbers in column b that are listed in sheet 2, column b?
Thanks,
Synthia
Bookmarks