I need to automate the creation of a pivot table from a csv file. I create the pivot table once a week, and the number of records in the csv file increases each time. I have not had much success in creating a macro that includes a statement to go to the end of the data to accomodate the increased number of rows. Can anyone assist with the correct vba statement?