Hi,
(WinXP, O2003 – UK SP3)
For starters – though I’m aware this would be ideal for a database, that is not an option //
Got a workbook with 3 main sheets:
#1. Companies (unique company names – currently about 50 rows in 12 columns, loaded into arrCompanyName)
#2. Transactions (unique transactions but lots of values are repeated – currently about 2000+ rows in 10 columns)
#3. Keywords (one column per keyword, each column has a defined name, eg. “dnCurrencies”, “dnCountries”, “dnCategories”)
In sheet 1, for each company, I’ve also got registered its main currency, related country etc.
I have a form with 4 comboboxes (1-4)
#1 is the main combo holding company names (eg combo1 is fed by combo1.list = arrCompanyName,1 )
#2 holds currencies (eg combo2 is fed by combo2.list = dnCurrencies)
#3 holds countries …combo3.list = dnCountries
etc.
Each combobox is fed with a single column “defined name” from the keywords sheet (except combo1).
Combo1 is fed from the company master sheet containing approx 50 rows in 12 columns (each company name is unique).
If I feed all controls from the arrCompanyName and uses “.BoundColumn”, I get same currency represented multiple times in the dropdown (50 companies gives 50 currencies – though there may only be 5 different ones).
So how do I??
Make sure that the currencies are only shown once in the currencies list. Countries are only shown once in the countries list etc…
Basically what I want is to remove duplicates from the linked combos and when Company name changes change all corresponding (combo 2-4).
Any good idea is very welcome…
TIA
RD