With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, November 30, 2016
yogi_From 'Master Sheet' Pull Select Columns For Specials By Day Of Week And Lunch
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.