I'm looking at ways to set Excel up to read a record from one excel sheet and then output the information to a word / excel and possibly even project templates. I can sort out the menus and buttons, but its the output to template, I can't find info on.

- Thanks:

ps. project info.

Project:
Working on building up some Excel features. Currently information is entered on an access database, but this information is changed for other reasons.

So I'm creating all the same information on a spreadsheet (I know this is not ideal, and fixing the database would be more sensible, however for various reasons this isn't possible - and so the required solution is a spreadsheet for just this teams work, and they can still use the db for its value), I have the information from the database as is. And I've filtered the stuff I don't want out; i.e. other teams work, they have their own solutions.

I've managed using vlookup to create a information lookup reference on a separate sheet but I would love to be able to make this trigger information into a template, potential for adding a save option and default name, would be brilliant. Hoping to develop it further, if I can.