Every hour data require in single excel sheet or in single report
I am using reporting feature in CHMI. My Report get generate at every hour, but every time new excel sheet is going to generate, Can I update the data of every hour in single sheet instead of generating new excel sheet every hour. Also I want one excel sheet for every 24 hours. How to do it?
Voted best answer
> "Can I update the data of every hour in single sheet instead of generating new excel sheet every hour."
No, not automatically. Scheduled reports always create a new report ( You can manually open and existing report and press F9 to recalculate, but I assume thats not what you want)
> "Also I want one excel sheet for every 24 hours. How to do it?"
With a new report, the same way you did the hourly sheet, except you run it once per day.
You are probably best to program a "daily report" in your PLC, where you capture the hourly data and show this on an operator display. You can either print screen for todays report, or just wait for the Automatic 24 hour report to run.
hi, is not a common use
its dificult but one idea is to implement macros on your sheet
change date form to number form and create a conditional if b9 = 9000 then update
after that send command print in a pdf or similar way
sheet must be always open for run the macro (problem)
its no easy but could work
if you need more information let me know,