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 !!