filling up data in blankrows!

[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

 

[Ron de Bruin]

Hi

Use this
http://www.contextures.com/xlDataEntry02.html

 

[Dave Peterson]

Debra Dalgleish has a manual method (quicker) and code at:
http://contextures.com/xlDataEntry02.html

 

[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

 

[via135]

thks..RON, DAVE & GORD!

its really quite useful for me!

-via135