Macro to show all codes for cities

hello

i have a list of codes (over 30k) for a list of districts

i have a working formula in column E that list all the codes for one branch i.e. New york

can someone pls help me so that a macro or a logical formula can be in place so it list all the codes for new york and then for boston?

ive been struggling with this for the past 2 days.

*see attached below*

i really really appreciate it.

basically i would like for it to look like this

column D....column E
Branch zip-code
New York 6565
6568
6562
6564
6563
Long Island 87989
87981
87980
87984

when i change the district in column C, then the branch listing changes in drop down in column D....so then the zip codes would change

im really and be gratefuly.

pls and thx u again!

why not just autofilter the sheet zip-code
select this sheet
assume no blank in data in this sheet
select A1
data-filter-autofilter
arrows in all columns
click arrow in column "district"
choose newyork-longisland
you get data for only district "newyork longisland"
copy filtered data to some other location
again select A1 click data-filter-autofilter
autofilter is removed and full data is seen.


you may be insterested in seeing the golden rules how the data base has to be first created for easy manipulation

http://www.ozgrid.com/forum/showthread.php?t=76234

hello nilem

one question for u...i have the following macro in place to protect and unprotect worksheet...however if the worksheet is protected....the macro u have fail to work....what code can i place? thx u sir

Please Login or Register  to view this content.

see attached...when i try to change the code...it says the workbook is protected....thxs for ur help again!