Jonmo1
MrExcel MVP
- Joined
- Oct 12, 2006
- Messages
- 44,061
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.
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.