Iâve 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 donât want 123 blank spaces wasting paper. I could create in the table a space for the operation for each of the 125 however I canât figure out how to sort it than. What ever help I can get would help a lot. -- Thanks Dave
My understanding of your problem - You have 125 rows for each part # and some of these rows have data and others are blank. You need to print only non-blank rows. You have two options: 1. Do not have blank rows in advance and insert as and when you need. or 2. Use the macro DeleteRowOnCell given by Chip Pearson at http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows. You may save your file, run this macro before printing and then exit without saving... "Dave S" wrote: > Iâve 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 donât want 123 blank > spaces wasting paper. I could create in the table a space for the operation > for each of the 125 however I canât figure out how to sort it than. What ever > help I can get would help a lot. > > -- > Thanks > > Dave
