Hello all. I am very new to excel and want to know if this is possible.

I want to enter a name into box I6 and have it automatically fill in
box B6, C6,D6 AND K6 on sheet 1, when I hit enter or toggle one of the
arrow keys to another box.. I have about 200 or so different items that
can go into row I. Sheet 2 has all the serial numbers and stock numbers
etc.

Row B,C,D and K are names of the items in the inventory, basically a
combination of numbers and names with no math involved. Just serial
numbers and stock numbers, that sort of thing.

What I need is to be able to enter the common name into row I6 thru I15
(One row at a time. These are the only rows that will be used at any one
time for each sheet before printing) and have the corresponding serial
numbers / stock numbers/ inventory numbers etc entered automatically. I
realize that setting this up initially could be time consuming but it
would save me tons of time in the long run.

Ie, I enter “cotton twine” for I6 and enter, then the corresponding
info for that twine pops up in B,C,D and K6.
Thanks for the help!


--
CEN
------------------------------------------------------------------------
CEN's Profile: http://www.excelforum.com/member.php...o&userid=25215
View this thread: http://www.excelforum.com/showthread...hreadid=387048