I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine.
I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I don't need all of the columns, but if there is nothing else, I can just hide the unwanted columns.
I have tried using INDEX/MATCH and VLOOKUP, but it only returns the first (or last depending on Match Type)… It does not populate all matching rows even though the formula is set to column formula.
