Hey All, hope everyone had Merry Christmas!
I am in little bit of dilemma. I kind of know what I want but not sure how to get there. I have list of employees with hours for every weeks and they are coming from two different systems. So, I have set-up two tabs for it, one of them I called "budgeted_Hrs" and other one I am calling it "Actual_Hrs". As I mentioned before I have same employees in both tabs and same weeks as well. In a perfect world the hours for every employee for each week should line up but for whatever internal reason if there is Delta (and there is always in some cases) that this pivot (or whatever I create here) should help the project admin track those changes and take necessary action to ensure that hour lines up and will line up in near future.
So, I have created table for both tabs and not sure if this should be combined into one table/tab or not.
I would like simple organized data (doesn't matter pivot or table or any other excel product/format)that will let me input the data and let user view whatever they like. I was thinking pivot table and started this whole task but feel like I am lost not sure where to go...any help would be greatly appreciated it. Thanks
(wish you all happy and prosperous 2018! God bless you!)
I am in little bit of dilemma. I kind of know what I want but not sure how to get there. I have list of employees with hours for every weeks and they are coming from two different systems. So, I have set-up two tabs for it, one of them I called "budgeted_Hrs" and other one I am calling it "Actual_Hrs". As I mentioned before I have same employees in both tabs and same weeks as well. In a perfect world the hours for every employee for each week should line up but for whatever internal reason if there is Delta (and there is always in some cases) that this pivot (or whatever I create here) should help the project admin track those changes and take necessary action to ensure that hour lines up and will line up in near future.
So, I have created table for both tabs and not sure if this should be combined into one table/tab or not.
I would like simple organized data (doesn't matter pivot or table or any other excel product/format)that will let me input the data and let user view whatever they like. I was thinking pivot table and started this whole task but feel like I am lost not sure where to go...any help would be greatly appreciated it. Thanks
(wish you all happy and prosperous 2018! God bless you!)