Hi,

I have a table which lists many different materials along the top row.
The six cells below each material name contain different number values.
These are different for each material. These are all stored in a Sheet
called "Values".

I would like to have a cell on another sheet which, when a certain
material name is typed in (or selected fom a dropdown menu if its
possbile?), would automatically fill in 6 cells below it with the
relevant data from the "Values" sheet.

This is just to prevent an error in copying out a potentially large
amount of data.

Anyone have any ideas?

Thanks
Henry


--
henrat
------------------------------------------------------------------------
henrat's Profile: http://www.excelforum.com/member.php...o&userid=29001
View this thread: http://www.excelforum.com/showthread...hreadid=487779