Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
77
Views
Topic starter
I want to show the Dash Board to my Furnace operators.
Please tell me :
1. How I can display in Dash board the time when was the raw data updated?
2. We expect minimum hourly update. it can be updated in less than one hour but not later than 60 minutes from one update to another. Can we have kind of alarm or signal to highlight the delay in entering the data.
Thanks
Ashwini Singhal India
Posted : 23/08/2018 7:04 am
Hi Ashwini,
This requires VBA/Macro to detect changes in cells. Please post your question in the VBA forum as this is outside the scope of the Dashboard course.
It will help those to help you if you can provide a sample file with the column(s) you expect to get updated, as the VBA code will need to know where to look for changes.
Thanks,
Mynda
Posted : 23/08/2018 7:15 am
