I need help on this,
I have a specific case where my customer has around 300 stores, but each of these 300 stores act as unique customer. when the contract is closed and there are some conditional targets I have to replicate those targets for all the 300 stores. this is a hard manual process and I would like to automate it a bit with some VBA, but unfortunately my vba skills are not that good.
here is the challenge:
I have 3 tables (Stores, Targets and Results), the table "stores" contains all the stores of a specific customer, the table targets contains the targets that should be replicated for all the stores.
this information should be collected in one table having each store with the respective number of targets. see images below:
The table containing the Stores:
The table containing the targets:
And the table Results combining targets and stores:
I also enclosed the example file
I hope I was able to explain in a way that you will understand.
Thank you in advance,