C
Curtis
Have job spreadsheet that I design for my jobs. On the
first spreadsheet,Invoice sheet, I have my invoice for
the job which its like:
A1=Invoice amount B1=$3000
A2=Supplies B2=$1000
A3=Emp wages B3=$1500
A4=Job Profit B4=$500
A6=Employee Hrs
A7=Name B7=Joe Doe
A8=Rate B8=$10.00
A9=Hours B9= 34
A10=Pay B10=$340.00
So on,
Now on my Invoice sheet I use this to do my amounts for
the invoice for the job. I over write for each jobs and
print the invoice for that job and stuff. What I am trying
to is design a second spreadsheet for the total amount of
the jobs that was done for that month, or year. To keep up
with the accounts. Any help how to do the second
spreadsheet for the total of the jobs that was done?
first spreadsheet,Invoice sheet, I have my invoice for
the job which its like:
A1=Invoice amount B1=$3000
A2=Supplies B2=$1000
A3=Emp wages B3=$1500
A4=Job Profit B4=$500
A6=Employee Hrs
A7=Name B7=Joe Doe
A8=Rate B8=$10.00
A9=Hours B9= 34
A10=Pay B10=$340.00
So on,
Now on my Invoice sheet I use this to do my amounts for
the invoice for the job. I over write for each jobs and
print the invoice for that job and stuff. What I am trying
to is design a second spreadsheet for the total amount of
the jobs that was done for that month, or year. To keep up
with the accounts. Any help how to do the second
spreadsheet for the total of the jobs that was done?