| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outline macro
I've imported 7000 rows of data (accounts) and there are multiple rows for
the same account. I've sorted the data so the multiples are concurrent. Is it possible to create a macro to collapse the multiple rows so there is only one visible row for each account? I would still end up with about 2000 rows. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Outline macro
Disregard this post, my question has been answered in a previous post.
"youngster" wrote: I've imported 7000 rows of data (accounts) and there are multiple rows for the same account. I've sorted the data so the multiples are concurrent. Is it possible to create a macro to collapse the multiple rows so there is only one visible row for each account? I would still end up with about 2000 rows. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping and outline | Excel Discussion (Misc queries) | |||
| Macro to Outline based on Indent Level | Excel Programming | |||
| outline | Excel Worksheet Functions | |||
| Macro to show/hide detail in an outline | Excel Discussion (Misc queries) | |||
| Macro to group outline | Excel Programming | |||
Hybrid Mode
