Need help on Excel

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

I have made a program to keep up with my job cost and
Payout summary. I have that on Sheet 1, I am trying to add
things to sheet 2 for the total of the job record. Sheet
one in my main list to adding the cost and stuff for each
job. On sheet two, trying to make it work for total of
each jobs, which on sheet one I use to firgure my
supplies, invoice amount, wages and Profit for each job.
And my sheet two is for total of all jobs. So, I need help
on how to make it work for sheet one for each job and
sheet two for all the jobs. On each jobs I overwrite sheet
one for the next job and like for sheet two to keep a all
the jobs for the year. Any help?
 
One way to set it up:

On Sheet1, enter all the items for your jobs, in a table.
For example:
Date Job Item Amount
1/2/03 1 Wages -416
1/12/03 1 Invoiced 650
1/17/03 1 Supplies -318
1/18/03 2 Wages -700
1/19/03 2 Supplies -250
1/20/03 1 Supplies -110

To view the data for one job, apply an AutoFilter (Data>Filter>AutoFilter)

To summarize the data, create a PivotTable:
1. Select a cell in the table.
2. Choose Data>PivotTable and PivotChart Report
3. Click Next, select the Data range, click Next
4. Click Layout
5. Drag Job to the Row area
6. Drag Item to the Column area
7. Drag Amount to the data area
8. Click OK, click Finish
 
Back
Top