tommiexboi
New Member
- Joined
- Apr 24, 2017
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello,
Need help! I tried searching google and the forums, but for the life of me I can't seem to find what I'm trying to look for.
I have a list of data in sheet1 and I'm trying to copy/paste each line into sheet2 on every 3rd row and then fill down the blanks. The list of data changes daily so I need it to loop until it reaches the end.
I created an example below.
I want to create a macro that can do this, your help will be greatly appreciated!!
Thanks,
EXAMPLE
Current (Sheet1)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Item[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
</tbody>[/TABLE]
Need (Sheet2)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Item[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
</tbody>[/TABLE]
Need help! I tried searching google and the forums, but for the life of me I can't seem to find what I'm trying to look for.
I have a list of data in sheet1 and I'm trying to copy/paste each line into sheet2 on every 3rd row and then fill down the blanks. The list of data changes daily so I need it to loop until it reaches the end.
I created an example below.
I want to create a macro that can do this, your help will be greatly appreciated!!
Thanks,
EXAMPLE
Current (Sheet1)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Item[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
</tbody>[/TABLE]
Need (Sheet2)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Item[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Cup[/TD]
[TD]Beverage[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Bowl[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Strawberry[/TD]
[TD]Plate[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]Spoon[/TD]
[TD]Meal[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: