Hi, I am attempting to set up a data log that will send out an email with the data that was entered in the cells within the last 5 days. I can get it to send an email out with a set range of values, but I am having trouble modifying that range to include entries from the previous 5 days. The dates that the data is entered is in column A. Please let me know if you have any questions or need any clarification. Thank you! Here is the code I currently have:
Last edited by sandlinj; 08-20-2018 at 08:04 PM.
Welcome to the Forum sandlinj !
It would be much more helpful to attach your actual Excel file. That way we could actually test a suggestion before we post it. With just the code we don't know what your data looks like.
I have now attached the file. I am very new to this so my code is all over the place...
Thanks for the welcome Jeff!
This assumes that your data is sorted strictly by ascending date, as in your example. I tested it with your data but it will need further dates with more expanded date ranges.
I will add some more data and reupload. As the data is entered, it automatically pulls the date of the entry and puts it in column A so the data should always be sorted by ascending date.
I have now included more than 7 days worth of data
I guess I wasn't direct enough.
I provided a solution for free. You should test it with more data to be confident it does what you want.
Thank you so much Jeff! With my initial tests it looks like it is doing what I want!!!
Good to hear--stop back again if you find any problems.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks