Hello all,
I was hoping someone might be able to help me with a project I'm working on. I tried looking for old threads I've posted regarding this, because I did figure out the code at some point, however, it's been a while since I've used the file and can no longer find it. I'm trying to create code to filter my data off of a specific value, such as Region. After filtering on Region, then filter on status, such as Open. Once that has been done, copy the filtered data on to a different workbook, and save it using a naming template that will enter in the date and Region the file pertains to. I would eventually like to create an automatic email that will grab the Regional Manager's email address and create a generic email that can be sent out to all of the Regional Managers for each specific Region. I really wish I could find the old code I wrote, because that would make this a lot easier. Any help is greatly appreciated.
D.
I was hoping someone might be able to help me with a project I'm working on. I tried looking for old threads I've posted regarding this, because I did figure out the code at some point, however, it's been a while since I've used the file and can no longer find it. I'm trying to create code to filter my data off of a specific value, such as Region. After filtering on Region, then filter on status, such as Open. Once that has been done, copy the filtered data on to a different workbook, and save it using a naming template that will enter in the date and Region the file pertains to. I would eventually like to create an automatic email that will grab the Regional Manager's email address and create a generic email that can be sent out to all of the Regional Managers for each specific Region. I really wish I could find the old code I wrote, because that would make this a lot easier. Any help is greatly appreciated.
D.