Re: Question about auto fills or linking sheets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




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?action=getinfo&userid=25215
View this thread: http://www.excelforum.com/showthread.php?threadid=387048

.



Relevant Pages

  • Re: counting and loops
    ... awesome..thanks for the quick responses ... everything that i stored in the array are numbers .. ... narutard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25111 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Tie 2 or More Modules Together (vba)
    ... I just wanted to thank everyone for there responses. ... I am still learning this VB stuff and it is getting a ... zero635's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24802 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Date sorting not working?
    ... *Thank you* all for your responses. ... The Autofilter didn't work. ... sarjak's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29402 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Rounding percentages of the total
    ... Thank you all for your responses. ... jesterhs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20902 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: huge problem with 1 excel doc
    ... lol 12 views and no responses:( ... ajisgod's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26483 ... Prev by Date: ...
    (microsoft.public.excel.misc)