Please tell me if I'm asking a question previously answered, I did not find it.
---Images---
==================
---/Images---
I want to use a List Box in which I click a location to have another box display what is in the corresponding location.
I use location meaning location B2 ([73]SLGpaladin) will be a container whereas the contents of B2
(displayed in the second box or cell) are "C2, D2, ..., ZZ2". (and the contents of B3 are "C3, D3, ..., ZZ3")
My output cell for the List Box selection's column value on sheet2 is cellM44 on sheet1.
Sheet1 has the List Box and Sheet2 has the data.
Are you able to tell me how to do this, or redirect me to another topic that does?
If it cannot be done as a whole, I'd appreciate a run-through of how do do a cell-by-cell equivalent of this.
Thank you for reading my question.
---Images---
==================
---/Images---
I want to use a List Box in which I click a location to have another box display what is in the corresponding location.
I use location meaning location B2 ([73]SLGpaladin) will be a container whereas the contents of B2
(displayed in the second box or cell) are "C2, D2, ..., ZZ2". (and the contents of B3 are "C3, D3, ..., ZZ3")
My output cell for the List Box selection's column value on sheet2 is cellM44 on sheet1.
Sheet1 has the List Box and Sheet2 has the data.
Are you able to tell me how to do this, or redirect me to another topic that does?
If it cannot be done as a whole, I'd appreciate a run-through of how do do a cell-by-cell equivalent of this.
Thank you for reading my question.