+ Control: The master sheet which allows selection of your filter or summation criteria and a button to execute a macro Notice that there are 3 worksheets in the workbook:
Open the example workbook (Production records.xlsm from the above links) or your own data file. The 1997/03 Sample has been tested on Office XP (and I make no claim that it will work in prior versions but it might/should) The 2007/10 Sample has been tested on both Office 2007 & 2010 This tutorial will only be using the 2007/10 files as examples but feel free to follow along if you are using previous versions. This process will be explained step by step with the help of a worked example: 2007/10 Sample or 1997/03 Sample + A Word file (to be used as a template, not to be confused with a Word template) In these cases although you may be able to setup an Excel file to look exactly like its Word equivalent. Some organisations will only accept files in Word format and may have specific formats which are used internationally (International shipping I’m looking at you!) This post will detail the process of establishing a simple database in excel and then linking that to a Standard Report in word and saving the data as a new Word file. Printing Excel Reports via a Word Document
