Dear sir,
Thanks for your continuous support,
I have created a report with machine types wise Machine working production hours details. In this, I will tell you in detail.
Each machine works only for 11 hours a day. That's why I have created this report using a macro so that I will know which machines (Each Machine No.) have how many days of works load.
And I created a new sheet in the same excel file for all machine no?s and also plotted a VLOOKUP formula.
But right now, this problem is coming in the report that if I select any machine no (B-008 ) and update its continuous production time/ working hour then VLOOKUP is working well and give the proper Job Start date and End date.
But once I change machine no ( B-023, B-024 & B-025 )after that again repeat the same machine no ( B-008), thereafter no values and entry shows in the V & W columns.( Job start date and end date)
This is the problem and please solve this query.
Please note, once you update any value in production time hours (U column) please click on refresh on Summary 1 sheet.
Bookmarks