I have a zipcode lookup tool which uses vlookup to get the names of territories, sales managers, sales directors, and time zones. It works off of the standard list of primary zipcodes (around 42k) plus a few that we know belong to current clients that are secondard zips.
Now I'm trying to do a client lookup. The problem is that the list is more than 89000 rows and I have to use Excel 2003 to allow the users access to the tool. I've divided the data into three alphabetic tabs.
I'd like to do a multi-tab lookup and have the results (1 or many) dumped to a spreadsheet box.
Any way to do this outside of vba? Anyone have a good vba solution?
Now I'm trying to do a client lookup. The problem is that the list is more than 89000 rows and I have to use Excel 2003 to allow the users access to the tool. I've divided the data into three alphabetic tabs.
I'd like to do a multi-tab lookup and have the results (1 or many) dumped to a spreadsheet box.
Any way to do this outside of vba? Anyone have a good vba solution?