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.

[TABLE="width: 665"]
<tbody>[TR]
[TD]Date [/TD]
[TD]Company[/TD]
[TD]Job Number[/TD]
[TD]Cost[/TD]
[TD]Charge[/TD]
[TD]Gross Profit[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637598[/TD]
[TD]£201.61[/TD]
[TD]£300.95[/TD]
[TD]33%[/TD]
[TD]RO1[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637538[/TD]
[TD]£120.14[/TD]
[TD]£316.55[/TD]
[TD]62%[/TD]
[TD]RO1[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]636811[/TD]
[TD]£1,125.71[/TD]
[TD]£480.26[/TD]
[TD]-134%[/TD]
[TD]CO1[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]633822[/TD]
[TD]£1,162.20[/TD]
[TD]£0.00[/TD]
[TD]0%[/TD]
[TD]CO2[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637200[/TD]
[TD]£822.02[/TD]
[TD]£105.00[/TD]
[TD]-683%[/TD]
[TD]CO2[/TD]
[/TR]
[TR]
[TD]04/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637306[/TD]
[TD]£753.57[/TD]
[TD]£862.61[/TD]
[TD]13%[/TD]
[TD]RO1[/TD]
[/TR]
[TR]
[TD]04/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637420[/TD]
[TD]£121.16[/TD]
[TD]£58.75[/TD]
[TD]-106%[/TD]
[TD]RO1[/TD]
[/TR]
[TR]
[TD]04/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]636816[/TD]
[TD]£487.63[/TD]
[TD]£0.00[/TD]
[TD]0%[/TD]
[TD]CO1[/TD]
[/TR]
[TR]
[TD]05/01/2018[/TD]
[TD]Customer Details[/TD]
[TD]637903[/TD]
[TD]£38.54[/TD]
[TD]£0.00[/TD]
[TD]0%[/TD]
[TD]RO2[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]

 

[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.