You don't need a macro to achieve the updating of one field fro
another. There are numerous ways to achieve what you are doing but yo
could just have a named reference that auto updates onto another shee
using =<namedreference or =<range such as =A1 or =Sheet1!A1.

There are really elegant solutions that could be achieved with some VB
code that will look up the community name for the date you are changin
and update things from there.

If you really want to get fancy then you can write a form to captur
the data and update all relevant fields.

If this doesn't answer your question drop me a line a
with an attachment and I'll reply with
completed solution

--
amorrel
-----------------------------------------------------------------------
amorrell's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=52304