View Single Post
  #6   Report Post  
rbrookov rbrookov is offline
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by witek View Post
rbrookov wrote:[color=blue][i]

regular pivot table where dates go to rows and column3 as value with
average as agregating function ?
Witek,

Yes, a pivot table is a way to do it. However, is there a way to do it utilizing a macro, and without creating a pivot table? I know that a macro can be written which produces a pivot table, but can a macro be written such that the result is not in a pivot table? Or is that not possible?

Thank you for your suggestion!!
Rob