happychronicles
New Member
- Joined
- Nov 22, 2017
- Messages
- 5
Hi,
So my problem is I have a list of numbers... I have another workbook that I want the first number of said list in then to skip four rows with a formula that just equals A1. Then the next cell will get the next number from the list.
Source Workbook
[TABLE="width: 500"]
<tbody>[TR]
[TD]P[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
New workbook
[TABLE="width: 500"]
<tbody>[TR]
[TD]p[/TD]
[TD]t[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Thank you
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
</body>
So my problem is I have a list of numbers... I have another workbook that I want the first number of said list in then to skip four rows with a formula that just equals A1. Then the next cell will get the next number from the list.
Source Workbook
[TABLE="width: 500"]
<tbody>[TR]
[TD]P[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
New workbook
[TABLE="width: 500"]
<tbody>[TR]
[TD]p[/TD]
[TD]t[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Thank you
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
</body>
Last edited by a moderator: