belly0fdesir
01-30-2006, 03:15 PM
A question of mine, similar to this one was x-posted here (http://www.mrexcel.com/board2/viewtopic.php?t=190705&postdays=0&postorder=asc&&start=10).
I have a sheet called Summary and anytime there is a change in cells 'Summary!B6:B120', I want the change to be replicated in Jan:Dec!B7:B121. Also, any time there is a change in Summary!F6:F120 I want it to be replicated in Jan:Dec!M7:M121.
Column B is a list of names. So my goal is to have any name changed or added to the list in Summary appear in the list in Jan:Dec. Column F is department, which is also shown in Jan:Dec!M7:M121 and I would like it to react in the same manner.
Does this make sense to anyone? Does anyone know of a method I could use to accomplish my goal? Thank you to anyone who considers giving me help.
I have a sheet called Summary and anytime there is a change in cells 'Summary!B6:B120', I want the change to be replicated in Jan:Dec!B7:B121. Also, any time there is a change in Summary!F6:F120 I want it to be replicated in Jan:Dec!M7:M121.
Column B is a list of names. So my goal is to have any name changed or added to the list in Summary appear in the list in Jan:Dec. Column F is department, which is also shown in Jan:Dec!M7:M121 and I would like it to react in the same manner.
Does this make sense to anyone? Does anyone know of a method I could use to accomplish my goal? Thank you to anyone who considers giving me help.