Fill down to next value

[RomanGriffen]

I made column D because I thought it would help. What I would like to do is: fill down to the next value in column D but I want it stretched across multiple rows. I would like to fill down in D-M but stop at the next 1 in D and then of course repeat until finished. Please help. File is attached.

[nathansav]

Please Login or Register  to view this content.

[RomanGriffen]

thank you for your reply. Rather quick reply at that! That fills the value down in D. I would like the values in E through M to fill down as well. I put column D in because I thought it would aid in the creation of this macro. As you can tell, I haven't a clue.

[nathansav]

What would you want to fill down in E to M though, should K6 be B Creed?

[RomanGriffen]

No. In all the columns (in this case K) I want the first line to copy down. So in K I want 3UF NW2L to fill down to K8. In I ....I want Claiming to fill down to I8. Etc...

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[RomanGriffen]

I do believe that does it, Mr. Davis (fellow Jersey boy). If I may be so bold, may I run another question by you regarding the same sheet?

[JOHN H. DAVIS]

What's the question?

[RomanGriffen]

here is the same sheet with a minor difference in column L. You'll see in column L that there groups of numbers. I would like the highest number of each group to display at the top of each list in that blank. An example being a 4 in L1. An 8 in L9 etc....... Possible? Here is the new sheet (Examp3) on this post.