Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
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!