Hi all, I'm learning about creating a pivot table in excel 2003 through VBA. Could you give your advice? When I click to a button then export list to excel and create a pivot table. Many thanks. Nhan