Excel Auto Fill Rows with a formula based on length of previous column
Posted on 2013-06-20
I have an excel output created by a database. What I need to do is create a macro that will auto fill in a formula down a column to the length of the previous column.
N2 - N205 (can be varied length, exp. N2 - N602) Then place a formula in column O2 - O205