I need help in VB with Excel. I have a sheet, titled Order, that I want to pivot Column A and Column F. For the layout I want Column A in "Rows" on the pivot and column F to be in the "data" field as an average. Is there a way to do this. Any help is appreciated. Thank you.