Ok, so I'm stuck in a project for work.
I have created an excel workbook to hold all job details for one of the electricians employed here. So, I created a template, which I open up as a new worksheet within this book when a new job is started.
So, each of these sheets holds the individual job information such as:
Labour:
Date - Hours - Rate Per Hour - Total Per Day
10/06/09 4 £25 £100
Materials:
Date SupplierName Amount
10/06/09 - Supplier name - £40
So on and so forth....
Ok, now my problem is, I would like a summary sheet within the same workbook as all the jobs.
I would like my summary sheet to show ALL the totals of the different things such as labour hours, labour pay, materials used..etc.
Like
Labour - HOURS
Current - 1 Month - 2 Month - 3 Month - Previous
What I would like to happen is when I type into the individual job sheet, I would like these totals to automatically add themselves to the summary sheet. And then as times goes on, current would move to 1 month, 1 month move to 2 month...etc.
I know it's a massive complicated job...
Anyone happen to have ANY ideas??? (In layman's terms!)
Bookmarks