MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel macro to fill cell with information in above cell

Posted by armando on November 26, 2001 12:13 PM

Does anyone know a macro to fill an empty cell with the identical data in the cell above it?

Please help, Thanks

Posted by Juan Pablo on November 26, 2001 12:40 PM

You don't need a macro, just select the range of interest. Press F5, click "Special", select "Blanks", type


and press the Up arrow, and finally hit control enter.

If interested, you should copy and paste as values.

Juan Pablo

Posted by Armando on November 26, 2001 1:21 PM

Tnanks it worked