Anonnymouse
New Member
- Joined
- Jun 28, 2023
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hello Excel Wizards,
I am trying to extract two sheets of information based on column F (Vin) on sheet Echo and column H (Vin) on sheet Tango. If the cells inside these columns match I would like to paste in onto another sheet but if the column R on sheet Echo is empty I would like not to paste this information.
If those conditions are met, I'm trying to paste the highlighted cells onto the new worksheet.
Ps. I could not highlight so I put emojis.
Thank you!
Sheet Echo ^
Sheet Tango ^
Final Result v
I am trying to extract two sheets of information based on column F (Vin) on sheet Echo and column H (Vin) on sheet Tango. If the cells inside these columns match I would like to paste in onto another sheet but if the column R on sheet Echo is empty I would like not to paste this information.
If those conditions are met, I'm trying to paste the highlighted cells onto the new worksheet.
Ps. I could not highlight so I put emojis.
Thank you!
A | D | E | G | I | L | M | N | O | P | Q | ||||||||
Sheet Echo | Date | Info | Random | Misc | Vin | ran | Additional Info | dom | Number | General Info | O | ? | P | % | @ | $ | # | Brake Speed |
9/11/2023 | 1a | 1564587 | 9874 | 1877 | Y | Red | Z | 9 | Matte | Aaaa | ggg | ddd | sss | aaa | 5555 | Alpha | 0:14 | |
9/10/2023 | 1a | 13567496 | 975643 | 1977 | Y | Blue | Z | 9 | Clear | aaaa | ggg | ddd | sss | aaa | 5555 | Alpha | 3:13 | |
9/5/2023 | 3a | 1354648657 | 98324 | 1877 | Y | Red | Z | Matte | bbbbb | ggg | ddd | sss | aaa | 5555 | Delta | 2:24 | ||
9/6/2023 | 2a | 1366546 | 984331 | 2074 | Y | Purple | Z | Flat | ccccc | ggg | ddd | sss | aaa | 5555 | Delta | 3:25 | ||
9/8/2023 | 3a | 134568 | 9843301 | 2074 | Y | Purple | Z | 9 | Flate | ddddd | ggg | ddd | sss | aaa | 5555 | Charlie | 0:37 | |
9/9/2023 | 2a | 1357 | 98736513 | 1977 | Y | Blue | Z | Clear | eeeee | ggg | ddd | sss | aaa | 5555 | Charlie | 0:10 | ||
9/8/2023 | 2a | 1357 | 98736513 | 1977 | Y | Blue | ||||||||||||
9/10/2023 | 5a | 35479 | 6549892 | 7718 | Y | Black | Z | 4 | Water | eee | ggg | ddd | sss | aaa | 5555 | ALpha | 1:10 | |
9/11/2023 | 4a | 697856 | 984325 | 7718 | Y | Black | Z | 5 | Water | ffff | ggg | ddd | sss | aaa | 5555 | Beta | 2:10 |
A | C | E | F | I | J | K | L | M | N | O | P | Q | R | T | ||||||
Date | + | Infoormation | A | B | Station | Vin | rr | rrr | rrr | rrrr | rrrr | cccc | ccc | cc | c | ccc | Additional Info | d | General Info | |
Sheet Tango | 9/12/2023 | Bad Brakes | eeee | rrrr | b1 | 1877 | Red | Matte | ||||||||||||
9/13/2023 | Good Brakes | eeee | rrrr | b1 | 1977 | Blue | Clear | |||||||||||||
9/14/2023 | Decent Brakes | eeee | rrrr | b2 | 1877 | Red | Matte | |||||||||||||
9/15/2023 | Mid Brakes | eeee | rrrr | b3 | 2074 | Purple | Flat | |||||||||||||
9/16/2023 | Good Brakes | eeee | rrrr | b5 | 2074 | Purple | Flate | |||||||||||||
9/17/2023 | Good Brakes | eeee | rrrr | b6 | 1977 | Blue | Clear | |||||||||||||
9/18/2023 | Good Brakes | eeee | rrrr | b7 | 1977 | Blue | ||||||||||||||
9/19/2023 | Good Brakes | eeee | rrrr | b8 | 7718 | Black | Water | |||||||||||||
9/20/2023 | Good Brakes | eeee | rrrr | b9 | 7718 | Black | Water |
Final Result v
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O |
Date | Info | Vin | Additional Info | Number | General Info | # | Brake Speed | Date | Infoormation | Station | Vin | Additional Info | General Info | |
9/11/2023 | 1a | 1877 | Red | 9 | Matte | Alpha | 0:14 | 9/12/2023 | Bad Brakes | b1 | 1877 | Red | Matte | |
9/10/2023 | 1a | 1977 | Blue | 9 | Clear | Alpha | 3:13 | 9/13/2023 | Good Brakes | b1 | 1977 | Blue | Clear | |
9/5/2023 | 3a | 1877 | Red | Matte | Delta | 2:24 | 9/14/2023 | Decent Brakes | b2 | 1877 | Red | Matte | ||
9/6/2023 | 2a | 2074 | Purple | Flat | Delta | 3:25 | 9/15/2023 | Mid Brakes | b3 | 2074 | Purple | Flat | ||
9/8/2023 | 3a | 2074 | Purple | 9 | Flate | Charlie | 0:37 | 9/16/2023 | Good Brakes | b5 | 2074 | Purple | Flate | |
9/9/2023 | 2a | 1977 | Blue | Clear | Charlie | 0:10 | 9/17/2023 | Good Brakes | b6 | 1977 | Blue | Clear | ||
9/8/2023 | 2a | 1977 | Blue | 9/18/2023 | Good Brakes | b7 | 1977 | Blue | ||||||
9/10/2023 | 5a | 7718 | Black | 4 | Water | ALpha | 1:10 | 9/19/2023 | Good Brakes | b8 | 7718 | Black | Water | |
9/11/2023 | 4a | 7718 | Black | 5 | Water | Beta | 2:10 | 9/20/2023 | Good Brakes | b9 | 7718 | Black | Water |