| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Data from One Worksheet to Another
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Data from One Worksheet to Another
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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Data from One Worksheet to Another
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. "Don" wrote: 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" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copying data into a new worksheet | Charts and Charting in Excel | |||
| Copying filtered data to another worksheet | Excel Worksheet Functions | |||
| Copying Row Data to Specific Worksheet | Links and Linking in Excel | |||
| Automatically copying data from one worksheet to another | Excel Discussion (Misc queries) | |||
| Copying Data List to Different Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
