filling up data in blankrows!

V

via135

hi!

i am having dates in A1,A4,A7,A10.
i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so
on!
is there any formula for filling up data in the above manner?

hlp pl?

-via135
 
G

Gord Dibben

Select column A and F5>Special>Blanks>OK

Now in the active blank cell type an = sign.

Point to the cell above and CTRL + ENTER to fill down.

You can then copy and paste special(in place)>values>ok>esc to get rid of the
formulas.


Gord Dibben MS Excel MVP
 
Top