Excel Automation
Budget: €30 – €250 EUR
Hi,I have two excel sheets in one doc. One is with customer information (name, last name, date of birth, etc) and a code called Leistungsort. The code tells me in which store they went shopping. In the second excel sheet there is the adress of the shops including the bsnr. I need a couple of things.
1.) The adresses of the shops have to automatically be integrated into the sheets with the customers. Columne of the code (Leistungsort is the same in both excel sheets, so with that matching would be possible)
2.) After that i need a word letter with a standardized thext includeing all the customers from one shop. i need one word doc for each shop with the name of all customers. Please see the examples attached.
This tasks need to be repeated every 2-3 month so i need a tool that i can use a couple of times.
1.) The adresses of the shops have to automatically be integrated into the sheets with the customers. Columne of the code (Leistungsort is the same in both excel sheets, so with that matching would be possible)
2.) After that i need a word letter with a standardized thext includeing all the customers from one shop. i need one word doc for each shop with the name of all customers. Please see the examples attached.
This tasks need to be repeated every 2-3 month so i need a tool that i can use a couple of times.