Is there a way to autopoulate a row in between two set rows with data in column A to match data entered in another cell on another sheet. this first one the blue line would be auto added and the employee name would be autoppoulated from the second one.
| Kane 1.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 3 | Employee Name | 12-Jan | 13-Jan | 14-Jan | 15-Jan | 16-Jan | |||
| 4 | Blank | ||||||||
| 5 | total | ||||||||
Dash | |||||||||
| Kane 1.xlsx | ||||
|---|---|---|---|---|
| J | K | |||
| 3 | Employee | Employee name | ||
| 4 | 1 | Stump, James | ||
| 5 | 2 | Daggy, Dillain | ||
| 6 | 3 | Daggy, Dillain | ||
| 7 | 4 | Donihoo, Dillon | ||
| 8 | 5 | Lopez, Andrew | ||
| 9 | 6 | |||
| 10 | 7 | |||
| 11 | 8 | |||
| 12 | 9 | |||
| 13 | 10 | |||
| 14 | 11 | |||
| 15 | 12 | |||
| 16 | 13 | |||
| 17 | 14 | |||
| 18 | 15 | |||
| 19 | 16 | McCain, Austin | ||
| 20 | 17 | |||
| 21 | 18 | |||
| 22 | 19 | |||
| 23 | 20 | |||
Input page | ||||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| K4:K23 | List | =Database!$A$2:$A$10 |
