Rodney Watters
New Member
- Joined
- Oct 1, 2008
- Messages
- 4
I'm hoping someone will be able to help me with this problem. I'm trying to develop a document using excel. It will be used for In-coming QC on delivery of raw materials. I want to set it up so there is one document that my technicians will use rather than having to select from nearly 3000 different ones. Nearly all the information they data points they collect are the same it's just the variations in the measurements are different. For example there are 6 main styles for this part but, 500 different variations depending on length, width and so on.
I've done similar things in the past but not this extensive. What I am trying to do is place all the measurements needed in on one worksheet then have a templated document on another worksheet. The technician will enter one 4 digit number on the document and the remainder of the information will auto-populate in their repsective cells.
Problem is I don't remember how its done.
Any help I can get would be greatly appreciated. My plate is full due to being the new QC manager and I'm building the ISO and FDA infustruture from ground zero.
I've done similar things in the past but not this extensive. What I am trying to do is place all the measurements needed in on one worksheet then have a templated document on another worksheet. The technician will enter one 4 digit number on the document and the remainder of the information will auto-populate in their repsective cells.
Problem is I don't remember how its done.
Any help I can get would be greatly appreciated. My plate is full due to being the new QC manager and I'm building the ISO and FDA infustruture from ground zero.
