List Last nonblank cell in comment box or popup

[Endorphin]

Hi All,

After some fantastic help from GTO yesterday I am after abit more.
The attached spreadsheet as you can see will contain voltages and dates. What I am trying to do this time is to list the newest voltage & dates for each ID in a comments box or some other sort of popup window and list all IDs that contain no voltage/Date in another popup window.
Again, any help appreciated.

VBA is French to my English, Enough to get a coffee but no idea how to ask what pi to six decimal places is.

Neil

[Endorphin]

Ok, found a code to find the last empty cell and put it in the last column of the sheet. Just after some code now to copy Columns YXZ to a comment but filter out everything that is NOT blank

=AVERAGE(IF((K9:AB9<>"")*(MOD(COLUMN(K9:AB9),2)=1),K9:AB9))