Macro for workbooks
 

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!

Macro for workbooks
 

"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