pbsmith82
New member
- Joined
- May 27, 2016
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I am having trouble setting some automation. It works best if I explain I have three types of "Products" these products can be purchased Separately or as a collection. The can be "Completed" at different times. I collect the data as separate projects, but need to see them as a collection also ........ With that said Here is what I am trying to do.
If Collection is a Yes, I want Product A's , from Collection A, Active date Pasted to Cell X
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Y
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Z
See Image Below ....
If Collection is a Yes, I want Product A's , from Collection A, Active date Pasted to Cell X
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Y
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Z
See Image Below ....