Needing a formula to import a range of cells based on criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-1626213%22%20slang%3D%22en-US%22%3ENeeding%20a%20formula%20to%20import%20a%20range%20of%20cells%20based%20on%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626213%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20am%20trying%20to%20import%20a%20range%20of%20cells%20from%20one%20sheet%20to%20another%20(same%20workbook)%2C%20similar%20to%20the%20Query%20function%20in%20Google%20sheets.%20In%20one%20tab%2C%20Roster%2C%20I%20put%20names%2C%20and%20In%2FOut%20times%20for%20my%20employees%20for%20a%20daily%20schedule.%20I%20categorize%20them%20by%20in%2Fout%2C%20Position%20(BOH%2C%20FOH)%2C%20OPen%2C%20Mid%2C%20Close%20(shifts).%20I%20put%20all%20that%20into%20the%20Roster%20based%20on%20the%20Day%20of%20week.%20Then%20on%20the%20other%20tabs%20called%20Day%201%2C%20Day%202%2C%20etc.%20I%20have%20sections%20where%20those%20on%20Roster%20corresponding%20to%20Open%20shift%20(C33)%2C%20names%20and%20times%20are%20placed%3B%20those%20corresponding%20to%20Mid%20(L33)%2C%20and%20Close%20are%20placed.%20I%20need%20a%20formula%20to%20import%20the%20data%20from%20Roster.%20But%20it%20is%20filtered%20by%20Open%2C%20Mid%2C%20Close.%20I%20built%20this%20sheet%20in%20Google%20sheets%20and%20Query%20worked%20so%20well.%20I've%20moved%20over%20to%20Excel%2C%20and%20struggling%20to%20do%20this.%20Any%20help%20you%20can%20offer%20will%20be%20a%20life-saver.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1626213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello. I am trying to import a range of cells from one sheet to another (same workbook), similar to the Query function in Google sheets. In one tab, Roster, I put names, and In/Out times for my employees for a daily schedule. I categorize them by in/out, Position (BOH, FOH), OPen, Mid, Close (shifts). I put all that into the Roster based on the Day of week. Then on the other tabs called Day 1, Day 2, etc. I have sections where those on Roster corresponding to Open shift (C33), names and times are placed; those corresponding to Mid (L33), and Close are placed. I need a formula to import the data from Roster. But it is filtered by Open, Mid, Close. I built this sheet in Google sheets and Query worked so well. I've moved over to Excel, and struggling to do this. Any help you can offer will be a life-saver. Thank you.

0 Replies