Using the VLOOKUP worksheet function should get you there.

See help on VLOOKUP.

OR go to Debra Dalgleish's site for more of this function.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Thu, 14 Jul 2005 14:43:18 -0400, "Ccp" wrote:

In a spreadsheet having to do with installing machinery in customers'
facilities, I have one sheet (sheet A) with client data several columns
wide - name, address, machine, model, specifics, yada yada; one column is
INSTALL DATE.

I would like the entire row to copy itself to a second worksheet (sheet B)
when the column for INSTALL DATE gets filled in, so that I will have a quick
reference on which installs have been completed.

I can't figure out how to do this. It's probably simple. Can anyone help
me?.