Excelnoub
Member
Good day,
I have a listbox on my sheet that grabs the information from another sheet. I need, when I click a selection, to populate the information based on the range value from this other sheet and not the single selection. I mean I could do it by doing my Listbox a multiple view but that cannot be the case.
My Range from the other sheet(Sheet2) has data from A2 to C20 but I only need A2 & LastRow in my ListBox.List.
I need that when I select a selection from the listbox that it will add to my Sheet1("E3" as example) the information selected and the ActiveCell.Row info from column B and C from my Sheet2.
I guess kind of a Vlookup method.
I have a listbox on my sheet that grabs the information from another sheet. I need, when I click a selection, to populate the information based on the range value from this other sheet and not the single selection. I mean I could do it by doing my Listbox a multiple view but that cannot be the case.
My Range from the other sheet(Sheet2) has data from A2 to C20 but I only need A2 & LastRow in my ListBox.List.
I need that when I select a selection from the listbox that it will add to my Sheet1("E3" as example) the information selected and the ActiveCell.Row info from column B and C from my Sheet2.
I guess kind of a Vlookup method.