Hi. I am new to this forum and new to Pivot Tables. I am starting an epidemiological study that will use tablets for data collection. Data will be collected by research assistants each day and then uploaded to a server. At the end of each day I plan to download the datavase from the server (organized in rows for participants and columns for variables) in a csv file that I plan to manipulate in Excel. Each day this database will have new information (adding to columns and/or rows). However, when I download the data each day from the server the csv file will have a different file name, i.e. date and time of download appended. I am hoping to create a pivot table so I can easily view daily enrollment, monthly enrollment, and enrollment by each research assistant.

How can I create a pivot table that can be used with each new csv database? Will I have to create a new pivot table daily to use with the new csv file or is there a way to open the newest version of the csv database and have the pivot table automatically configure (e.g. with a macro???) Note: I will not be adding data to the existing csv file. New data will only be viewable in subsequent csv databases. Any ideas would be greatly appreciated.

Thanks very much,

McGill