Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Ive run into a problem when trying to sort information. Here is my problem.
I get many blue prints each day that have numbered with areas that need to be measured. Each blue print is different. On one blue print I may only have three (3) areas that need to be measured when a different blue print may have one hundred and twenty five (125) different areas that need to be measured. When creating my part from the blue print I will have several different operations. Certain measurements go with different operations. There is no order to how the measurements are placed on the blue print. When putting my table together for the blue prints, here is how I have it set up. 1.) Part number of the drawing 2.) The number being measured on the drawing. (Single digit number) 3.) The measurement requirements for the above number. 4.) Comments about the measurement for the above number. 5.) The inspection method for the above number Now in my table I have steps 2-5 listed 125 times because I may have that many different measurements. In most cases however I have much less. Here is where my problem comes in. The part being made may go through several different operations. So the first operation of the process may need to measure to numbers 1,7,9,22. The second operation may need 2-6, 8 and 10-21. A different blue print and operations may be totally different. How can I create a report so that only the information needed shows up for example my blue print has 3 areas of measurements? I dont want 123 blank spaces wasting paper. I could create in the table a space for the operation for each of the 125 however I cant figure out how to sort it than. What ever help I can get would help a lot. -- Thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can anyone me help figure this out?? | Excel Discussion (Misc queries) | |||
Can anyone help me figure this out???? PLEASE???!!!??? | Excel Discussion (Misc queries) | |||
Can't Figure what I did | Excel Discussion (Misc queries) | |||
Can't figure it out . . . | Excel Worksheet Functions | |||
I just can't figure this one out | Excel Discussion (Misc queries) |