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...
It is really hard to know without a sample sheet to understand what you have and working with. From what I gather is there is some table with totals and a reference cell about which part is being made by the machine at this time and when that changes it messes things up. My suggestion would be to create a column that calculates the totals for each part independent of what the machine is presently set to.
- 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.
