Spreadsheet: 876640d1723373448-formula-to-calculate-one-persons-contributions-bernie-rubble-map2-2-365-aligw
Sheet: Blad1

 | BOOTMAN BEWEGINGEN |  |  |  |  |  |  |  |  |  | Dit jaar:
 | Datum |  | [NAME] | Zaterdag | Weekend | Boatmen |  | Naam Schip | [NAME] | In/Uit | Aanvang | Einde | Van | Naar | Stand-by |  | Agent | [NAME] |  |  |  | Extra | Loodsen vervoer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Van | Tot |  | 1 | 2 | 3 | 4
1 | 2024-08-02 00:00:00 |  | x |  |  | 2 |  | ADHEMAR DE SAINT-VENANT |  | Canc. | 21:45 | 22:15 | K104 | Rede |  |  | Hmb | RW | AV |  |  | RW
2 | 2024-08-02 00:00:00 |  | x |  |  | 2 |  | ADHEMAR DE SAINT-VENANT |  | > | 23:45 | 23:55 | K104 | Rede |  |  | [NAME] | RW | AV |  |  | AV
3 | 2024-08-03 00:00:00 |  |  | x |  | 2 |  | MIDDELBURG |  | < | 18:20:00 | 18:50:00 | Rede | K206 |  |  | Hmb | BW | RW |  |  | BW
4 | 2024-08-04 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR |  | < | 17:45:00 | 18:45:00 | Rede | K603 |  |  | Vpo | BW | EV |  |  | EV
5 | 2024-08-05 00:00:00 | ma |  |  | x | 2 |  | MIDDELBURG |  | > | 0:20:00 | 0:50:00 | K205 | Rede |  |  | [NAME] | BW | RW |  |  | BW
6 | 2024-07-07 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR |  | < | 16:00 | 16:15 | Rede | K604 |  |  | Vpo | ED | AV |  |  | AV
7 | 2024-08-08 00:00:00 | ma |  |  |  | 2 |  | ESVAGT MERCATOR |  | > | 19:45 | 20:00 | K604 | Rede |  |  | [NAME] | AV | EV |  |  | AV
8 | 2024-08-13 00:00:00 | za |  | x |  | 2 |  | UAL LOBITO |  | < | 20:45 | 21:15 | Sl. Dem | K315 |  |  | Vpo | AV | EV |  |  | EV
9 | 2024-07-14 00:00:00 | zo |  |  | x | 2 |  | ANCHORAGE |  | < | 09:15 | 09:30 | Rede | K204 |  |  | Hmb | AV | EV |  |  | AV
10 | 2024-07-14 00:00:00 | zo |  |  | x | 2 |  | ANCHORAGE |  | > | 13:15 | 13:20 | K204 | Shift |  |  | Hmb | AV | EV |  |  | AV
 | The rows above are individual movements done by up to 4 boatmen. To report my own movements to the paying agency I need a table like the one above that only shows the row with my (BW) movements.  So if I fill in a row in the table above that contains my initials ''BW'', I would like that identical line to appear in the table below without the rows with the other initials, then I can simply take a print screen of that table and forward it.  Copying 'all'  rows automatically is no problem, but I have no idea how to copy the individual (BW) rows automatically to the table below.    in the lower table are the lines i would lik to see, altough they are now manually copied there by me...
1 | 2024-08-03 00:00:00 | 2024-08-03 00:00:00 |  | x |  | 2 |  | MIDDELBURG | 90 | < | 18:20:00 | 18:50:00 | Rede | K206 |  |  | Hmb | BW | RW |  |  | BW
2 | 2024-08-04 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR | 59 | < | 17:45:00 | 18:45:00 | Rede | K603 |  |  | Vpo | BW | EV |  |  | EV
3 | 2024-08-05 00:00:00 | ma |  |  | x | 2 |  | MIDDELBURG | 90 | > | 0:20:00 | 0:50:00 | K205 | Rede |  |  | [NAME] | BW | RW |  |  | BW
4
5
6
7
8
9
10
 |  | 45507 | 0 | x | 0 | 2 | 0 | MIDDELBURG | 90 | < | 0.7638888888888888 | 0.7847222222222222 | Rede | K206 | 0 | 0 | Hmb | BW | RW | 0 | 0 | BW | 0
 | 2024-08-04 00:00:00 | zo | 0 | 0 | x | 2 | 0 | ESVAGT MERCATOR | 59 | < | 0.7395833333333334 | 0.78125 | Rede | K603 | 0 | 0 | Vpo | BW | EV | 0 | 0 | EV | 0
 | 2024-08-05 00:00:00 | ma | 0 | 0 | x | 2 | 0 | MIDDELBURG | 90 | > | 0.01388888888888889 | 0.03472222222222222 | K205 | Rede | 0 | 0 | [NAME] | BW | RW | 0 | 0 | BW | 0