Hi folks I have a worksheet that contains previous lottery draw details & want to make a search page to display the numbers drawn.

Sheet1
Col a the date
col b-g lottery numbers drawn
col h bonus ball

in worksheet2 i have made a vba list box that links to col a in sheet1 but i need the values of col b-g to be displayed
in worksheet2 based on the date chosen from the listbox

Hope this makes sense , any help/advice would be greatly apreciated

Thanks