Do Until Loop Not Working

Hi All,

I have a macro that pulls rows from a tab called "Report" to the tab "New Employees" based on the value "NEW" in Column R. It also pulls rows to the tab "Existing Employees" based on the value "Existing" in Column S. Both of these codes work fine when I split them up into two macros, but when I combine them into the code below, only the "New Employees" tab gets populated; the "Existing Employees" tab does not. Can anyone help me figure out why I'm running into this problem? Thanks in advance for your help!

Please Login or Register  to view this content.

Hi
Without a sample of your Data , and / or a more fuller description, one can only make a few guesses.
This would be the immediate guess, I guess!

Please Login or Register  to view this content.

Alan

This forum can be very strict about putting code inside of code tags. You risk having your topic locked if you do not comply. Instructions for using code tags are in the FAQ.

Without a sample file, it is difficult to debug. I suspect that the "existing employees" tab is getting populated, but the results are way down on the spreadsheet (I cannot tell how many rows down it would start populating).

Edit: A moderator fixed the code tags thing, and someone else saw the same problem with the d and j variables not being reset between loops, so there you go.

Hello jjl287,

Welcome to the Forum!

The variables "d" and "j" still retains it value from the first Do loop. Reset them before starting the second Do loop.

Please Login or Register  to view this content.

Originally Posted by jjl287

.... Worked perfectly...

Yous welcome, gald we could 'elp
Thanks for the feedback
Alan

P.s. Please mark Thread as solved

ThreadSolved.JPG

Edit: think you may have done it already as i posted, things move fast (sometimes ) 'ere!