filling up data in blankrows!
 

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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=503029

filling up data in blankrows!
 

Hi

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"via135" wrote in message
...

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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=503029

filling up data in blankrows!
 

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

via135 wrote:

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

--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=503029

--

Dave Peterson

filling up data in blankrows!
 

Select column A and F5SpecialBlanksOK

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)valuesokesc to get rid of the
formulas.


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 13:21:47 -0600, via135
wrote:


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

filling up data in blankrows!
 

thks..RON, DAVE & GORD!

its really quite useful for me!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=503029