If less than 100% then cells equal

[Smurfit-Stone]

I need a formula to move data from one sheet tab to another. I have a spreadsheet with weekend as tabs. I need to move data forward to the next week (tab) if its (column F) is less than 100%, then I need to carry the info to the next sheet. Something like If (Oct 28'!D2:D7 <100, then Nov 4'! D2:D7=Oct 28 (D2:D7) I know this is wrong....but something like this. Thanks!

 

[tactps]

How about:
In 'Nov 4'!D2
=if(sum('Oct 28'!d2:D7)<100,'Oct'!D2,0)
and copy down.