I have an invoice template that I fill in and with the use of VLOOKUP take
the information and put it into a record on another worksheet.
Can someone tell me how I start a new invoice so the new information will go
into a new record and not merely overwrite the previous record
Thank you in advance

You don't say how you are doing this
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dick23" wrote in message
...
I have an invoice template that I fill in and with the use of VLOOKUP take
the information and put it into a record on another worksheet.
Can someone tell me how I start a new invoice so the new information will
go
into a new record and not merely overwrite the previous record
Thank you in advance

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 Sun, 23 Aug 2009 03:56:01 -0700, dick23
wrote:

I have an invoice template that I fill in and with the use of VLOOKUP take
the information and put it into a record on another worksheet.
Can someone tell me how I start a new invoice so the new information will go
into a new record and not merely overwrite the previous record
Thank you in advance

Hi dick23,

Why don't you check out these two invoice templates:

'SpreadsheetZONE - Free Excel Template Repository'
(http://www.spreadsheetzone.com/searc...aspx?q=invoice)

You can download them for free, and I am sure one of them will work for
you. :)


Suzzy


dick23;461972 Wrote:
I have an invoice template that I fill in and with the use of VLOOKUP
take
the information and put it into a record on another worksheet.
Can someone tell me how I start a new invoice so the new information
will go
into a new record and not merely overwrite the previous record
Thank you in advance


--
suzzy
------------------------------------------------------------------------
suzzy's Profile: http://www.thecodecage.com/forumz/member.php?userid=435
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127779

Hi suzzy
Thank you for the lead, I have been looking for months for a decent, easy
to use invoice system. I knew someone had to have one.
Have you used either one of the 2?


"suzzy" wrote:


Hi dick23,

Why don't you check out these two invoice templates:

'SpreadsheetZONE - Free Excel Template Repository'
(http://www.spreadsheetzone.com/searc...aspx?q=invoice)

You can download them for free, and I am sure one of them will work for
you. :)


Suzzy


dick23;461972 Wrote:
I have an invoice template that I fill in and with the use of VLOOKUP
take
the information and put it into a record on another worksheet.
Can someone tell me how I start a new invoice so the new information
will go
into a new record and not merely overwrite the previous record
Thank you in advance


--
suzzy
------------------------------------------------------------------------
suzzy's Profile: http://www.thecodecage.com/forumz/member.php?userid=435
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127779