I have created an invoice on an excel spreadsheet for a new business and my
plan was to use a sales list on another sheet linked to the invoice , using
the same fields it worked perfectly the first time using basic = sign, then i
discovered that second and subsequent entries to the list would have to be
set up again . can excel handle this so that I don,t need to retype after
each entry.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bigsister" wrote in message
...
I have created an invoice on an excel spreadsheet for a new business and my
plan was to use a sales list on another sheet linked to the invoice ,
using
the same fields it worked perfectly the first time using basic = sign,
then i
discovered that second and subsequent entries to the list would have to be
set up again . can excel handle this so that I don,t need to retype after
each entry.

On Mar 25, 2:58*pm, bigsister
wrote:
I have created an invoice on an excel spreadsheet for a new business and my
plan was to use a sales *list on another sheet linked to the invoice , using
the same fields it worked perfectly the first time using basic = sign, then i
discovered that second and subsequent entries to the list would have to be *
set up again . can excel handle this so that I don,t need to retype after
each entry.

You can, but need to be more specific of what you're looking for.

My guess is that you have a sales info entered on one worksheet and
want another sheet that generates the invoices for the particular
sales.
If I'm right, a quick suggestion would be to use a MS Access database
for this, rather than excel. You can set it up similarily and then
have invoices print for all entries that are not marked paid in full.
If you need help email me.....unemployment is boring!