Greetings,
I have a list named "Fruit_List" which has 4 values (Orange, Grape, Apple, Pear). I have placed these values in a list box, but am having trouble calling the related information into a new worksheet, which the user would input additional values and submit in entirety on a 3rd tracking sheet.
Any tips on where to start? Would it be a listbox into another listbox? How do I get VBA code to pull and push the info onto the respective sheets?
Example
Orange
<user listbox
O1 - These3 values populate row 1 of a sheet
O2 ______ ______ -The user enters values into cells
<user in="" values
O3 ______ ______
-A "submit" button logs all of the above into a logging worksheet in the same book, under the Orange and O1 O2 O3 headers
Can someone please point me in the right direction on how to best achieve this?
Thank You!</user></user>
I have a list named "Fruit_List" which has 4 values (Orange, Grape, Apple, Pear). I have placed these values in a list box, but am having trouble calling the related information into a new worksheet, which the user would input additional values and submit in entirety on a 3rd tracking sheet.
Any tips on where to start? Would it be a listbox into another listbox? How do I get VBA code to pull and push the info onto the respective sheets?
Example
Orange
<user listbox
O1 - These3 values populate row 1 of a sheet
O2 ______ ______ -The user enters values into cells
<user in="" values
O3 ______ ______
-A "submit" button logs all of the above into a logging worksheet in the same book, under the Orange and O1 O2 O3 headers
Can someone please point me in the right direction on how to best achieve this?
Thank You!</user></user>