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
|