If you are trying to save them time then you might try using validation.
You can allow them to choose from a list. You can vlookup the values
to carry them to any of the other sheets.

You can also have a cell that they enter a # and then the cell next to
it could be a vlookup that brings over the corresponding value.


--
Kevin Ward
------------------------------------------------------------------------
Kevin Ward's Profile: http://www.excelforum.com/member.php...o&userid=31417
View this thread: http://www.excelforum.com/showthread...hreadid=514584