Copying row to other worksheet if cell has specific data

**zaboune** · 01-04-2010, 05:19 PM

Hi,

I've searched the forums but couldn't find anything that worked for this.

I have an Excel 2003 spreadsheet with multiple sheets - one main one with all data and others which have only the data that falls into certain criteria. I'm wondering if there's a way to enter the information on the main sheet and have it automatically populate the correct "sub-worksheet" depending on what is entered in a specific column.

I'm not describing this well but I've attached a sample of what I mean.....

Hope you can help.
Thanks!

**contaminated** · 01-04-2010, 05:43 PM

I noticed that you separated your data by completed column (Yes and No). So I used then as main conditions in formula

For shet SOME

Please Login or Register  to view this content.

For Sheet None

Please Login or Register  to view this content.

Both confirmed as array formulas

**JBeaucaire** · 01-04-2010, 08:42 PM

I would think you might want to explain all the changes/additions you made to the OP's sheet to get that formula to work, since they aren't obvious.

**zaboune** · 01-05-2010, 03:18 PM

I'm trying to figure it out but I can't get this to work for me. I'm not quite sure what you did and keep getting #REF!

Please bear with me, I'm usually pretty good at figuring out the formulas and such but I'm not following why you aren't referencing the top worksheet and getting it to work.

**reneeh63** · 01-05-2010, 09:14 PM

Can someone please clarify this a bit?

I have a very similar issue where I have a "master" sheet with all our team's projects listed. I'd then like to automatically populate a worksheet for each team member that only has their particular projects. The master would have a column for the "Lead" person and the entire row from the master would be carried over to the Lead person's worksheet.

Thanks much!

**davesexcel** · 01-05-2010, 09:28 PM

Check out the example from this thread
http://www.excelforum.com/excel-prog...-workbook.html

**zaboune** · 01-12-2010, 04:01 PM

Thanks! That totally worked

**snobl01** · 12-30-2013, 11:03 AM

RT Tracking Sheet Sample.xlsI am new here but need help with this problem. I am new to excel and have bit off more than I can chew.

I want rows from Warranty tracking sheet to copy to sheet2 when a check of cells in "I" are marked with "NR". If there is no "NR" then do not copy the row to sheet2. Any help would really appreciated

**AB33** · 12-30-2013, 11:32 AM

Try the attached.

**JBeaucaire** · 12-30-2013, 11:35 AM

snobl01 - When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)

Do not post questions of your own in other people's threads (hijacking)
Do not post the same question multiple times across the forum. (duplicating, waste someone's time)

Continue your discussion in your own thread.