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)
<tbody>
</tbody>
Need (Sheet2)
<tbody>
</tbody>
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)
Customer | Item | Type |
Pineapple | Cup | Beverage |
Banana | Bowl | Meal |
Strawberry | Plate | Meal |
Mango | Spoon | Meal |
<tbody>
</tbody>
Need (Sheet2)
Customer | Item | Type |
Pineapple | Cup | Beverage |
Pineapple | Cup | Beverage |
Pineapple | Cup | Beverage |
Banana | Bowl | Meal |
Banana | Bowl | Meal |
Banana | Bowl | Meal |
Strawberry | Plate | Meal |
Strawberry | Plate | Meal |
Strawberry | Plate | Meal |
Mango | Spoon | Meal |
Mango | Spoon | Meal |
Mango | Spoon | Meal |
<tbody>
</tbody>
Last edited: