View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default 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