Data sort/lookup issues

[JamesMc]

Hello All,

Sorry if this is a stupid question, I'm Fairly new to using Excel and having a bit of an issue with what I am hoping to achieve with a report I'm Creating.

I have included a bit of the data below to hopefully help illustrate what I'm working with.

I have a master file tab in Excel where data will be input about various Customer orders. what I am hoping to do, is be able to have this data "copied" into other tabs in the excel report depending on what code they fall into.

for example any jobs that come under RO1 or RO2, will be auto populated in the Rev Jobs tab. Anything under CO1 or CO2 will auto populate in the Contracts tab etc.

I hope this makes sense, and that somebody out there will be able to help with what kind of formula I would need to use to achieve this.

thanks
James.

Date	Company	Job Number	Cost	Charge	Gross Profit	Code
03/01/2018	Customer Details	637598	£201.61	£300.95	33%	RO1
03/01/2018	Customer Details	637538	£120.14	£316.55	62%	RO1
03/01/2018	Customer Details	636811	£1,125.71	£480.26	-134%	CO1
03/01/2018	Customer Details	633822	£1,162.20	£0.00	0%	CO2
03/01/2018	Customer Details	637200	£822.02	£105.00	-683%	CO2
04/01/2018	Customer Details	637306	£753.57	£862.61	13%	RO1
04/01/2018	Customer Details	637420	£121.16	£58.75	-106%	RO1
04/01/2018	Customer Details	636816	£487.63	£0.00	0%	CO1
05/01/2018	Customer Details	637903	£38.54	£0.00	0%	RO2

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>

 

[SteveO59L]

you could just refer to the master sheet in the other tabs, and use a filter

 

[JamesMc]

thanks for that! got it working perfectly with your advise.