Hello all,

The data i have is spread over two sheets. One sheet has the parts data
and the other the componet part data, essentially i would like to link
these two sheets so that when i look at a particular part i then see
each component part that belongs to it and all the corresponding data.
I was hoping for a dropdown menu or somekind of link. The data doesn't
need to be modified, simply viewed.

I'm not sure if i have explained this particularily well. I have
average excel knowledge, but no VBS skills whatsoever...

I hope someone can help.