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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from one sheet to another using a formula 2
Excel Help to copy information from one row at a time to another sheet 1
How to update data from multiple sheets to one specific sheets 4
Auto Copy Data from one worksheet to another 1
How to insert new worksheet based on # of rows in a data sourch 2
How to copy data from certain cell in one tab to another tab 1
pulling from one sheet to another 3
Summary Worksheet. 1

Back
Top