Combobox multiple cell cange???

[friso]

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

 

[friso]

that helpt thanks!!!!!!

 

[Al Chara]

Why wouldn't C2 be "Fred"? If it is 1 then, you would have to use Index.