ExcelBanter - Data Field in Pivot Table

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

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

- - Data Field in Pivot Table (https://www.excelbanter.com/excel-programming/374311-re-data-field-pivot-table.html)

John Pierce

Data Field in Pivot Table

Thanks Tom, Thanks Dave, for the explanation and code.
I tried .Offset(0, 3).Value = "'" & Format(StartDate, "mm/yy")
and it works perfectly for me. Thanks again.

All times are GMT +1. The time now is 02:10 PM.