Hello,
I unfortunately am a beginner in vba coding, so I asking for help here
My issue: I have a "master file" daily orders for all shops of one of my customer, and I have then to send a order file to each of my supplier based on this. What I would like to do: to have a vba that will automatically create the order file for each supplier, (taking info from the "master" file to the "template" and saving the template as 'SupplierName_CustomerName_date" in a specific file (let's say "C:\Users\Documents\Month\Date"
I hope it is understanable i enclosed an example of "master file" and "template" order
I unfortunately am a beginner in vba coding, so I asking for help here
My issue: I have a "master file" daily orders for all shops of one of my customer, and I have then to send a order file to each of my supplier based on this. What I would like to do: to have a vba that will automatically create the order file for each supplier, (taking info from the "master" file to the "template" and saving the template as 'SupplierName_CustomerName_date" in a specific file (let's say "C:\Users\Documents\Month\Date"
I hope it is understanable
i enclosed an example of "master file" and "template" order