LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default I can't figure how to Sorting

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can anyone me help figure this out?? Beginner Excel Discussion (Misc queries) 3 August 22nd 07 11:26 PM
Can anyone help me figure this out???? PLEASE???!!!??? SuzieinNC Excel Discussion (Misc queries) 3 August 22nd 07 10:16 PM
Can't Figure what I did Tony_NYCOM Excel Discussion (Misc queries) 2 May 28th 06 10:32 PM
Can't figure it out . . . [email protected] Excel Worksheet Functions 8 May 3rd 06 04:29 AM
I just can't figure this one out Barb1 Excel Discussion (Misc queries) 1 February 22nd 05 03:30 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"