i have a list i need to copy onto another sheet one by one

B

bigsister

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.
 
D

Don Guillett

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.
 
R

Reeza

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top