Loop, Count and Display Results

[evil_moses]

Hi,

I have two sets of data, with columns A in both tabs containing a stock code. I have a macro that starts when a code is chosen from a combo box.

I would like a create a macro that when run looks through column A of both sets of data and creates a list of all the different codes found in the tab containing the combo box (call it "Menu") that would make up the new list fill range of the combo box.

There will never be more than around 20 codes, but the list will change significantly every time the 2 sets of data are refereshed.

Is anyone able to help?

Thanks

Marcus