Hi,
If I understand you correctly,
mave a cell on each record in A that holds an unique cust
ID. Then in B you have to enter the ID for each record
(row). The adjacent cells need to have a vlookup of the
ID in A and return the corresponding data to B.
peter
-----Original Message-----
Goal: To have two worksheets and only input the common
information one time.
Example: Worksheet A is geared to customer
information - job number, date
started, customer name. Worksheet B is geared toward
cost information. I
would like to input the data on Worksheet A and have
it "linked" to Worksheet
B. I used to do this (a long time ago) but forgot how
and can't find it in
the tutorials. Thans for any assistance!
.
|