Excel and Macros

[jw01]

Hey all

I need some help writing a macro. I'm no VBA junkie anywhere close and been struggling pretty bad this file for 2 days.

It's a file that is due tomorrow so is there anyone taht can help?

Basically, I like a list of cities and I need to show their zip codes through a macro. e.g. if user selects a district, then i want all the corresponding zip codes for them to show. a district is two branches (eg. Washington-Baltimore) so i need to show all washington zip codes then show baltimore.

any suggestions? anyone i can pay? thxs in advance.

I tried the excel boards.

 

[oldjones]

Here we call them Postal Codes, and my own is tight enough to be just the odd-numbers on my street. The last time I checked a book for codes, Toronto was quite a considerable few pages. Toronto-Hamilton (standing in for Washington-Baltimore) would be a very large chunk of data, way too large to be practical on a screen. Never mind that Toronto-Oshawa in the other direction is another kettle of codes just as big, that your DB—wherever it comes from— would have to be able to sort and put together. And then, what does anyone do with two cities' worth of gibberish-numbers?

I'd say whoever gave you this assignment misconceived it, and should re-think what they've asked for. Me, I'd be digging into the USPS; it's their system and they want people to use it. My bet would be they already have helpful ZIP routines and sub-routines they can point you at. But good luck to you.

 

[ig-88]

a web app seems more appropriate for this kind of interface (context-sensitive drop-down menu)

 

[Fred Zed]

a web app seems more appropriate for this kind of interface (context-sensitive drop-down menu)

yes, for example
http://www.zoho.com/creator/