I have a workbook with about 10 sheets in it, one for each of several
CSR's. On the first sheet, I plan to consolidate the data from the
other sheets, and on the second, third, fourth, fifth.... sheets, is a
sheet for each CSR to enter data.

On one column, I would like to have a dropdown box for each cell in that
column, that would have a CSR code in it. It's a small list, one that
would not require an external data source, but I'd want it to be just a
dropdown box on that cell.

How do I do that?


Also, on another cell - Customer Name - I'd like to populate that with
data from a SQL table based on a customer number. Is it possible to do
that in a dropdown box as well?

Any help appreciated.

BC