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
sheet 1
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
Bookmarks