I need a macro that will look for the word Rent in column C, from the bottom up, and when it finds it will display the value in column E of the same row in a message box.
So if I had rent in C25 and rent in C36 it would show the value for cell E36 in the message box.
This is for Excel 2003
Thanks
So if I had rent in C25 and rent in C36 it would show the value for cell E36 in the message box.
This is for Excel 2003
Thanks