Okay so I'm not very well versed in macros yet but when I need to do is creat a macro that can help me automate or speed up a tedious task of my job. Generally I am given very large data sets in excel and I need to cross reference origin zip codes and destination zip codes into a list that we directly service (I now do this by filtering and comparing zip codes to the sheet of zip codes we service) but I know there must be a faster way bc sorting through all this data takes hours sometimes.

im not an excel guru seeing as how i haven't owned a copy of excel in years, but if you're interested in importing to sqlite i can probably help you.

This post was edited by carteblanche on Sep 3 2015 01:20pm

I do this for a living.

PM me a bit of a sample of data and I can assist

The record function will get you off to a good start. Then you can tweak the code as necessary. Just google what you want to do and there will be 30 random people who have posted it on some excel related forum.

It sounds like using the index and match functions in excel are better suited to what you're trying to do though.
If you give more details as to what exactly you're trying to do, I might be able to help you.

Lets say you have your postal codes in a...
and you have the zip codes you allready service in C...
you simply put this in b

=find(a1;C:C)

and then sort all the cells to b:

whenever its 1 there is allready something there.

fastest way i can think of right now