Copying Data from One Worksheet to Another

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top