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 ...
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.