I would like to carry a pattern across worksheets similar to using the auto fill handle between cells. My project includes the following formula on the second worksheet
=IF(F19=0,'JAN 31'!G3,SUM('JAN 31'!G3+IF(F19=0,"",(SUM(4-(SUM(G7:G19)))))))
and the following formula on the third worksheet
=IF(F19=0,'FEB 14'!D3,SUM('FEB 14'!D3+IF(F19=0,"",(SUM(4-(SUM(H7:H19)))))))
etc. Is there a way to "auto fill" the remaining worksheets to make them refer to the worksheet prior?
Bookmarks