Copying information from sheet 1 to sheet 2

[mcintoshmc]

Sheet 1 list all my interviews, and their status
Sheet 2 list all the people who have enrolled in school

Every interview does not enroll. How can I have anyone with a status of enrolled from sheet 1 to automatically copied over to sheet 2, and have sheet 2 sorted by date of enrollment?

 

[xenou]

Hi. Welcome to the board

Assuming "enrolled" (or something similar) is a column on Sheet1, and there is also a column for the date:

1) Sort Sheet1 by Enrollment date
2) Filter Sheet1 by Enrolled status
3) Copy rows
4) paste on Sheet2

**You may find it is simpler just to use sheet1. If you autofilter for status you will have only your enrolled individuals already.

Note: when sorting excel data, DO NOT let Excel decide what rows and columns to sort. Select the data area, then sort. Excel can make mistakes deciding what to sort and ruin a days (or weeks, or months) work.

Regards.