Hi abc,

There is only a single drop-down field from which to pick a department - the full 6 characters or with a wild card mask. There are not 2 independant drop-down fields from which you can pick the first 3 digits (the station) and the last 3 digits (the department). I presume that this is what you were looking for, or something similar.

The purpose of wildcards/masks is to group multiple departments that match a pattern. In the example you cited, the selected 6-character department codes should be all those where the last 3 digits are '100', which in your case would be every station. If this is what is happening for you, then this is the expected behaviour.

If you pick the full 6 character code from the drop down - say '123100' - then you would get station 123 and department 100 for accounts 6000:6999.
---
Perhaps you could completely ignore the department drop-down field. Instead hard-code the account key that belongs in column B cells with the mask. You would do one row for each of your 3-digit departments, such as 6000:6999-???100. This would affect how Expand generates accounts and departments, and may not be what you are looking for.

You could even use a formula to build the account key for a specific station. For example, reserve a cell such as B3 to type in the 3-digit station code.
Then for an account key in some cell in column B, it could look like:
="6000:6999-" & $B$3 & "100"
This would take whatever station code was in cell B3 and insert it into the account key.

You may need to post a more specific example of what layout you are expecting (and what you mean by 'rollup'). You may also want to get your Adagio consultant involved.