We have a mailing list of around 300K people – this is in CSV format and contains the geo-coding for each address (lat / long) – call this the "original list". We have another list of say 25 homes – there is no geo-coding in this list – this list contains a column "how many homes needed" – call this the "trigger list". We need to generate a new list of the nearest x homes around each of the say 25 homes (in the trigger list) from within the "original list" – this output list should contain the same layout and columns as in the "original list". So maybe something like – drop into a folder "orginal_list" that CSV file – drop into a folder "trigger_list" that CSV file – run the macro – geo-code the trigger list – place into the folder "output_list" the final CSV file which contains the mailing list of the nearest homes to those within the trigger list (say 100 nearest homes to address a and the nearest 250 homes to address b etc. etc). ------------------------------------------ Added 12 JUN 2012, 10:09 AM EDT The original mailing list of 300K people called "master_list" has been uploaded. Previously called the "original list" The "trigger_list" has been uploaded. The "production-list" (called output list previously) has been uploaded. From these 3 files you can see the format of the original / master list. The format of the trigger list. The format of the final list - the output list - the end result. ------------------------------------------ Added 16 JUN 2012, 10:54 AM EDT We would like to appoint this project in the next couple of days. If you have any questions please feel free to ask. Please provide your bid so that we can select the contractor soon. Desired Skills: Data Modeling Data Structures Microsoft Access Google Maps Keywords: Other IT & Programming