Multiple Summary Reports in e.g. Word, From Single Data Set

[courtland.clarkson@yahoo.co.uk]

Context:


I'm pulling together individual tailored reports for companies comparing their own information against a data set of 1000 other companies asked the same survey questions.


These will be one page summaries, ultimately as a pdf, that will have graphs and tables.


Questions:


1. How do I get excel to automatically extract one company's information and compare it against a total of all the other companies.


2. Then pull this across into a graph and a table in a pre-prepared Word template?


Any advice is much appreciated

 

[bobhc]

Good day Clarkson


Hui has posted this link on another thread you may find it helpful


http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/