You could record a macro to filter on blank in coloum A then paste a formula
+cell above- this would then fill in your blanks
--
Thanks for your help


"Justin" wrote:

Hello,

What I'm trying to do is automate a process using an excel macro. What
I need the macro to do is to look for a blank cell in a range of data
in Column A, and whenever there is a blank space within that range,
paste some specific above information into this row. (I'm formatting
an excel file after taking it from another program). I would greatly
appreciate any help!

Thank you!
.