Is there a way to make the informaition placed in cells dependent on
what is entered in a specific cell?

I have a sheet that I will enter my primary data in with a key cell...I
then want to have a seperate list on another workbook that has cells for
entering data from that key cell list...I then need the coresponding
cells on my new workbook to mirror the corresponding cells from the
initial workbook dependent upon what is entered in the key cell. How
can I do this.

Brad


--
bwhadden