I am lost... I know what I want this formula to do. But I can not make it work. I have tried vlookups, if then, match and so on to no avail.
I need to check data from one colomn and if it is equal to something then copy the entire row and place it onto another tab. So if I add something to the main tab, it will automatically add it to the new tab.
Example... On Master tab: If data in column C is equal to 1, then copy all data in that row to tab team 1. repeat for all items marked 1.
Equal to 2, then copy row to team 2. Repeat for all items marked 2. And so on.
I appreciate anyones help in advance.