Linking cells from one workbook to another..

**Lacetti** · 09-16-2008, 08:06 AM

Please can someone assist me.....

I have 2 workbooks, Customer Complaint Form and Customer Complaint Log. I need to complete the Customer Complaint LOG with various information, which needs to then be completed on the Customer Complaint FORM.

How do I link the LOG to the FORM, so that I do not have to enter the information twice??

I have attached both workbooks which I am trying to complete....

Complaint Entry No.
Date
Customer
Complaint No.
Value
Collection No

The above has to be entered on the log AND the customer complaint form - I have tried the Microsoft On-line help, but it is very unclear to be of any help.

Your help and assistance would be much apprieciated.

**NBVC** · 09-16-2008, 08:14 AM

Wherever a numeric result is to be returned (e.g. Complaint Entry No., Date Received, etc)...use a formula like below:

=LOOKUP(9.999999E+307,'[Customer Complaint LOG.xls]CCL SEPT 08'!$A$7:$A$21) ... this one returns Complaint Entry No.

Wherever a text string result is to be returned (e.g. Complaint Code), use a formula like below:

=LOOKUP(REPT("z",255),'[Customer Complaint LOG.xls]CCL SEPT 08'!$D$7:$D$21) ... this one returns Complaint Code.

adjusting ranges to suit.

These formulas return the last entries made in the log to the form.