yogi_From 'Master Sheet' Pull Select Columns For Specials By Day Of Week And Lunch

Google Spreadsheet   Post  #2088

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-30-2016

question by: Josh Crofts:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/5nfKVHg21pA;context-place=forum/docs

Need to pull data from one sheet into another but also filter it

 Hi,
I am new to the world of spread sheets and am trying to setup some sheets to auto fill off the main sheet.

What I have done is created a master sheet with different categories (venue, address, phone number, day of special etc.)

I would like to be able to pull out the data for each given day onto a new sheet.
This would have Venue, suburb & specials for the given day on each particular sheet.

Some venues do not contain specials for every day of the week so when they are pulled into the monday sheet I have many venues listed with  blank spcials.

I would just like to pull across the relevant venues that have data located in the monday specials column on the master sheet so that when I am on the Monday sheet only venues with specials on Monday are listed.

Here is the required link,

https://docs.google.com/spreadsheets/d/1UY-x739uS6QSyHpOdWRCyYLr-VbTDgRRhGbOqYEi4hY/edit?usp=sharing

Hopefully that makes sense

Thanks,