I want to know how to do this nested loop in VBA, I just start learning how to do simple loops, but this one I really have a hard time to get it done.
So in the picture, the last line, line 23 is null, I want to use the back loop for each large cell, stop when every time column A reach "Order #", then take the Host number from column F, paste it in column M for each item.
The second picture is what I want.
Thank you in advance. If I can learn how to do this, it will help me do a lot of different things in the future.
1.jpg, 2.jpg