2 Loops. One loop within another.

[starcraftbud]

Hi, I'm mostly a VBA amateur. Loops are my particular weakness. Sort of a one trick pony.

I am trying to create a loop within an existing loop. One workbook has several sheets, lets say A,B,C, and D. I'd like to create a loop that starts with the first row in sheet A and loops through sheet B to find a match. If a match is found, data is added to sheet D. If no match is found or after the data is added to sheet D, I'd like to move to the row in sheet A and repeat until sheet A is a blank row.

Thank you for the help. I really have trouble with loops combined with if statements. I really do appreciate the help I get on this site.

Please Login or Register  to view this content.

[JBeaucaire]

This is how I would approach that, instead of looping through rangeB, I use the FIND command to jump straight to it. If these are dates you're searching for, you might need to edit the macro to use xlPart instead of xlWhole in the FIND command.

Please Login or Register  to view this content.

[JBeaucaire]

Did you try it?

[starcraftbud]

I've been trying to get it to work. I think conceptually I understand it and it makes sense. I mistakenly left out some code that is giving me trouble. The trouble is with this line:

Please Login or Register  to view this content.

I actually want to match up multiple values in Sheet A to values in Sheet B. So I need to do something more like this for that line (but we changed the ranges so its not working the same):

Please Login or Register  to view this content.

[starcraftbud]

But thanks for the help so far and for replying. I am going to play with it a bit more and if I figure it out, I'll be sure to post so not to waste anyone's time. Thanks again!

[starcraftbud]

I'm still having trouble getting this to work. Anyone have any ideas?

[Leith Ross]

Hello starcraftbud,

When all else fails, post your workbook for review.

[starcraftbud]

Thank you Leith Ross. I have posted the workbook. Tabs A, B, and D are what the code references. The goal is to have sheet D tie to sheet Final D after the macro has completed running.

On sheet B, I have highlighted the row which should match and trigger values moving to sheet D. Thank you for taking a look at this.

[starcraftbud]

I figured it out.

I ended up doing this:

Please Login or Register  to view this content.

Thanks Jbeaucaire for giving me at least an idea to make it work!