mingandmong
Active Member
- Joined
- Oct 15, 2014
- Messages
- 339
Hi
Im using excell 2016
i wish to exctract rows of certain cells of data into a new sheet when the two criteria are met in column "B"
my sheet has a 5000 rows and a just require a summary sheet
search column "B" 1st criteria = Name
B:9) extract cell E:9 D:9 & C:9 and place in a new sheet A2:C2
Then search Column "B" 2nd criteria = Daily (B:18) extract cell C:20, E:20, G:20, I:20, K:20, M:20, O:20 & Q:20
Im using excell 2016
i wish to exctract rows of certain cells of data into a new sheet when the two criteria are met in column "B"
my sheet has a 5000 rows and a just require a summary sheet
search column "B" 1st criteria = Name
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Then search Column "B" 2nd criteria = Daily (B:18) extract cell C:20, E:20, G:20, I:20, K:20, M:20, O:20 & Q:20
and place in a new sheet D2:K2
repeat for the remaining sheet in a loop
i have place links below.. many thanks in advance
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://ibb.co/ssd6gw7
https://ibb.co/MR6qQH7
http://
[/FONT]
repeat for the remaining sheet in a loop
i have place links below.. many thanks in advance
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://ibb.co/ssd6gw7
https://ibb.co/MR6qQH7
http://
![](/board/proxy.php?image=https%3A%2F%2Fi.ibb.co%2FJrwyc7Z%2FCapture-PNG1.png&hash=b2098ef3b87b38137a5ac90dacce22e9)
![](/board/proxy.php?image=https%3A%2F%2Fi.ibb.co%2FjLR7sYD%2FCapture-PNG2.png&hash=b5ed406c72161343308c2c1e6dbdb0b4)