Find all data with 2 criteria

[Mega1]

looking to fine all data that matches 2 criteria and put in sheet2.
The data is made up of number company % total Tax and a y

I want to find a company and all the "y" it has

 

[Mega1]

it is picking that fine its when you goto the next row it not getting the info back

 

[Mega1]

still not working here is my file sheet2 is yours https://www.dropbox.com/s/e3y5xlqe39wdtoh/Weekly Totals 2017.xlsx?dl=0

 

[Mega1]

still not working on my data

https://www.dropbox.com/s/e3y5xlqe39wdtoh/Weekly Totals 2017.xlsx?dl=0

that is my file

 

[Aladin Akyurek]

Are we trying to run the set up on A6:O25 of Weekly Totals or on everything on Weekly Totals?

 

[Mega1]

everything in weekly totals it is split in to weeks and I mark them who is getting paid when there invoice matches mine

 

[Aladin Akyurek]

everything in weekly totals it is split in to weeks and I mark them who is getting paid when there invoice matches mine

What is the answer: Pick out just the first segment (the first week) or all of the weeks?

 

[Mega1]

all the weeks will need to be returned generally invoices will be paid monthly so when the month is done I will mark them paid only thing I need is what I mark as y

 

[Aladin Akyurek]

all the weeks will need to be returned generally invoices will be paid monthly so when the month is done I will mark them paid only thing I need is what I mark as y

You needed to adapt the suggested set up to your actual lay-out. See: https://www.dropbox.com/s/khqnrphqmkud9sm/Mega1 Weekly Totals 2017.xlsx?dl=0

 

[Mega1]

that's perfect thanks for your help

 

[Aladin Akyurek]

that's perfect thanks for your help

You are welcome.