Can Excel automatically copy ....

[stminz_]

Is this possible:
I have 3 Worksheets. 1 is a Master Document (index) of the other two worksheets. Worksheet 2 is labeled VNCA. Worksheet 3 is labeled VST. If I type an ID (VCNA or VST) in Worksheet 1 (index), I want excel to automatically place information that follows, into the oppropriate worksheet.

EX. Worsheet 1(index), I type in VCNA in A2. All of the info from that row, B2:F2, will then automatically go in on worksheet 2 (VCNA). Excel will know where to put that info. just by the ID that I type (VCNA or VST).

Is this possible??? If you need more information or don't understand, let me know.

Thanks for your help,
Scott
This message was edited by stminz_ on 2002-08-26 09:54
This message was edited by stminz_ on 2002-08-26 10:01
This message was edited by stminz_ on 2002-08-26 10:02

 

[Brian from Maui]

Scott,

If you ID's are unique, try using VLOOKUP. This maybe want you want.