MOving Data to the next line
Hi All
I have a spreadsheet template that I use as a Purchase Order. There is information on that sheet that I want to be transfered to a table. I do not want the data over written when using the template again, I want the next line to be used for the same data but now with the second time I have used the template... HEre is a list of the information that I am currently capturing on the Purchase Order Template. VENDOR NAME VENDOR NUMBER ACCOUNT CODE CENTRE CODE D/C Cost per unit Discount Quantity AMOUNT DESCRIPTION Value Vat (gst) TOTAL AMOUNT REQUEST DATE Midas 123456 152 Invcontrol D R 3.00 0% 500 R 1,500.00 11MM Socket R 1,500.00 R 210.00 R 1,710.00 09/16/2009 Any tips or guidliens would be greatly appreciated. Thanks Greg |
MOving Data to the next line
If it is a true Template(*.xlt or *.xltx), data will not be overwritten.
A new workbook based upon the template is what opens for you to work with. Sounds like you need the Template Wizard with Data Tracking. 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 Wed, 16 Sep 2009 12:07:01 -0700, Greg S wrote: Hi All I have a spreadsheet template that I use as a Purchase Order. There is information on that sheet that I want to be transfered to a table. I do not want the data over written when using the template again, I want the next line to be used for the same data but now with the second time I have used the template... HEre is a list of the information that I am currently capturing on the Purchase Order Template. VENDOR NAME VENDOR NUMBER ACCOUNT CODE CENTRE CODE D/C Cost per unit Discount Quantity AMOUNT DESCRIPTION Value Vat (gst) TOTAL AMOUNT REQUEST DATE Midas 123456 152 Invcontrol D R 3.00 0% 500 R 1,500.00 11MM Socket R 1,500.00 R 210.00 R 1,710.00 09/16/2009 Any tips or guidliens would be greatly appreciated. Thanks Greg |
All times are GMT +1. The time now is 03:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com