Need to be able to send emails to individuals daily based on cell value. Need to be able to then parse the required data sent in the return email back into the excel cell. Working to avoid too much copying and pasting and automating this process. At the end of each day the excel sheet needs to save into a separate table and be cleared back to zero. We are trying to better forecast daily revenues and how much money we need to transfer into our main account. We need to automatically message our agencies each day at the same time, have them respond and the data populate into excel. I know how to send emails from excel but don't know how to code to parse data and to clear the excel sheet each day.