ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fill column blanks from last non-blank cell (https://www.excelbanter.com/excel-discussion-misc-queries/107336-fill-column-blanks-last-non-blank-cell.html)

C. BROWN

Fill column blanks from last non-blank cell
 
I have long columns that i want to fill using the last non-blank cell as the
fill. is there a macro or command that accomplishes that.

CLR

Fill column blanks from last non-blank cell
 
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will fill all blanks down a column with the value just above the
blank range if maybe that will do you....

Vaya con Dios,
Chuck, CABGx3



"C. BROWN" wrote:

I have long columns that i want to fill using the last non-blank cell as the
fill. is there a macro or command that accomplishes that.


evan

Fill column blanks from last non-blank cell
 
Have you seen the post immediately before yours: Fill Down...with a twist?

"C. BROWN" wrote:

I have long columns that i want to fill using the last non-blank cell as the
fill. is there a macro or command that accomplishes that.



All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com