VBA code to find last entry on a certain date and bring back the text in the adjacent

[alansidman]

Do you have a sheet named Summary in your workbook? If not, then replace "Summary" with the name of your summary sheet as described in your first post to this thread. In your first thread you indicated you wanted the results in a Summary Sheet, but you did not have one in your test file. I created one and called it Summary. Whatever yours is called needs to be put in this line of code.

[pedros23]

Do you have a sheet named Summary in your workbook? If not, then replace "Summary" with the name of your summary sheet as described in your first post to this thread. In your first thread you indicated you wanted the results in a Summary Sheet, but you did not have one in your test file. I created one and called it Summary. Whatever yours is called needs to be put in this line of code.

Thanks Alan,

I had a feeling I had missed something simple. You're help has been fantastic.

I just need to figure out how to make it find the next previous date and i will save me so much time.