View Single Post
  #1   Report Post  
cindi
 
Posts: n/a
Default Function question

I have external sheet references in a worksheet and I
want to copy the formula's, but can't figure out how to
do it. Can you help?

Column A
='healthcare'!c9
='healthcare'!c14
='helatchare'!c19
='healthcare'!c24

and so on....

What function of Excel can I use to copy the formula down
and skipping every 5 cell references? Is it possible? I
have tried to "Fill" it, but with no success.