| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i combine excel worksheets
Working with Excel 2007, we start with a status report of pre-populated
columns and rows of data. Multiple agents independently update the rows that are assigned to them, while leaving the unassigned rows blank. When all agents complete the assignment, we must combine their work into the master worksheet, then delete duplicate rows. What excel function would combine these multiple worksheets? Any way to easily delete the duplicates? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i combine excel worksheets
Do multiple agents actually add rows of new data or simply have to add
additional rows of original to add their quantites? If not adding truly NEW row, have you considered using the 3D formula approach. Multiple identiacal worksheets fro each agents, with a summary sheet to add all agents togenther. HTH "kgemind" wrote: Working with Excel 2007, we start with a status report of pre-populated columns and rows of data. Multiple agents independently update the rows that are assigned to them, while leaving the unassigned rows blank. When all agents complete the assignment, we must combine their work into the master worksheet, then delete duplicate rows. What excel function would combine these multiple worksheets? Any way to easily delete the duplicates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
| How do I combine two worksheets in EXCEL 2003 | Excel Discussion (Misc queries) | |||
| I need to combine two excel worksheets in one pivot table. | Excel Discussion (Misc queries) | |||
| How do I merge or combine 2 excel worksheets by a common collumn? | Excel Worksheet Functions | |||
| How do I combine two worksheets in Excel? | New Users to Excel | |||
Hybrid Mode
