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 Eq...
in the 5 separate site Sheets.
I guess u need to consolidate 5 sheets to one sheet before further analysis.
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 🙂
