I tried the name box, but all it says is "print area". Is there anything
else I can do? I'm afraid I don't know all of the ins and outs of control
boxes and such.


"Otto Moehrbach" wrote:

I think what you're saying is you want something so that you can jump to a
specific block of data peculiar to a specific manager. If so, you can do
that several ways. Yes, you can have a Data Validation cell, choose a
manager, and a macro will jump the screen to that block. But an easier way
is to name the top left cell of each block, say, the manager's name. You
can then click on the drop-down arrow in the Name box, displaying all the
range names, click on the one you want and it happens. The name box is the
white space immediately above the "A" of Column A. Post back if you need
more or if this is not what you need. HTH Otto

"Bradly" wrote in message
...
I have a large spreadsheet of case manager activity. Each case manager
has a
certain number of rows and columns for his/her information (case manager A
uses the area A3:G43, case manager B uses H3:N43, etc.). There are 13
case
manager areas in group 1 (rows 1-43), 13 in group 2 (rows 44-86), 13 in
group
3 (rows 87-129), 4 sets in group 4 (rows 130-172), and 5 sets of totals at
the bottom (rows 173-215).

I want to create a drop-down box that would point to and locate the case
managers' last names or worker ID#s. These items are not contiguous--they
are located at cells B3:B4 for case manager A, I3:I4 for B, P3:P4 for C,
etc.
How can I go about creating a drop-down box for this?

Thanks.

.