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