Hi Folks,
I am attempting to create an automated data grab type formula which I will then use to set up an automatic email macro.
What I'm looking to do is have a formula which looks through the table (table 2), finds any dates that are more than 2.5 years old (some sort of a if/find function using today()-912 I would presume) then locates the corresponding training course title in row two, and name in column C&D (it may be easier to concatenate these into one? Not sure.). Then copy this data into a table in another sheet (outstanding training) with said mined data.
So it would look at this:
and regurgitate this:
Has anyone done anything like this before? I'm afraid this is beyond the realms of my understanding...so any help appreciated!
Thanks all
I am attempting to create an automated data grab type formula which I will then use to set up an automatic email macro.
What I'm looking to do is have a formula which looks through the table (table 2), finds any dates that are more than 2.5 years old (some sort of a if/find function using today()-912 I would presume) then locates the corresponding training course title in row two, and name in column C&D (it may be easier to concatenate these into one? Not sure.). Then copy this data into a table in another sheet (outstanding training) with said mined data.
So it would look at this:
and regurgitate this:
Has anyone done anything like this before? I'm afraid this is beyond the realms of my understanding...so any help appreciated!
Thanks all