N
no-one-but-me
Ok, this is a long query. Well... very confusing!
At work I have a workbook which each worksheet contains details of 1
individual job. So one worksheet = all the labour, rates & material purchases
of 1 job.
So, I created a template which I open upon getting a new job. This is all
fine.
Now I want a summary page within the workbook, which pulls all the
information from the job worksheets.
For instance I'll have
Hours
Current - 1 Month - 2 Month - 3 Month - Previous.
So in the 'current' cell it will have all the info pulled in from the
worksheets and it should automatically seperate into this month, last month,
the month before, before that.
If someone out there knows what the heck I'm trying to say here (I'm crap at
explaining) I'd appreciate ANY help on this matter.
Thanks.
At work I have a workbook which each worksheet contains details of 1
individual job. So one worksheet = all the labour, rates & material purchases
of 1 job.
So, I created a template which I open upon getting a new job. This is all
fine.
Now I want a summary page within the workbook, which pulls all the
information from the job worksheets.
For instance I'll have
Hours
Current - 1 Month - 2 Month - 3 Month - Previous.
So in the 'current' cell it will have all the info pulled in from the
worksheets and it should automatically seperate into this month, last month,
the month before, before that.
If someone out there knows what the heck I'm trying to say here (I'm crap at
explaining) I'd appreciate ANY help on this matter.
Thanks.