| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
Group data in pivot using VBA
In Excel, we can group data in a field, for example: We can group A1, A2, A2 as List_of_1. Is there a way to do this via VBA? I have a lot data points to group and I want to automate the process. Thanks in advance. Nick. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Group data in pivot using VBA
Nel post oups.com
*Nick* ha scritto: In Excel, we can group data in a field, for example: We can group A1, A2, A2 as List_of_1. Is there a way to do this via VBA? I have a lot data points to group and I want to automate the process. Thanks in advance. Nick. Hi Nick, record a macro by the macro recorder, then post the obtained code so we can help you to modify it... -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
|
Group data in pivot using VBA
Range("A1:A3").name = "List_of_1"
Rgds J Nick wrote: In Excel, we can group data in a field, for example: We can group A1, A2, A2 as List_of_1. Is there a way to do this via VBA? I have a lot data points to group and I want to automate the process. Thanks in advance. Nick. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - add new group to original data | Excel Discussion (Misc queries) | |||
| I am getting an error when I try to group data in a pivot table. | Excel Worksheet Functions | |||
| How do you group data in a Pivot Table? | New Users to Excel | |||
| Why does the pivot table not allow me to group data? | Excel Discussion (Misc queries) | |||
| Group Pivot data by week | Excel Programming | |||
Linear Mode
