Manhour Template setup procecdure

[goodguytoo]

Engineer by trade. We often use excel for manhour preparation. open ended question.

We might have 3 submittals, 5 tasks per submittal, 5 people per tasks. So that would be 75 rows. and then columns going out by week for 52 weeks. We then input hours by person by week. and then want to see the total hours by person, task, submittal etc.
We often just set it up with sums and move on.

Next time we might have 6 submittals, 10 tasks, 3 people.... so 180 rows and we would insert and delele rows, and copy and paste similar sections to accommodate the difference. requires so care to not mess up sum equations.

What would be ideal is if there was a way to set it up so that you could input the number of submittals, # of tasks per each submittal and # of people per each task and it would automatically set up a template for that.

Would this require VBA. Is anyone aware of any existing add-on that does this type of thing.
Looking for max fleixibility to handle any job setup we throw ad it that would reduce the manual manipulation required to set it up.

Thanks in advance.

 

[RayFrye]

 

[RayFrye]

SaveTobackup.xlsm
	A	B	C	D	E	F	G
1	Project 22			FW 26	FW 27	FW 28	FW 29
2	Submiittal #1
3		Task #1
4			Person #1
5			Person #2
6		Task #2
7			Person #1
8			Person #2
9	Submiittal #2
10		Task #1
11			Person #1
12			Person #2
13		Task #2
14			Person #1
15			Person #2
Blue 65

 

[RayFrye]

Something like the above? VBA Userform as input, created Worksheet (based on user Form) as output.