Auto Fill with Info above

Posted by Armand on February 11, 2002 10:23 AM

I have to fill cells with the information above it. The information changes. I do not want to click and drag because there is a lot. Does anyone know how to do this faster.

Thanks

Posted by Juan Pablo G. on February 11, 2002 11:53 AM

Don't know if this is what you're after. In A1 you have the info that changes, in A2 (And drag down), put this formula

=A1

Juan Pablo G.