Hello,
Lets say i have a combobox on 'Sheet1'!B2
which lists the values in range 'Sheet2'A1:
'Sheet2'!A50.
Sheet 2 looks someting like this<table><tr><td>Name</td><td>Company</td><td>Number</td><td>Account</td></tr><tr><td>Fred</td><td>fredscomp</td><td>12345</td><td>128</td></tr></table>
the user can select the combobox on sheet1. In this case this would be fred.
Now comes the question:
How can i make excel (when fred is selected) to copy the cells 'Sheet2'!A2:'Sheet2'!D2
to 'Sheet1'!C2:'Sheet1'!F2 ????
Thus what i want to know is how to copy a range of cells when a certain item in the listbox is selected.
Anyone that has excel wisdom enough to break this problem?
Thanks.
This message was edited by friso on 2002-04-04 07:07
Lets say i have a combobox on 'Sheet1'!B2
which lists the values in range 'Sheet2'A1:
'Sheet2'!A50.
Sheet 2 looks someting like this<table><tr><td>Name</td><td>Company</td><td>Number</td><td>Account</td></tr><tr><td>Fred</td><td>fredscomp</td><td>12345</td><td>128</td></tr></table>
the user can select the combobox on sheet1. In this case this would be fred.
Now comes the question:
How can i make excel (when fred is selected) to copy the cells 'Sheet2'!A2:'Sheet2'!D2
to 'Sheet1'!C2:'Sheet1'!F2 ????
Thus what i want to know is how to copy a range of cells when a certain item in the listbox is selected.
Anyone that has excel wisdom enough to break this problem?
Thanks.
This message was edited by friso on 2002-04-04 07:07