Sheet 2 needs to list the students that have grade B from Sheet 1 as displayed below. Sheet 2 needs to work in general for any set of data that is pasted to Sheet 1, which can be up to 500 records.
The advanced filter was used successfully for Sheet 2 but when a different set of data was pasted for Sheet 1, it doesn’t work and falls short. Sheet 2 needs to work for any set of data that is pasted to Sheet 1.
This is a representative example for a different problem. If a solution for the example below can be found, then the real example can be worked.
Many thanks,
Tom F
The advanced filter was used successfully for Sheet 2 but when a different set of data was pasted for Sheet 1, it doesn’t work and falls short. Sheet 2 needs to work for any set of data that is pasted to Sheet 1.
This is a representative example for a different problem. If a solution for the example below can be found, then the real example can be worked.
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Sheet 1 | ||||||
| 2 | |||||||
| 3 | Last Name | First Name | Grade | ||||
| 4 | Doe | John | B | ||||
| 5 | Hur | Ben | U | ||||
| 6 | Little | Don | C | ||||
| 7 | Kelso | John | U | ||||
| 8 | Green | Hubert | A | ||||
| 9 | |||||||
Sheet1 | |||||||
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Sheet 2 | ||||||
| 2 | |||||||
| 3 | Last Name | First Name | Grade | ||||
| 4 | Hur | Ben | U | ||||
| 5 | Kelso | John | U | ||||
| 6 | |||||||
Sheet2 | |||||||
Many thanks,
Tom F
