MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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


Juan Pablo G.