VBA to loop and fill blanks with data from left column if values exist in 3 cells?

[hopegriffin]

Hello gurus!

My data is organized in columns starting at Column E. Each column represents a class and the data is read left to right.
Sometimes in range E3:R4 the dates will be blank. Is there some type of loop that can fill blanks?

I attached my sample workbook with the original tab and desired result tab.
For example, the dates are missing from F3 & F4. I’d like the code to copy the dates from the column E, as long as there are class days in F5.

Sometimes the data could extend past column R. Is it possible for the loop to be dynamic?

I appreciate your help!

[jindon]

See if this works as you expect.

Please Login or Register  to view this content.

[hopegriffin]

Jindon,

Forum Guru indeed! Thank you so much---yet again you write such elegant VBA that works! Thank you!!

[jindon]

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.