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 the part number received is 111 I would like to have this information transferred to the sheet for that particular part number. There will be both receipts and issues. If the part number for that day is 222 then the information would populate the sheet for 222 part number.
The general idea is that by providing a single entry point you can collect and input all the data in one place while updating each applicable sheet with the corresponding information for that day. You could then look at each part number individually or look at the overall transactions
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.
