Jonathan Jones
New Member
- Joined
- Jul 30, 2017
- Messages
- 18
Hi,
I've got a spreadsheet of product data. The data is product part number, description, supplier name and various other product attributes such as lead time, cost, supplier contact and email address, etc.
There's some gaps in the data, e.g. I don't have lead time for all products. I would like to send the list of products to each supplier for them to complete the missing information. Obviously I only want each supplier to see the products which they supply.
The data isn't very clean so I don't want to do this all as one process. Ideally, I'd like some code which creates a new excel file called the supplier name which contains all the products from that supplier, I can then check the data and email the supplier requesting the information.
Any help would be much appreciated - Thanks.
Jonathan
I've got a spreadsheet of product data. The data is product part number, description, supplier name and various other product attributes such as lead time, cost, supplier contact and email address, etc.
There's some gaps in the data, e.g. I don't have lead time for all products. I would like to send the list of products to each supplier for them to complete the missing information. Obviously I only want each supplier to see the products which they supply.
The data isn't very clean so I don't want to do this all as one process. Ideally, I'd like some code which creates a new excel file called the supplier name which contains all the products from that supplier, I can then check the data and email the supplier requesting the information.
Any help would be much appreciated - Thanks.
Jonathan
