Good day to you, my dear friends.
I've been cracking at this for a little while now, working on a complex excel tree with a bunch of different tasks.
The basic idea is to make a set of excels starting with an “input/macro trigger”(aka "email sender") excel, that sends emails from "mailbots" based on input in the “email sender” file (mailbots are for different recipients and exact ones are selected from the input file((so some "mailbots” won’t have to be used))). After the macro trigger, inputted data will copy to a separate sheet with a general table for the selected user that will later become a part of the main table("database") with all information from all users. The data can be updated every day or every time the e-mail macro is activated.
Also I'm sure this has been done part by part in some sort of way, so I'm working with forum archives to claw out some tips and will be posting updates as I go, but if anyone has experience with problems so complex, any help would be appreciated.
Thank you in advance.
Posted all 3 excels in attachment for more details:
Bookmarks