I can't figure how to Sorting

D

Dave S

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.
 
S

Sheeloo

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

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

Top