Spreadsheet: 847746d1698627636-need-help-to-manipulate-and-delete-data-across-multiple-worksheets-example-1
Sheet: Sheet1

Sheet 1 - Data broken into most recent and org by groups. |  |  |  |  |  | Sheet 2 - Sheet 3 listing only the most recent dates. |  |  |  |  |  | Sheet 3 Data exported from another program.
Location A
Full Name | Student Number | Location | Division | Date |  | Full Name | Student Number | Location | Division | Date |  | Full Name | Student Number | Location | Division | Date
Scooby Doo | garsefgre | a | a | 2023-10-15 00:00:00 |  | Scooby Doo | garsefgre | a | a | 2023-10-15 00:00:00 |  | [NAME] | argfdsads | a | a | 2023-06-06 00:00:00
[NAME] | argfdsads | a | a | 2023-06-06 00:00:00 |  | [NAME] | argfdsads | a | a | 2023-06-06 00:00:00 |  | [NAME] | 34gtad | b b2 | a | 2022-12-10 00:00:00
[NAME] | opaiudjf | a | a | 2023-05-04 00:00:00 |  | [NAME] | opaiudjf | a | a | 2023-05-04 00:00:00 |  | [NAME] | opaiudjf | a | a | 2023-05-04 00:00:00
 |  |  |  |  |  | [NAME] | 12sd7 | b | a | 2023-07-18 00:00:00 |  | Brer Rabbit | avead | b | a | 2023-04-05 00:00:00
 |  |  |  |  |  | Brer Rabbit | avead | b | a | 2023-04-05 00:00:00 |  | [NAME] | 32gvad | c | a | 2023-02-21 00:00:00
Location B |  |  |  |  |  | [NAME] | 34gtad | b b2 | a | 2022-12-10 00:00:00 |  | Alf Neuman | 986kfg | d d2 | a | 2022-12-18 00:00:00
Full Name | Student Number | Location | Division | Date |  | Daffy Duck | 06dfg | c | a | 2023-03-05 00:00:00 |  | [NAME] | nsdf5 | e | a | 2022-06-19 00:00:00
[NAME] | 12sd7 | b | a | 2023-07-18 00:00:00 |  | [NAME] | 32gvad | c | a | 2023-02-21 00:00:00 |  | [NAME] | 12sd7 | b | a | 2023-07-18 00:00:00
Brer Rabbit | avead | b | a | 2023-04-05 00:00:00 |  | [NAME] | lpa0sdjnha | c | a | 2022-06-19 00:00:00 |  | Daffy Duck | 06dfg | c | a | 2023-03-05 00:00:00
[NAME] | 34gtad | b b2 | a | 2022-12-10 00:00:00 |  | Wile E Coyote | bacvq | d | a | 2021-05-26 00:00:00 |  | [NAME] | w5gn6yu | d d2 | a | 2023-03-05 00:00:00
 |  |  |  |  |  | [NAME] | w5gn6yu | d d2 | a | 2023-03-05 00:00:00 |  | [NAME] | asdvra37 | e | a | 2021-09-09 00:00:00
 |  |  |  |  |  | Alf Neuman | 986kfg | d d2 | a | 2022-12-18 00:00:00 |  | Wile E Coyote | bacvq | d | a | 2021-05-26 00:00:00
Location C |  |  |  |  |  | [NAME] | asdvra37 | e | a | 2023-10-11 00:00:00 |  | [NAME] | lpa0sdjnha | c | a | 2022-06-19 00:00:00
Full Name | Student Number | Location | Division | Date |  | [NAME] | nsdf5 | e | a | 2022-06-19 00:00:00 |  | [NAME] | argfdsads | a | a | 2022-06-06 00:00:00
Daffy Duck | 06dfg | c | a | 2023-03-05 00:00:00 |  |  |  |  |  |  |  | [NAME] | 34gtad | b b2 | a | 2022-06-03 00:00:00
[NAME] | 32gvad | c | a | 2023-02-21 00:00:00 |  |  |  |  |  |  |  | Daffy Duck | 06dfg | c | a | 2021-10-11 00:00:00
[NAME] | lpa0sdjnha | c | a | 2022-06-19 00:00:00 |  |  |  |  |  |  |  | [NAME] | w5gn6yu | d d2 | a | 2022-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Scooby Doo | garsefgre | a | a | 2023-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | asdvra37 | e | a | 2023-10-11 00:00:00
Location D
Full Name | Student Number | Location | Division | Date
Wile E Coyote | bacvq | d | a | 2021-05-26 00:00:00
[NAME] | w5gn6yu | d d2 | a | 2023-03-05 00:00:00
Alf Neuman | 986kfg | d d2 | a | 2022-12-18 00:00:00
Location E
Full Name | Student Number | Location | Division | Date
[NAME] | asdvra37 | e | a | 2023-10-11 00:00:00
[NAME] | nsdf5 | e | a | 2022-06-19 00:00:00