RichieP
Rock on!
- Local time
- Today, 05:48
- Joined
- Apr 16, 2003
- Messages
- 48
Right then . . . .
I have a spreadsheet with a list of projects (in 'active' and 'on-going'), each project has a main title and many minor titles (sub sections). Each project will have a different number of minor titles. The user can then enter how many days they have worked on each minor part of the project each week.
When the work book is opened (or when a button is pressed) a different worksheet needs to be updated by project code and major title with the days summed up from the minor titles to find the 'total time worked' on each project by week. See the attached example to get an idea . . .
Any help would be appreciated so it automatically updates, thanks! The red writing is just added info to give you a better idea. The 'summary example' worksheet is how I want the 'summary' worksheet to look after the update. I need this to work for the time being in Excel but soon I'll use Access for this.
Thanks for your time,
Rich
P.S. I got some ideas from this thread but couldn't get it to work for myself . . .
www.access-programmers.co.uk/forums/showthread.php?t=112628&highlight=loop
Obviously without the inputbox
I have a spreadsheet with a list of projects (in 'active' and 'on-going'), each project has a main title and many minor titles (sub sections). Each project will have a different number of minor titles. The user can then enter how many days they have worked on each minor part of the project each week.
When the work book is opened (or when a button is pressed) a different worksheet needs to be updated by project code and major title with the days summed up from the minor titles to find the 'total time worked' on each project by week. See the attached example to get an idea . . .
Any help would be appreciated so it automatically updates, thanks! The red writing is just added info to give you a better idea. The 'summary example' worksheet is how I want the 'summary' worksheet to look after the update. I need this to work for the time being in Excel but soon I'll use Access for this.
Thanks for your time,
Rich
P.S. I got some ideas from this thread but couldn't get it to work for myself . . .
www.access-programmers.co.uk/forums/showthread.php?t=112628&highlight=loop
Obviously without the inputbox
