Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire row as a result. I would use this to build individual supplier sheets for review while allowing our production staff to only have to monitor/edit one sheet.
Comments
-
-
I have glossed over it; however, can you use one report to seed information into several different sheets dependent upon a singular answer? IE If(Supplier = x) put information on X sheet but if(Supplier = y) put information on Y sheet? If not then I am stuck with the same problem as before.
-
You can reference entire workspaces and folders within a report. Assuming the layout of all of the sheets is that same, it will essentially create a "Master". When a cell is updated in a report and the report is saved, it will then automatically update the corresponding sheet that the row was pulled from.
-
I will learn more about them over the rest of the week and see if I can make it work for my needs.
-
Thank you Paul!
After looking through the reports section it does exactly what I need, by searching a specific column for an exact text string I can then build the report to not only pick and choose the columns I want to show, but also what order I want them in. This will of course allow me to format anything into the correct format for a Dashboard no matter how i make the initial sheet! This way i can exclude proprietary information and only share the need to know information with our suppliers, and by keeping it out of a work space I can set up several suppliers from the same sheet.
Many thanks,
Mike
-
