Have created a workbook with the "working" data and a second workbook with KPM monitoring. All information in the KPM spreadsheet is pulling from the "working" data - however, the links will not update when opening the KPM spreadsheet. Also, when trying to enter a new formula..... =COUNTIFS( )...
Is it the group that is changing - as in Dave Smith goes from Group A to Group B? I'm not sure I quite follow the above -
This could be a simple pivot table if I understand correctly.
I've created my dashboard and the way I want it to look - however, all of the data is in outlying spreadsheets - same server and I'm able to access. Is there a way to create a Macro for an update (click of a button). Also, in this Macro, I'd need to move current over to prior and update...
I've never used sharepoint, but would also like to do somewhat of the same. Be able to create a dashboard that refers to several charts from separate teams within our department. If sharepoint is the way to go, how can I get further information on this? However, since all spreadsheets are on...