I have a constantly updated Excel file containing address information which I am currently copying into the attributes of new polygons which I am creating on a daily basis. I am currently doing this my manually by copying the address across from the Excel file each time a add a new polygon.
I am looking for a way of automating this process. After producing my polygon I would like a drop down box/ or search function of a unique ID which once selected will fillout the correct attributes by pulling them from the Excel file.
I am new to arcgis 10 and would have previously used the VBA editor to have a go at this (no expert). However, I see that unlike the previous versions there is not longer and VBA editor and has been replaced by python, which I am unfamiliar with. I have also spotted the model builder tool, not sure if this could be used to solve my problem? So really I'm just asking for a point in the right direction.
Is there any scripts available to solve a similar problem which I can modify?