Hello everyone.
I would appreciate a lot any help with the following issue.
I Have the following Pivot table.
Version1_Airline_As_RowField.JPG
How to I get using VBA all Airlines (The name of Airlines, not the Totals) for a specific Station ? For example how could I get "AF" and "TK" for station "AAL".
Alternatively, if the Airline RowField moves as a ColumnField (as per the below attached image), how can I achieve the same result (i.e. gaet the column names when the total is <> 0 for a specific station. For example for station ABJ, i should get "AF","AT","ET")
Version2_Airline_As_ColumnField.JPG
I have been struggling with this for the last couple of days now !!!
Many thanks for your help !!
Bookmarks