Hi,

I have a spreadsheet where each row records details of a phone call
received by an operator.

they enter the date, time, but when they get to purpose of call, i
want them to select from a combo box of values.

when they select from this combo box, i want another combo box to
populate with values dependent on their selection in the first combo
box.

for example. if in the first combo box they select option 1, the
values in the second combo box that they can select will be

Option 1.1
Option 1.2
Option 1.3

if they select option 2 in the first combo box, the values in the
second combo box that they can select will be

Option 2.1
Option 2.2
Option 2.3

the combo boxes will be at the top of the sheet, and when they select
an item the value will be copied to a relevant cell in the active row
any suggestions