Forum Discussion
Help with formulas
HorseyAmanda OK, I've entered IF formulas in both D6 and E6 that will do (I think) what you want. I've left the D5 and E5 cells blank for now, but if you enter Y into either cell you'll see the result.
The minor modification I've made--and I think you'll need something like this--is I placed your "starting number" in the upper left corner, Cell A1, and then, depending on whether you have one or two batch numbers on this first page, you'll see that cell A1 on the NEXT spreadsheet starts with a batch number already incremented by one. So the same formulas put into that sheet's D6 and E6 will continue the pattern. (I was assuming that you're going to be using this same layout on subsequent sheets....)
mathetes Thank you very much for your help. It works very well but I was going to add more than one batch record per sheet. Each sheet will represent a week with a total of 53 sheets for the year. There is a potential of 28 batch numbers per week. So, I'm now struggling with the formula to carry the batch number to the next batch record. How do I populate L6 &/ M6 with the same rules. Again, thanks for your help, much appreciated
