B C D I
K
1 Twine TW-4357 049830A 2BRT3 5820-01-410-8981
2 AC HK-4723 5788125 1dep 6234-00-257-9831
3 AC HK-4723 578126 2dep 6234-00-257-9831
4 AC HK-4723 578995 3dep 6234-00-257-9831
5 AC HK-4723 578414 4dep 6234-00-257-9831

It looks like this, while some items are the same but have different
serial numbers. On the second page I have a complete list of all the
items (about 200 or so) but only use about 16 lines at any one time on
this sheet. I want to type in the info from box I and have the other
information (which is on the second page) put in.
So far this is some great responses and quick too. :)
I will have to try it out this friday when my schedule lets up a
little. Thanks all!


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