I would like to be able to make a worksheet for entering data in an invoice
and for relavant data to be copied to an excel list that can be used for
totals and recording payment. There was something in earlier versions of
Excel called Template wizard which I think could do this. Any suggestions.
I'm happy to have a go at VBA.

For data entry using user forms the below is a good starter

http://www.contextures.com/xlUserForm01.html

If this post helps click Yes
---------------
Jacob Skaria


"Adele" wrote:

I would like to be able to make a worksheet for entering data in an invoice
and for relavant data to be copied to an excel list that can be used for
totals and recording payment. There was something in earlier versions of
Excel called Template wizard which I think could do this. Any suggestions.
I'm happy to have a go at VBA.

The Template Wizard with Data Tracking works with 2007 although it supports
only 256 columns and 65536 rows.

Have you downloaded the executable from the MS site?

http://support.microsoft.com/kb/873209/en-us

When you run the TMPLWIZ.EXE it does its thing but you can't find the
WZTEMPLT.XLA ?

Same thing happens with Excel 2003.

See this google search thread before proceeding.

http://tinyurl.com/2uxmud

You can email me to get a copy per the instructions in the google thread.


Gord Dibben MS Excel MVP

On Tue, 21 Jul 2009 09:03:01 -0700, Adele
wrote:

I would like to be able to make a worksheet for entering data in an invoice
and for relavant data to be copied to an excel list that can be used for
totals and recording payment. There was something in earlier versions of
Excel called Template wizard which I think could do this. Any suggestions.
I'm happy to have a go at VBA.