Hi All,
Thank you for taking time to look over my excel challenge.
I have a compact data, which should be extended in a larger sheet. below are both charts. I have given first chart and I would like the second chart to be populated. Prefer formulas, but if it's VBA, that's fine as well.
Many thanks in advance
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Dep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63"]Emp ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000004[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Dep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64"]Emp ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000004[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you for taking time to look over my excel challenge.
I have a compact data, which should be extended in a larger sheet. below are both charts. I have given first chart and I would like the second chart to be populated. Prefer formulas, but if it's VBA, that's fine as well.
Many thanks in advance
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Dep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63"]Emp ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000004[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl161, width: 63, align: right"]10000010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl161, width: 118"]Dep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64"]Emp ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000002[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]Management[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000004[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000006[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000008[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl161, width: 64, align: right"]10000010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="width: 118"]TV[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]