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.