Awesome! Thank you!
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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?.