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
Bookmarks