Excelnewbieneedtolearn
New Member
- Joined
- Feb 7, 2025
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Alright so, I have a sheet that we use daily for production tracking in a factory and the one we’ve been using was good but it had a lot of now irrelevant information on it (company changes). Now most of the code I worked out how it functioned within the sheet and changed what I could but I’m stuck on a function I’m trying to figure out for it.
It’s got a column for “production status” (“IP”,”Ready”) that works when the rest of the sheet corresponds correctly, my problem comes when we use different materials/products between jobs. Currently it all has to say “Done” before production changes to “Ready” which is fine but can be time consuming as most of it is done on phones/tablets not on pc. Could I add a column for material type and have it ignore certain data to change production status to “Ready”?
Any help with this would be greatly appreciated
It’s got a column for “production status” (“IP”,”Ready”) that works when the rest of the sheet corresponds correctly, my problem comes when we use different materials/products between jobs. Currently it all has to say “Done” before production changes to “Ready” which is fine but can be time consuming as most of it is done on phones/tablets not on pc. Could I add a column for material type and have it ignore certain data to change production status to “Ready”?
Any help with this would be greatly appreciated