Forum Discussion
Value from Cell to Autofill Email
Hi, I'm going to start by saying I'm a total noob on excel so apologies if this is a dumb question. Basically I'm trying to make a tool where you fill in a form, click a button and the data from...
Let's say you have dates in B4:B50, and you enter a date in B2.
The code could then search for that date in B4:B50 and look up the value in column D in the row where the date is found.
What I would like is for when a date is entered into, for example, cell B10 ("work order completed"), to then send an auto email which includes the data from cell D10 ("work order number"). And then any time a date is entered into column B, the email would contain the corresponding information from column D in that same row. Would this do that?