Excel VBA Data Validation Functions

Заказчик: AI | Опубликовано: 01.11.2025
Бюджет: 30 $

I have an excel macro that is a special kind of calculator we use for labor entries into our system. One condition currently produces an error we need fixing Where Labor Type = Cleanroom Error is in ‘Working Document’. This is currently calculating incorrectly. Its correct calculation should be: Calculation = (time to form Sterilizer Box [variable default tab, MFG-03 Cleanroom Defaulted Variables] * Secondary output[user input, Secondary Output Number]) + (Bag Drop*(qty per FG Box[user input, Qty Per Product BOM]) /Bag Per Sterilizer Box[variable default tab, MFG-03 Cleanroom Defaulted Variables])) As for the rest of this macro, I think it could use some general polishing and improvements. The way it calculates/outputs is correct. I just think it could maybe use some re-configuring as far as making it more user friendly.