ExcelBanter - list the pivot items into column a:a

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - list the pivot items into column a:a (https://www.excelbanter.com/excel-programming/412810-list-pivot-items-into-column.html)

edward

list the pivot items into column a:a

Hi,

May i enquire how do i use vba to list all the items in
pivotfields("branch") into sheet1 column A:A and also need not list ALL and
(blanks) into the column.

All times are GMT +1. The time now is 07:27 AM.