Lists from another page

Horton0909

New Member
Joined
Dec 19, 2005
Messages
1
Can anyone please Help ?

I am building a tool that will allow me to narrow my search of data based of certain criteria.

I have a list of parts that have product groups.

I would like to only see the parts from the second list that relate to a certain group.

ie Cab shows all the cab parts from the total list on sheet 2.

how can this be done?

I have been wracking my brains all weekend.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,118,389
Messages
5,571,850
Members
412,421
Latest member
Rimo86
Top