copy formula every x rows
 

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

copy formula every x rows
 

Try this:

=IF(MOD(ROW(),4)=0,TEXT(H4,"yymmdd")&" "&G4,"")

It will put "" in column M for each row that isn't in your selection. If
that's not acceptable, let me know.

"andresg1975" wrote:

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

copy formula every x rows
 

With your formula in say M4 / M8 / M12 / M16

select M4:M19 (Note the cell is the last empty cell before you would next
have a formula, then grab the the little black cross at the bottom right of
your selection and drag down.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"andresg1975" wrote:

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

copy formula every x rows
 

THANKS A LOT

"Ken Wright" wrote:

With your formula in say M4 / M8 / M12 / M16

select M4:M19 (Note the cell is the last empty cell before you would next
have a formula, then grab the the little black cross at the bottom right of
your selection and drag down.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"andresg1975" wrote:

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

copy formula every x rows
 

THANKS A LOT

"Barb Reinhardt" wrote:

Try this:

=IF(MOD(ROW(),4)=0,TEXT(H4,"yymmdd")&" "&G4,"")

It will put "" in column M for each row that isn't in your selection. If
that's not acceptable, let me know.

"andresg1975" wrote:

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

copy formula every x rows
 

You're welcome :-)

"andresg1975" wrote in message
...
THANKS A LOT

"Ken Wright" wrote:

With your formula in say M4 / M8 / M12 / M16

select M4:M19 (Note the cell is the last empty cell before you would
next
have a formula, then grab the the little black cross at the bottom right
of
your selection and drag down.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"andresg1975" wrote:

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot