| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
production cost
I am trying to make a form to track my production costs. How would I go
about making it so when I enter a part number, it autofills the costs it makes to make it. We have over a thousand parts and I want to split production into the cost of sanding and the cost of painting. Can you help??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
production cost
I am not quite sure about your "FORM" is it built using VBA, excel cells or
others. You can use vlookup/hllokup function to find the price for the part number you enter. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "Ashsyme" wrote in message ... I am trying to make a form to track my production costs. How would I go about making it so when I enter a part number, it autofills the costs it makes to make it. We have over a thousand parts and I want to split production into the cost of sanding and the cost of painting. Can you help??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I AM LOOKING FOR A SIMPLE PRODUCTION SCHEDULE FOR MANUFACTURING | Excel Discussion (Misc queries) | |||
| elseif formula | Excel Discussion (Misc queries) | |||
| Conditional Cost allocation | Excel Discussion (Misc queries) | |||
| our cost to customers cost | Excel Worksheet Functions | |||
| Production CLock | Excel Worksheet Functions | |||
Linear Mode
