Linking Multiple cells
 

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

I have read your message 3 times but still don't quite understand what
you are asking. Please try again with a more specific example.

The INDEX and MATCH worksheet functions might be useful.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup