• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help with Data Summary

Hello... Here is a very condensed version of what I am trying to accomplish here.

Several workers are assigned to several ongoing projects; their time is fully allocated in cells B2 through G4.

1) How I give their manager a summary similar to what I have in cells B12 through D14 without actually copying and pasting it?
2) How do I show changes that occurred from the first month to the 2nd month (table on the right)?

Thank you!!!
 

Attachments

  • Excel Example 10.13.20.xlsx
    9.4 KB · Views: 2
If you are OK awith a layout change of your data to a more standard XL friendly layout, a PIvot Table will help
 

Attachments

  • Excel Example 10.13.20.xlsx
    13.2 KB · Views: 1
Back
Top