Forum Discussion
Excel Data Extraction
What I am trying to do is create a spreadsheet that will extra data from a page and use this information to populate other pages that have the same reference or part number.
On day 1/1/2018 if ...
Denver
Rather than have one sheet for each part number what I would do is to use a Pivot Table and only have one sheet for your report. Put the part number in the Page Filter or on the Rows section.
It is very easy to do and if you want to add more fields or change anything later you only have to change one Pivot Table rather than many individual sheets.
I will take a look at that. Not much good with Pivot Tables, but I will try. Thanks!!!
A simple way to get started:
- Enter a few sample rows of data in your sheet
- Click in any cell where you have entered data
- Click Insert, PivotTable
- Click OK
- Go to the new sheet with the Pivot Table
- Tick the boxes by Part #, Material Description, and the Qty fields
This should give you an idea. You can format to make it look better.
One think I always do is right-click anywhere in the Pivot Table, choose PivotTable Options, Click the Display tab, and tick the box by Classic PivotTable layout. I find it much easier to look at.