Macro to copy data into blank cells

**santanuKD** · 12-15-2010, 02:04 AM

Hello all,

In the attached file the column A and B the there are data in the first row. Other columns has data.
Requirement here is that the data in the first row should be copied to the below blank cells till the data is available.
Please advice with any macro.

**johnjohns** · 12-15-2010, 02:39 AM

You require no macros
Do the following steps
1 Select the range “A2:B50”
2 Press Ctrl+G and go to -> Special->blanks
3 At the first active cell (eg A3), give the formula as ‘ =<upper cell>’ here (‘=A2’)
4 Strike Ctrl+Enter to save the formula in all the selected cells and you got the answer

rgds

johnjohns

**santanuKD** · 12-15-2010, 04:54 AM

This Helps and works perfect.
Thanks for the help.

Santanu

Originally Posted by johnjohns

You require no macros
Do the following steps
1 Select the range “A2:B50”
2 Press Ctrl+G and go to -> Special->blanks
3 At the first active cell (eg A3), give the formula as ‘ =<upper cell>’ here (‘=A2’)
4 Strike Ctrl+Enter to save the formula in all the selected cells and you got the answer

rgds

johnjohns