It may be just as easy to see what Garry has or go to Ron de Bruin's
site and have a look at his "creating a summary sheet from many
workbooks"

http://www.rondebruin.nl/summary2.htm


Gord

On Tue, 22 Nov 2011 08:54:14 -0800, Gord Dibben
wrote:

Wizard OK with 2007 except it is limited to 256 columns and will save
templates only as *.xlt.


Gord

On Tue, 22 Nov 2011 00:57:19 -0800 (PST), Tony Barratt
wrote:

Thanx for your reply Gord!

-Before we get too enthusiastic.........what version of Excel is your
friend running?

2007

- Do you know which Template she is using for her invoices?

No. The actual template used is not known.