need help with invoicing

[DUN RITE ROOFING]

I do construction, and I have all my invoices on my computer in excel. Is
there a way to import the job totals and labor into another worksheet. from
all my invoices I have and will have in the future?

[oldchippy]

I do construction, and I have all my invoices on my computer in excel. Is
there a way to import the job totals and labor into another worksheet. from
all my invoices I have and will have in the future?

Hi Dun Rite Roofing,

The answer is yes, play around with something like this

Open your spreadsheet, say Invoice1.xls. Then open a new spreadsheet, click cell A1 on your new spreadsheet, then =, then click on the "Totals" on your Invoice1.xls, press enter.

You now have the total in your new spreadsheet

oldchippy

[jujuwillis]

How about using the invoice as a template and using the template wizard under the data menu.

So every time you use the template to create a new invoice, it will ask you if you want to update the sheet you have assigned to hold your invoice information.