Copying Data from One Worksheet to Another

[Jeremy]

I am wanting to put the data in a specific row to worksheet 2 or 3 drivin by
a formula. If row one in the a column has a 2 I want the whole row of data
to copy to sheet 2 and if row one in the a column has a 3 I want the whole
row to copy to worksheet 3.


A B C
1 2 10 Aunts
2 3 10 Moles
3 2 11 Mice
4 2 12
5 12 Aunts


A1 to C1 would be on sheet 2
A2 to C2 would be on sheet 3
A3 to C3 would be on sheet 2
A4 to C3 would be on sheet 3
A5 to C5 would copy nowhere because there is no data in A5.


Thank you for your help.

Jeremy

 

[Don]

Sort of depends how many of these you have. If not many, then you can create
a filter in the column where the 2 or 3 is , (this can all be done in one
macro if you want to repet this) then filter by 2 , copy to sheet 2 , then go
back to the sheet and filter by 3, then copy to sheet 3. Repete for others

 

[Jeremy]

There are going to be alot of lines that this needs to be done to. The lines
will increase and decrease as data is added and changed.