This is specific to SharePoint 2007, though I am sure it could cross over into 2010.
My situation is I am a site curator that inherited a site with 30+ lists. Several of these lists are using a drop down list with a hard coded list of names. Each time someone leaves the team or company I have to update all these drop down lists. Now I am aware of 3 lists but I am sure there is more.
I do not have access to SharePoint Designer so need a solution that is non code. But if this is something I can pass along to the SharePoint Admins to do I will be more then happy.
Once I narrow down all the lists using a particular column name I plan on changing them to a filtered lookup pulling off one list. Until then I have to update the drop drowns manually.
Thanks ahead of time.