Hi team,
I want to give you a little background about my question/problem.
In the following Master Table ONLY data under Column “In App (Y/N)” with the value of Y will be processed by the bot. After that, we have two Business Units aka BU 1 and 3 as you can see under the “Business Unit” column.
The mail purpose is copying article number and other corresponding values (in blue columns) from the Master File Sheet and pasting them into the respective sheet (template). For example, if Business Unit 1 has data for each row, the Bot has to see which columns have data in them. If the “Bilo, (KLM Product)” column has data, the Bot has to go to the “KLM Product Template” sheet (template). If the same article number has data in multiple columns (“Bilo, (KLM Product)”, “Launch Date, KLM add data (41)” and so forth), the bot has to go to each template and populate the data. The same steps are followed if the data is from Business Unit 3.
Therefore, I’d like to envision how the design would look like. Can anyone help with this? Please let me know if you’d need more information.
Here’s the sample of one of the templates we anticipate copying to
Thanks a lot for your help.