Search for Last Name A-K on one tab and return all data in row on another tab - Google Sheets
I have Google Sheet that I use where we input students information for offenses on one tab "Master List". I need to have any students whose names begin with A thru K to have all data from their row pulled to a different tab "A-K".
Tab "Master List" is setup like this:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Last Name | First Name | ID # | Date of Offense | Notes |
| 2 | Smith | Mark | 0001 | 1/29/26 | Blah |
| 3 | Doe | John | 0002 | 1/30/26 | Blah |
Tab "A-K" is setup like this:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Last Name | First Name | ID # | Date of Offense | Notes |
| 2 | |||||
| 3 |
In this example, only the data from row 3 of "Master List" should be pulled onto the tab "A-K".
New students are added to this list multiple times a day, so I need it to automatically pull this data from "Master List" onto tab "A-K" as soon as it is entered.