benong
02-10-2012, 01:29 AM
hi,
i've a list of data in sheet 2.
eg.
model item
A 1
A 2
A 3
B 1
B 5
B 8
C 2
C 3
C 6
i want to input any model number/s in sheet 1 and the whole list of items for that model will be list out on sheet 3.
eg.
i input "A" in sheet 1 A1 and "C" in sheet 1 A2.
Then when i go to sheet 3, i can see the following list:
model item
A 1
A 2
A 3
C 2
C 3
C 6
How can this be done?
i've a list of data in sheet 2.
eg.
model item
A 1
A 2
A 3
B 1
B 5
B 8
C 2
C 3
C 6
i want to input any model number/s in sheet 1 and the whole list of items for that model will be list out on sheet 3.
eg.
i input "A" in sheet 1 A1 and "C" in sheet 1 A2.
Then when i go to sheet 3, i can see the following list:
model item
A 1
A 2
A 3
C 2
C 3
C 6
How can this be done?