Prev: Slow Cut, Copy and Paste in Excel 2007
Next: Calculate age
From: Bradly on 19 Mar 2010 16:29
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.

 | 
Pages: 1
Prev: Slow Cut, Copy and Paste in Excel 2007
Next: Calculate age