| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing Data between sheets in a workbook
I have a master list of information on one sheet with each row being one set
of information. I want to divide the rows into different sheets in the same workbook based on certain critera such as a date. The information on the master list will constantly be added to so copy/ paste is not really an option. I can use an "if" statement to check one cell at a time but I need to move entire rows of information. Is this something that can be done is excel and if so, how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing Data between sheets in a workbook
Why not just leave all on one sheet and filter
datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "Jenny" wrote in message ... I have a master list of information on one sheet with each row being one set of information. I want to divide the rows into different sheets in the same workbook based on certain critera such as a date. The information on the master list will constantly be added to so copy/ paste is not really an option. I can use an "if" statement to check one cell at a time but I need to move entire rows of information. Is this something that can be done is excel and if so, how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving data between workbook sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| My excel spread sheets are dividing all numbers input by 100. | Excel Worksheet Functions | |||
| Dividing A Workbook Into Smaller Portions | Excel Discussion (Misc queries) | |||
| Workbook Summary Data from Sheets | Excel Worksheet Functions | |||
Linear Mode
