Forum Discussion
Should I use a Pivot table?
I think I need to create a Pivot Table but not sure way to do it and would appreciate some direction please for the following:
- I have a separate Excel sheet for Qty 5 x sites that have different Equipment lists.
- Each Item has a Unique Part Code
- I need to give a value against each Part Code
- I have a master sheet with all the different Part Codes and Values
- Using the master sheet how can I populate a value in a cell against the Part Codes in the 5 separate site Sheets.
- I will be adding more sites and changing equipment in the sites as designs change
- in the 5 separate site Sheets.
I guess u need to consolidate 5 sheets to one sheet before further analysis.- Thanks but I do not think that is best as I need to present each site as a separate equipment list with values (or costs). That change as assets are added or disposed of. I was just trying to see if there was an easier way of pulling the costs from the master sheet into each separate site sheet using the part codes. I can obviously type = in each cell and highlight and enter against each individual price on the master sheet. Just thought there might be an easier/quicker way of doing it 🙂
