If A2 in sheet1 equals "......." copy entire row to sheet 2

**theprodigy** · 01-26-2013, 10:35 PM

Hi all

First post, this is to save the computer being donated to the garden off the front balcony.

I am trying to sort a list of products to specific pages, so as i update names - they update to a specified sheet....

So, If A2 in sheet1 equals "Donkey" copy entire row to sheet 2.... then If A2 in sheet1 equals "Camel" copy entire row to sheet 3

I hope this makes sense....

Cheers and thanks to all in advance.

**TMS** · 01-27-2013, 12:26 AM

Makes sense, but why would you want to do it. And what sheet gets the copy of the row? Looks more like a VBA requirement than "Excel General"

Regards, TMS

**mubashar** · 01-28-2013, 06:06 AM

yeah important question, i also want the answer of this question from the viewers .
Thanks

**theprodigy** · 01-28-2013, 08:42 PM

Thanks TM Shucks

I have over 4000 products on sheet 1 - with 38 columns of specific data for each product.
I am trying to break down the groups into smaller sheets - so excel doesn't take so long to make changes etc...
This is also the way i want to submit the data to web designer, I can sort and copy - but want this linked function
so when i am working in the sheet 2,3,4 etc.... they will make the changes to the front sheet at the same time.

I hope this makes a little more sense.

Cheers