VBA to combine data from two different tables into a result table

Dear all,

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:

stores.jpg

The table containing the targets:

targets.jpg

And the table Results combining targets and stores:

results.jpg

I also enclosed the example file

database.xlsm

I hope I was able to explain in a way that you will understand.

Thank you in advance,

Kind regards,

Laurel

Hi,

It seems that is quite difficult what I´m trying to do right?

KR

Laurel

Dear sktneer,

thank you so much, I was thinking that I was thinking in something quite impossible to be achieved.

Thank you very much,

I wish you a great day,

kind regards,

Laurel

Dear Sktneer,

Thank you for your reply, I know that was not an easy task, therefore thank you very much for your help

I hope I´m not pushing it, but I just realized that my targets might change per customer, how can I had this check in the code?

I´m adding some screenshots below:

in the stores there is the contract_number:

stores_1.jpg

and in the targets will have the target number as well:

targts1.jpg

I was trying to add the code in this part :

Please Login or Register  to view this content.

Thank you so much in advance,

Regards,

Laurel