I've created a MS Excel workbook, which consists of two worksheets. The second worksheet contains a list of items, the first contains a table, and one of the columns of the table is a bunch of comboboxes, referring to the list in the second worksheet.
Now I've realised that the list in the second worksheet is not complete, I have added some items. In order for those new items to be taken into account by the comboboxes in the first worksheet, I need to redefine all of them.
I'm wondering if there is no easier way to do this: I would like to create one combobox, based on a list of entries, and a list of comboboxes, based on that first one. If I decide to add something to the list of entries, I'd just redefine the first combobox and all others get updated automatically.
Is there any way to get this done?
Thanks
Dominique