hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

One way

Sub datesinaltrows()
mc = "d"
sd = InputBox("Enter start date, ie 7/4")
nd = InputBox("Enter number of days")
Cells(1, mc) = sd
For i = 2 To nd
Cells(i * 2 - 1, mc) = Cells(1, mc) + i - 1
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oldLearner57" wrote in message
...
hi community

how can i fill up alternate rows with a series of date that runs
consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

The fastest way is to insert a column, then put in the following formula and
copy it down.
=IF(B2="",B1,B2)

We are just say that if the cell is blank, use the value in the cell above
it, if not then leave it alone.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

hi
another way.
enter date 5/1/08in A1
enter next date 5/2/08 in A3
high like range A1:A4
place curson over lower right corner of selected area until curser turn into
a small black cross. click and hold. drag down as far as you want.

regards
FSt1

"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

10s!..it was wonderful, so easy yet so difficult if not enlighted :)

10s community
--
oldLearner57


"FSt1" wrote:

hi
another way.
enter date 5/1/08in A1
enter next date 5/2/08 in A3
high like range A1:A4
place curson over lower right corner of selected area until curser turn into
a small black cross. click and hold. drag down as far as you want.

regards
FSt1

"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

that seems not to work on my Excel 2003
;-(

10s! John Bundy, was interesting to know abt the formula
however
along the alternate row that was supposed to be blank, it shows some data
like 0-Jan

example:

A B C

1 01-May

2 0-Jan

3 02-May

4 0-Jan

able to use the formula, =if(b2="",b1,b2)
how can i remove the 0-Jan to have the alternate row with a Blank?

thanks for your great help!!

thanks community as well
--
oldLearner57


"John Bundy" wrote:

The fastest way is to insert a column, then put in the following formula and
copy it down.
=IF(B2="",B1,B2)

We are just say that if the cell is blank, use the value in the cell above
it, if not then leave it alone.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"oldLearner57" wrote:

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

hi Don Guillet, much appreciated for your assistance

thanks You

thanks community as well

:)
--
oldLearner57


"Don Guillett" wrote:


One way

Sub datesinaltrows()
mc = "d"
sd = InputBox("Enter start date, ie 7/4")
nd = InputBox("Enter number of days")
Cells(1, mc) = sd
For i = 2 To nd
Cells(i * 2 - 1, mc) = Cells(1, mc) + i - 1
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oldLearner57" wrote in message
...
hi community

how can i fill up alternate rows with a series of date that runs
consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

:)


--
oldLearner57

works in mine. apparently in oldLearner57 too.

regards
FSt1

"Jarek Kujawa" wrote:

that seems not to work on my Excel 2003
;-(

must have missed sth.

sorry

Jarek

Note to select A1:A4 so's you have a blank cell below both dates when you start
to drag.


Gord

On Mon, 14 Jul 2008 06:21:30 -0700 (PDT), Jarek Kujawa wrote:

that seems not to work on my Excel 2003
;-(