paun_shotts
New Member
- Joined
- Nov 4, 2021
- Messages
- 38
- Office Version
- 2013
- Platform
- Windows
Hi,
I have a list of products on order with a supplier, the list is updated as new orders are placed with the supplier, this list will always have duplicate values as we order the same products on a weekly basis.
I want to create a summary list, and I want this list to have no duplicates in it. I want this list of unique values, created off the other list where all the duplicate values are. And would like the summary list to update automatically if a new product is ordered and added to the main list of products on order, so the new product will then show on the summary list as well.
At the moment, If I order a new product, not ordered before, I am adding that product code manually to the summary list.
Is this possible? Please help me.
I have a list of products on order with a supplier, the list is updated as new orders are placed with the supplier, this list will always have duplicate values as we order the same products on a weekly basis.
I want to create a summary list, and I want this list to have no duplicates in it. I want this list of unique values, created off the other list where all the duplicate values are. And would like the summary list to update automatically if a new product is ordered and added to the main list of products on order, so the new product will then show on the summary list as well.
At the moment, If I order a new product, not ordered before, I am adding that product code manually to the summary list.
Is this possible? Please help me.