Hi. I need a macro to do the following: Take any NEW info entered into a
Master Template and copy it to another template as well as 20 different
worksheets. I attempted to do this linking the files, but it's not producing
the required result. Any help or recommendations would be greatly
appreciated! Thanks!

"rogue6" wrote in message
...
Hi. I need a macro to do the following: Take any NEW info entered into a
Master Template and copy it to another template as well as 20 different
worksheets. I attempted to do this linking the files, but it's not
producing
the required result. Any help or recommendations would be greatly
appreciated! Thanks!

I think you should use an event for this

Private Sub Worksheet_Change(ByVal Target As Range)
'Copy the data to your 20 worksheets
End Sub

/Fredrik