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.
|