Sheet 1 holds all the information. Sheet 2 is going to be a kind of chart that I want to be auto created.
on Sheet 1,
Column A is the names, Column B is the Column # on sheet 2,
Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
this one is a tough one. I've tried a couple things but with no luck.
on Sheet 1,
Column A is the names, Column B is the Column # on sheet 2,
Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated.
Sheet 1
Ron | 1 | 1 | 5 |
Bruce | 1 | 7 | 2 |
Fred | 2 | 4 | 6 |
James | 3 | 2 | 3 |
<tbody>
</tbody>
Sheet 2
1 | 2 | 3 | |
1 | Ron | ||
2 | Ron | James | |
3 | Ron | James | |
4 | Ron | Fred | James |
5 | Ron | Fred | |
6 | Fred | ||
7 | Bruce | Fred | |
8 | Bruce | Fred | |
9 | Fred | ||
10 | |||
11 |
<tbody>
</tbody>
this one is a tough one. I've tried a couple things but with no luck.