| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data from one sheet to another using a formula
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. The number of rows I am wanting to do this with changes so I don't thing recording a macro will work. 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| Formula Help - Copy data from one sheet to another based on criter | Excel Worksheet Functions | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| With a formula copy data from one sheet to another | New Users to Excel | |||
Threaded Mode
