jam3scoles
New Member
- Joined
- Jul 19, 2016
- Messages
- 1
Hello all,
I am trying to populate another worksheet based on a worksheet that is given the month and the year. I then want worksheet 2 to count this data and fill in the months and how many projects should be live within that date...
Worksheet 1:
[TABLE="width: 200"]
<tbody>[TR]
[TD]Go-Live date[/TD]
[/TR]
[TR]
[TD]January (1)[/TD]
[/TR]
[TR]
[TD]March (2)[/TD]
[/TR]
[TR]
[TD]August (3)[/TD]
[/TR]
</tbody>[/TABLE]
So this is each individual project that has its month and then what year (year 1= 2016)
Worksheet 2:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Target[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]January[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Febuary[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]March and so on[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]Janaury and so on[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2018 [/TD]
[TD]Janaury[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Febuary and so on[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet 2 then populates the target within each month of each year?
Any help would be really appreciated
I am trying to populate another worksheet based on a worksheet that is given the month and the year. I then want worksheet 2 to count this data and fill in the months and how many projects should be live within that date...
Worksheet 1:
[TABLE="width: 200"]
<tbody>[TR]
[TD]Go-Live date[/TD]
[/TR]
[TR]
[TD]January (1)[/TD]
[/TR]
[TR]
[TD]March (2)[/TD]
[/TR]
[TR]
[TD]August (3)[/TD]
[/TR]
</tbody>[/TABLE]
So this is each individual project that has its month and then what year (year 1= 2016)
Worksheet 2:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Target[/TD]
[/TR]
[TR]
[TD]2016[/TD]
[TD]January[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Febuary[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]March and so on[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2017[/TD]
[TD]Janaury and so on[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2018 [/TD]
[TD]Janaury[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Febuary and so on[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet 2 then populates the target within each month of each year?
Any help would be really appreciated
