The way you'd do this is through VBA. You'd cycle through the active region of sheet 1, one row at a time, each time examining the relevant column. If you get a match for taupe, you'd then put the entire row on the clipboard, and paste it in the first free line on sheet 2. Sounds harder than it is. Give me a shout if you need some actual code. Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells Sent: 25 May 2004 19:44 To: mso@xxxxxxxxxxxxx Subject: [mso] Excel 2003 IF or Conditional or ?? Hi All. I'm at a conference this week and a question came up that I thought ya'll might be able to help with. We want, in Excel 2003, to set up a conditional (I think) that will take an entire row of data from an existing worksheet and place it into another worksheet in the same workbook. The row might be first, last, MI, address, city, state, zip, Other John, Smith, A, 102 E 1st St, Fairview, IL, 12345, brick Amy, Jones,,111 Abernathy Way, Lexington, GA, 45321, taupe The condition would be if Other = taupe, pull the entire row to another worksheet (in the same workbook). Is that doable? Thanks. /g ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************