Please help!

[Damil4real]

I have data in columns A, B, C, D, and E.

Sample

A B C D E
1 2 3 4 1245
2 5 4 1 4156
1 4 8 0
M1 D5 D-F 1 2154
1 2 3 4 1245
2 5 4 1
1 4 8 0
M1 D5 D-F 1 2154

I want a VBA macro to run searching column E and a message box should
pop up at the end of the macro saying something like: "There are 5
(the number of found data that are not blank) values associated with
your list. The five values are 1245 located in row E2, 4156 located in
row E3, 2154 located in cell E5, and 1245 located in cell E8."

Thanks!

 

[Don Guillett]

Doable but can't you just use data>autofilter>filter non blanks