Excel help please...

[builder22]

not too sure how complicated this would be....



what I want is to have an invoice form on a sheet in excel, be able to type in the customers details, description of work done and price on that sheet, then be able to save those details to another sheet. then if needed be able to bring that invoice back up in the future.
i have it working the opposite way just now, i type details in to one sheet (they're all in the same row), then by typing the number of the invoce in it populates the cells on the invoice. dont have excel here now but its something like 'indirect 1b!d10' d10 is where i type the invoice number (row number) then it uses whatever colum from that row

I know I could just save the invoice as a different file everytime but would like it to be a bit err slicker ?

 

[wesimmo]

You'd probably need to use VBA to do what i think you're asking to do.

To clarify, you have a formatted invoice sheet that you want to enter details on.

Once you have completed the invoice you want the details to be saved off somewhere so that you can retrieve them into the invoice pro forma in the future?

TBH, the whole thing sounds like you need a simple database with the ability to enter details quickly via a form and then produce invoices or reports off the data you capture?

 

[builder22]

yeah that's pretty much it
want to be able to enter the details on the form so that when entering the description of work done you can take a new line, or leave a space between lines etc. just now the part where you enter the description of work is 1 cell on sheet 1 so when it populates the cell on the form (sheet 2) it's also 1 cell, so it just word wraps

plus it's to make it easier for others to use, so whatever they type in is the way it looks when printed

 

[wesimmo]

Yeah, Access would be the better bet if you have an Office install with it included anyway.

I can quote you to build something for you!