| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfering data between sheets
I need a formula that says something to the effect of:
IF the value in A1=2 THEN transfer A1:A10 to next available row in sheet 2 IF the value in A1=3 THEN transfer A1:A10 to next available row in sheet 3 etc. I need all the information in the row to transfer to the next available row, and have no idea how to do it. IF(A1=2,(?????),IF(A1=3,(?????),"bad")) ????? needs to transfer A1:A10 to next available row in another sheet If you can help, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
| auto transfering info between work sheets | Excel Worksheet Functions | |||
| Transfering data across worksheets | Excel Discussion (Misc queries) | |||
| Transfering Data from Several Sheets to another | Excel Worksheet Functions | |||
| Transfering data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
Threaded Mode
