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