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

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://

