production cost

G

Guest

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???
 
D

Daniel CHEN

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
==================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to autofill data from one sheet into another 2
Help with workbook updates 2
Retrieve specific date from one row of one column that is changing 2
Production cost form 1
Payback in Years 4
Formatting question with Round 3
pulling worksheet name from page data 2
Compare and get the best value 2

Top