Display non blank cell furthest to the right

[Jonmo1]

Ok, you guys were great on my first post, here's question # 2.

I have a row where users enter data from left to right at various times. Sometimes every day, sometimes not for several days. So one day they enter data in collumn A, maybe next day collumn 2, then maybe not for a weel they enter in collumn 3 and so on. They will always use the next available cell to the right. UP to 8 collumns. How can I make another Cell on another sheet display only the non-blank cell furthest to the right in a specified range of cells?


Thanks again.

 

[barry houdini]

Somebody else just asked that question..... see here

http://www.mrexcel.com/board2/viewtopic.php?p=1147052#1147052

 

[Jonmo1]

Never mind, looks like my question was already answered by barry houdini in a post by geversud.

Thanks