How to add info in comment from a another spreedsheet

**Freaks** · 07-05-2012, 02:10 AM

I am trying to get a cell to do more then it might be able to.

I am working with 2 documents.
1. Customer Information
2. Customer Orders

I want to be able to enter a customer ID# in the cell B column in Customer Orders.
I then want it to look up information in Customer Information.
C column.

Like so.

Name C4
Address C5 & C6
Phone # C7
Cell # C8

and put there information in the "insert comment" box that can be be linked to a cell.(right click a cell and select insert comment. That box)
BTW the customer ID# in Customer Information is in the D column.

Can this be dune?
please help.