Hi Deirdre,

The 'Research' problem was caused by the 'Master List of Program Goals and Objectives' workbook having a trailing space in the worksheet name (i.e. 'Research ' instead of 'Research'). Deleting that space will prevent the problem occurring; I've also modified the code to trim the worksheet names, which will likewise overcome it.

As for the name, I'd just call the template a 'Lesson Plan Template'. To be sure, it gets its data from two Excel workbooks, but that doesn't mean they need to be referred to in the naming. Those workbooks exist only to make maintenance at your end a bit easier; I could have hard-coded all their data in the template - but then it'd be a nightmare for anyone else to update.

All the coding is done in Visual Basic for Applications (VBA), a programming environment built into Office. In Office parlance, VBA and macros refer to the same thing; though most people refer to macros when talking about something they've created using the macro recorder. The code I've written for this project goes way beyond anything the macro recorder is capable of generating, though. If you want to see the code, simply open the template or create a document from it and press Alt-F11 to open the Visual Basic Editor.

Forums like this exist to help people develop solutions to their problems. Occasionally, though, people who support such forums go beyond that and develop complete solutions. You'll probably know the adage "Give a man a fish and he'll have a meal for a day. Teach a man to fish and he'll have meals for a lifetime". In this case, you've been given the fish, but it also helps me hone my VBA skills (all of which are self-taught). Enjoy.

Attached Files

Lesson Plan Template.dotm (62.6 KB, 101 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]