List box, copy multiple Cells
 

I want to have a single Drop Down list box, which I have setup to get
data from another sheet. What I want to do is when I select a item from
the drop down list, I want to display several Cells from the other
sheet. Does that make sense?

Thanks

On 8 Sep 2005 07:30:55 -0700, wrote:

I want to have a single Drop Down list box, which I have setup to get
data from another sheet. What I want to do is when I select a item from
the drop down list, I want to display several Cells from the other
sheet. Does that make sense?

Thanks


I'm not quite clear what you mean by 'display several cells'.

Are these hidden to start with?
Do you just want to go to the sheet and view the cells?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________