I have master list of names and whether they ordered 1 of 3 products (Year, Half, Short). Then I have 3 tabs to the right for each of thee 3 products. I want to be able to create an if function for each of these 3 tabs which will formulate the appropriate names. For example, If John Doe ordered the yearly product, I want his name to be able to show up in the first cell of the year tab. Then, if the second person to order on the master list ordered for short-term, I want their name to populate on the first row of the short-term tab. Does this make sense? If so, is this possible?
Bookmarks