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