PDA

View Full Version : Do nested loop, Find the host number in every cell and then paste



aguba
03-05-2019, 05:14 PM
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.
23835, 23836