Forum Discussion
Excel issue
Hello everyone, I'm currently having an issue with a formula and I'm trying to figure out a solution for it. So I have a table that live feeds information that I'm referencing. In the table I have al...
The issue is that this page is the only way the get real-time numbers on production, if that machine changes what it's making at any point it becomes inaccurate because instead of seeing that there were already 40 things of one type made, and the first unit that the machine kicks out of a different type counting for 1, excel just sees that as being 41 and removes 41 parts from the inventory.
so somehow the excel sheet is reading information from the machine like # cycles but the machine doesn't know what those cycles are making? but somehow you want excel to know? You have to have more information and/or user intervention. That could be copying data over or running a macro or something. Again, very hard to help when I don't know exactly what is in the sheet and what info excel gets and such.
- When I get back from Thanksgiving break I'll get some screenshots to give you a better idea.