MAKING A CONTRACT FROM DATA FROM A DIFFERENT FILE

M

MCNAB

Hi,

This advice was great, but I forgot to mention that the original data being
used is from a DIFFFERENT FILE, not just a different worksheet.

Any ideas?

Bernie Deitrick said:
Ben,

No, you would only be chaning the value in one cell, the key cell for the VLOOKUP formula. Then,
the VLOOKUP would return information from row 12 (when you enter the value from column 1 of your
data table that appears in row 12). And when you change the value in the key cell to that of row 13,
the information would change automatically. For the formulas below, you would change the value in
cell A1.

HTH,
Bernie
MS Excel MVP
Click to expand...
wanted a new contract, I could click on the person's row in the Excel
Worksheet and the data would copy over to the empty cells and create a new
contract. Is there some way?
 
Top