The number of columns is inconsequential for filtering.

Even in the short term, teaching your users to use filters (probably less than 5 minutes required) will be far more productive than your present arrangement. I didn't say they would have to filter by street name; I said they could. Given that streets often cross locale boundaries, the ability to filter by street means they don't need to find the locale first. This can be very useful for a user who isn't quite sure which locale a particular part of a street is in.

As for users being "Overwhelmed by working in the full table showing thousands of addresses", methinks you protest too much. The only time they'll be able see that data is if they have no filtering. This is no different than if they switch to the sheet containing all the data in your existing workbook anyway. With filtering, they'll only ever have one sheet to work with, not a plethora of them.

The filtering has no impact on whether users see addresses organised by streets, so your concerns there are groundless.

The two-way updates, that would require some complex macro programming and would immediately break down for any user who either doesn't allow them to run or has their macro security options set too high.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]