recognizing area codes and time zones

[rooshio]

I have 2 lists: 1 with a bunch of phone numbers I'd like to call. The other is a list of area codes with the time zones in adjacent cells.

I'd like to somehow separate my list of phone numbers by time zone. Any Ideas on how to do this?

[JBeaucaire]

Sure, sure. You'll just need to add a new column to your phone listing to find the time zone and list it for each row. Then you can sort your phone list by that column to put all the zoned numbers together.

The technique for doing this will be greatly influenced by you data format.

So, click on GO ADVANCED and use the paperclip icon to post up your workbook, or a good enough excerpt that we can fully demonstrate a solution for you. Make sure it has sample numbers and your time zone chart, too.