help with making invoices in excel please....

builder22

builder22

builder22

Soldato
Joined
14 Dec 2005
Posts
5,047
What i want to do is use "sheet 1" to have a list of invoices, so A1 would be the customer name, B1 would be the date of the invoice, C1 would be a description of the work carried out and D1 would be the total cost.........A2 would be the next customers name...B2 would be the date of that customers invoice etc etc

I know you can have a cell on sheet 1 appear on sheet 2 by putting =a1sheet2, or whatever the code is

but is there anyway I can have a list of invoice details and be able to print off any invoice in that list ?

so that all I need to do is select, for example row 2, and that would populate another sheet that looks like an invoice, then i could print it off

the format I have made the list in doesn't matter and can be changed if need be...
 
what you want to do is on your invoice spreadsheet, have a cell where you can select a number for which invoice you wish to see.

Say you enter the invoice number on the invoice into cell A1 on sheet2(say 7)...

Then use something like the following to pull in the Column and row you want to display:-
=INDIRECT("sheet1!A"&A1)
Click to expand...

^^above would display the contents as in =sheet1!A7

Do you follow?
 
You must log in or register to reply here.
Back
Top Bottom