Forum Discussion
Pivot table data sources
Hello, I would like to create a pivot table from an excel workbook containing various worksheets. All the worksheets have the same headers. The data in the worksheets is organized by month - one wor...
Why not have all data in one sheet?
JKPieterse yes I could copy and paste into one sheet but there is a lot of data so trying to figure out another way
- Where does your data come from? There is no need to place data you want to summarize in a pivot table on a worksheet. If you import that data from e.g. a CSV file, you can pull that data directly into a query and create a pivot table from the query. You can even very easily import multiple CSV files into the PT. Check out Data, Get Data, From File, From Folder.
the data is already in a worksheet abstracted manually. But good to know about import and query function
