Lookup for one value and then copy the whole role.

[JDJong]

Hi everyone,

there is a large amount of orders I receive everyday which Needed to be recorded into the master file, in contains of different category of course types.

Is there a way that could look up the regular courses and copy the whole row down, and whenever new courses are registered, the formula can automatically copy down so that i could have an overview of the Status of the monthly order.

Please any assistance is greatly appreciated.
Sheet 1 is master file and sheet 2 is the result i would like to have:

Sheet 2
Type	Course No.	Subject	Cost
regular	4901	Math	9800
regular	4902	Math	8510
regular	20181011	Math	7220
regular	20181015	Math	5930
regular	1475856	Science	4640
regular	5565201	Science	3350
regular	985859	Science	2060
regular	6521	Science	770
regular	9852	Science	520
regular	8522	Literature	651
regular	20181012	IT	5930
regular	20181013	Review	4640
regular	20181014	Science	3350
regular	20181015	Science	9800
regular	20181016	Science	8510
regular	20181017	Science	7220
regular	20181018	Science	7220
regular	985	Science	3350
regular	552	Science	16000

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

Type	Course No.	Contact person	Subject	Cost
regular	4901		Math	9800
regular	4902		Math	8510
regular	20181011		Math	7220
regular	20181015		Math	5930
regular	1475856		Science	4640
regular	5565201		Science	3350
regular	985859		Science	2060
regular	6521		Science	770
regular	9852		Science	520
regular	8522		Literature	651
regular	20181012		IT	5930
regular	20181013		Review	4640
regular	20181014		Science	3350
regular	20181015		Science	9800
regular	20181016		Science	8510
regular	20181017		Science	7220
regular	20181018		Science	7220
other	562		PE	5930
other	956		ART	4640
regular	985		Science	3350
regular	552		Science	16000

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

 

[AlanY]

you know that can be achieved easily by putting a filter in the top row of the master file

 

[JDJong]

Yes that's true Alan, in a latter column G
there are 58 cost Centers
and i would like to make an overview of each Center.

perhaps you have an idea of how it would work ?

Thank you

 

[JDJong]

And if I filter the regular ones and in sheet 2 row B2 =sheet1!B2 copy down, all the entries of the other courses are also copied down.

I think it Needs to be excluded the other's first?