Compiling data across tabs.

%3CLINGO-SUB%20id%3D%22lingo-sub-3112055%22%20slang%3D%22en-US%22%3ECompiling%20data%20across%20tabs.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3112055%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20document%20with%20columns%20ranging%20from%20A-K.%20each%20column%20has%20very%20different%20information%20specific%20to%20identifying%20an%20object%2C%20except%20the%20F%20column.%20This%20column%20Identifies%20the%20location%20of%20said%20object%20in%20the%20row%20with%20a%206%20digit%20code.%20There%20are%20many%20different%20codes%20which%20create%20a%20long%20list.%20I%20want%20to%20set%20up%20groups%20based%20on%20the%20information%20in%20the%20column%20of%20location%20codes%20to%20automatically%20pull%20to%20separate%20tabs%20in%20my%20document.%3C%2FP%3E%3CP%3EBasically%2C%20if%20F%20column%20on%20Tab%20A%20equals%20h99999%2C%20h99998%2C%20and%20h99997%2C%20then%20fill%20A-K%20row%20of%20Tab%20B%20with%20A-K%20from%20Tab%20A.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20this%20is%20a%20newbie%20question%2C%20but%20is%20this%20possible%3F%20and%20if%20so%2C%20what%20formula%20what%20I%20need%20to%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3112055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3112093%22%20slang%3D%22en-US%22%3ERe%3A%20Compiling%20data%20across%20tabs.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3112093%22%20slang%3D%22en-US%22%3EWhy%3F%20it%20hardly%20ever%20is%20a%20good%20idea%20to%20spread%20similar%20date%20over%20multiple%20worksheets.%20Why%20not%20use%20filtering%20instead%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3112128%22%20slang%3D%22en-US%22%3ERe%3A%20Compiling%20data%20across%20tabs.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3112128%22%20slang%3D%22en-US%22%3EThis%20is%20a%20weekly%20negative%20report.%20The%20first%20tab%20shows%20everything%20wrong%20within%20an%20organization%20and%20each%20tab%20afterward%20shows%20a%20breakdown%20on%20where%20the%20problem%20is%20located.%3CBR%20%2F%3EThe%20panel%20that%20receives%20this%20report%20only%20wants%20to%20go%20through%20the%20tabs%20and%20see%20who%20is%20at%20fault.%3C%2FLINGO-BODY%3E
New Contributor

I have an excel document with columns ranging from A-K. each column has very different information specific to identifying an object, except the F column. This column Identifies the location of said object in the row with a 6 digit code. There are many different codes which create a long list. I want to set up groups based on the information in the column of location codes to automatically pull to separate tabs in my document.

Basically, if F column on Tab A equals h99999, h99998, and h99997, then fill A-K row of Tab B with A-K from Tab A. 

I'm sure this is a newbie question, but is this possible? and if so, what formula what I need to do this? 

4 Replies
Why? it hardly ever is a good idea to spread similar date over multiple worksheets. Why not use filtering instead?
This is a weekly negative report. The first tab shows everything wrong within an organization and each tab afterward shows a breakdown on where the problem is located.
The panel that receives this report only wants to go through the tabs and see who is at fault.
Well, this was a waste of time.
Please be aware that the people responding here are doing so voluntarily. I lacked the time for a more elaborate response I'm afraid.