Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Quote:
It's possible through either writing a VBA routine or a pivot table (if you are using Excel 2007 or later). I can help you with the VBA routine but the latter is easier. Here is how you achieve this using VBA. 1 Put data into a table (excel range). 2 Create a pivot table with the layout you wish. 3 Ensure you have the RELEASE in the page field. 4 Go to the Options tab -- PivotTable group -- Options -- Show Report filter pages. 5 Once you follow the above process you will see that Excel creates several pivot tables (one per RELEASE) and renames the sheet with the name of the RELEASE. This is quick and easy. If you need to refresh the data in all pivot tables go to Options -- Data -- Refresh All. Hope it was useful to you! Thank You, Prashant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
finding 1 formula result in a group of cells | New Users to Excel | |||
.find not finding formula result | Excel Programming | |||
Finding minum positive from the result of formula | Excel Discussion (Misc queries) | |||
finding the source location of a result | Excel Programming |