On Sat, 02 Apr 2011 00:21:45 -0400, GS wrote:

A few Qs:

1. What significance does the 'highlighting' serve?
I cut up the tags (panels) into individual "box tags" or labels. The
"box" (a chassis, actually) they come out of has a serial number, as does
each item.

Each item gets individually boxed as it is removed from the chassis.

So, I get the serial number output from the application, and it fills my
spreadsheet (workbook) in fine, and I can highlight and print 4 different
panels, then step out of those and into the next four.

That stack of tags gets compared to the devices by the QC personnel
and once they ensure the match, the cart goes back to shipping to be
packed.

The labels are so that when they get into the field, the engineers will
know which boxes to open to re-populate a given chassis.

2. Could you not just copy the 4 sections to a blank sheet and print
that?

Highlighter fades, and that labor is what I saved by printing
pre-highlighted cells. I can also print to label stock that uses an A
size cut sheet as the baseline and provide four precut panels to print
and peel and stick. I have narrowed the 'panels' such that a single wide
piece of shipping tape will hold them on if printed with plain cut sheet
stock, and inside the label perimeter if label stock gets used.

OR

3. Why can't you just print the 4 sections 'as is'?

They are all identical and carry all the serial numbers that the
original 'box' carried. The highlight is to delineate which item is in
the box it (the tag) is on.


I used named ranges for the Y / N cells as well, so the "for/each"
statement (or the like) should be easier, since it is numeric, per se.

So that pair of columns looks like this

Panel 1 Panel 2

Front
Lite2 Y Lite2 Y
Lite3 Y Lite3 Y
Lite4 Y Lite4 Y
Lite6 Y Lite6 Y
Lite7 Y Lite7 Y
Lite8 Y Lite8 Y
Lite9 Y Lite9 Y
Lite10 Y Lite10 Y
Lite11 Y Lite11 Y
Lite12 Y Lite12 Y
Lite13 Y Lite13 Y
Lite14 Y Lite14 Y

Rear
Lite2 Y Lite2 Y
Lite3 Y Lite3 Y
Lite4 Y Lite4 Y
Lite11 Y Lite11 Y
Lite12 Y Lite12 Y
Lite13 Y Lite13 Y
Lite14 Y Lite14 Y


skip a few rows

Panel 3 Panel 4

Front
Lite2 Y Lite2 Y
Lite3 Y Lite3 Y
Lite4 Y Lite4 Y
Lite6 Y Lite6 Y
Lite7 Y Lite7 Y
Lite8 Y Lite8 Y
Lite9 Y Lite9 Y
Lite10 Y Lite10 Y
Lite11 Y Lite11 Y
Lite12 Y Lite12 Y
Lite13 Y Lite13 Y
Lite14 Y Lite14 Y

Rear
Lite2 Y Lite2 Y
Lite3 Y Lite3 Y
Lite4 Y Lite4 Y
Lite11 Y Lite11 Y
Lite12 Y Lite12 Y
Lite13 Y Lite13 Y
Lite14 Y Lite14 Y