Forum Discussion
Too large dataset - extract data within date range
"I've tried using a PivotTable to extract this dataset with only these dates, but even with Googling how to use them, I got stuck as I have no experience with them."
That could work if you have Power Pivot for your version of Excel. Open it, depends on your source select From Database or From Other sources and follow the wizard to import the data. After loading the data into data model you have two ways - create PivotTable from data model (as usual) or create linked-back table in the grid. For the latest on the ribbon Data->Existing Connections->Connections in this Workbook->Open (your connection)->Table.
The pro of the data model using is its performance which is extremely high. Data size on practice is limited only by your computer memory.