Data entry Excel 2003
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. |
Data entry Excel 2003
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. |
Data entry Excel 2003
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. |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com