Rows in Excel

D

Daveb1oh

I want to place a date in a cell, then skip down 6 rows and have the next
date show...

Jan 1
Jan 2
Click to expand...
Jan 3

and so on with out having to insert row one at a time between each date.

Thanks
 
T

Teethless mama

Let's say Date in column A and header in row 1. Create a helper in column B
In A2:A100 (leave it blank for now)
Formula in B2 =MOD(ROW(),7)
copy from B2 all the way down to B100
Data > Filter > AutoFilter >filter the number 2
In A2 enter Jan 1
In A3 enter A2+1
copy all the way down
Remove filter and delete column B
 
V

vezerid

If you insert Jan 1 in, say, A2, then you can fill from A9 and down,
as far as necessary:

=IF(MOD(ROW()-ROW($A$2),7),"",A2+1)

And then:
Select Column A. Edit>Copy
Immediately follow with Edit>Paste Special...> Values

HTH
Kostis Vezerides
 
D

Daveb1oh

Tried both of them... did not work. But more than likely its me... missing
something
 
H

Herbert Seidenberg

Select Jan-1 and 6 blank cells below it.
Drag fill handle as far as desired.
 
D

Daveb1oh

Thank you that worked great... Knew I was missing or forgot something... WOW
Thanks again

Dave
 
J

JLatham

Sometimes the obvious, simple way is the best way?
Good of you to give Herbert the feedback.
 
Top