Finding values entered in a column TODAY by the same user

• I have column A fully populated with values
• I have a macro that when clicked, opens outlook express and sends an email to a vertical head with the latest entry # in column A.
• No issues at all. Works fine. But I want to upgrade it
• Is there a way to find out the values populated by a given user, in a particular day, in this case, today ?

For eg:

• If XYZ populated, Range A7,A8 and A9 yesterday.
• Today, ABC populated Range 10,11 , 12 and 13:
• Then the code today, should send an email to the vertical head saying , Range10,11,12 and 13 were updated today.

My code uses the following :

For finding last value in row :

Please Login or Register  to view this content.

Code that sends the mail

Please Login or Register  to view this content.

I am assuming that your data starts from row 2.

use this code to get the range that was updated today.

Please Login or Register  to view this content.

this code will go below this

Please Login or Register  to view this content.

and this line

Please Login or Register  to view this content.

will change to

Please Login or Register  to view this content.

It says VARIABLE NOT DEFINED, pointing at 'x'

Would I have to add,

Please Login or Register  to view this content.

Its not needed,

try adding this code.

Please Login or Register  to view this content.

oops,it should be updated_Range not update_range. that was a typo

at which line is this error occurring ?

if you can post your updated code.

I can simulate the issue.

On which line did you get the error ?

This code went through without any issues.

I am assuming that column "A" is a date field, if not which column has the date values to be compared to current date ?

Oopss.. My bad.. it was column B. Column A was full of request ID # (all integers)


Having said that, just an addition to my initial query.

In the subject it populates the dates... That is not wat should go there. The request ID is what has to go there...

So how to choose the request IDs (from column A) that were filled today.

Would it be

Please Login or Register  to view this content.

Ok,

your date values are in column B and we need to extract the content in column a for rows that were updated today.

So change this code :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You are welcome, glad that we got it solved.

Can you please explain what this line in the code does?

Please Login or Register  to view this content.

I mean, I am looking for a way if I could declare and get corresponding values from column L as well ?

We are using a string variable named updated_range to store the values in the column A in the row X .

Before this you have a if condition that checks that the date in row x of column "B" is equal to current date.
So only on satisfying this condition the updated_Range string gets appended with the value in column "A".

This happens till the last row is reached.

At the end we have all your ID's in the string variable updated_range.

Current you have this code for the Request ID to be collected

Please Login or Register  to view this content.

To also get the due date from the column L replace the above code with this.

Please Login or Register  to view this content.