sgr
04-21-2010, 09:59 PM
Hi - I am new to VBA and have worked my way to this stopping point. I've tried searching but can't seem to find what I need.
In Excel 2003, I have a worksheet that is made up of 14 rows and 16 columns. Everything is ordered in rows. So, the first column in a row is the item's name and the subsequent columns, in that row, are characteristics of that item. The second row is the second item and so on.
A user populates this worksheet (so the names of the items change from user to user as do the items characteristics) and then clicks on a command button to bring up two list boxes and some more command buttons. The first list box is populated with the names and the user can select which names to move into the second listbox.
I would like to be able to export the name and its associated characteristics (the whole row) into another worksheet based on what's in that second listbox. I can't seem to figure this last piece out. Any help or pointing in the right direction would make my head stop hurting. Thanks.
In Excel 2003, I have a worksheet that is made up of 14 rows and 16 columns. Everything is ordered in rows. So, the first column in a row is the item's name and the subsequent columns, in that row, are characteristics of that item. The second row is the second item and so on.
A user populates this worksheet (so the names of the items change from user to user as do the items characteristics) and then clicks on a command button to bring up two list boxes and some more command buttons. The first list box is populated with the names and the user can select which names to move into the second listbox.
I would like to be able to export the name and its associated characteristics (the whole row) into another worksheet based on what's in that second listbox. I can't seem to figure this last piece out. Any help or pointing in the right direction would make my head stop hurting. Thanks.