Next non-blank cell

[Obfuscated]

I need a macro that will work through a range, find the first non-blank cell, put that cell's info in another cell, then continue from where it left off and find/record the next non-blank cell. And the next, and the next, until the range is completed. If A1 had "1" and A5 had "2" and A10 had "3" then record those ,say in C1:C3 "1", "2", and "3".
I can find the first cell, but can't continue where I left off to get the next.

[Kaper]

If you "can find the first cell" - why you haven't show how are you achieving it? Then someone could suggest the way further based on similar methodology.

If I were about doing that I'd either:
- check if next is non-blank (yes - use it , no - ese end(xldown) to find next
or
- use a filter to show only nonblanks and copy all visible cells within filter in "one shot"

[:) Sixthsense :)]

Why don't you fill those blank cells with the related value using goto method?

Refer the below link to know how to do it

http://www.contextures.com/xlDataEntry02.html

http://www.extendoffice.com/document...lue-above.html

http://www.techrepublic.com/blog/win...uick-and-easy/

[kvsrinivasamurthy]

Pl see attached file.

[Obfuscated]

That did it, thanks.