I am trying to copy the following formula:
=IF('Week 1'!$H7,2,"")
and paste it down a column and have to move over 4 columns each time. So when it pastes to the next row it would be
<colgroup><col width="64" style="width: 48pt;">
<tbody>
</tbody>=IF('Week 1'!$M7,2,"")
the next row would be
=IF('Week 1'!$R7,2,"")
the next row would the be:
=IF('Week 1'!$W7,2,"")
Is there any way to do this without having to enter each formula manually?
=IF('Week 1'!$H7,2,"")
and paste it down a column and have to move over 4 columns each time. So when it pastes to the next row it would be
the next row would be
=IF('Week 1'!$R7,2,"")
the next row would the be:
=IF('Week 1'!$W7,2,"")
Is there any way to do this without having to enter each formula manually?