Macro/formula to work out number of labels

[poodek]

Hi,
Not sure if this could be sorted out by macro or formula. If this is possible with formulas only, please could you move it to other category.
Some background info about worksheets:
1. CASES SUMMARY – this will always be pasted keeping the same cells and format, so for example line 9 will always contain Store No and Line 10 will always contain Cases ordered. Also page 1 will be finishing with 49 line and another one will start from line 50 and finish on line 98.
2. DATA - this will be pasted every day so information will be changing as well.
3. SUMMARY – this tab will contain template that will consolidate data from 2 previous worksheets and return information I need.
What I need:
I need Macro/formula that will tell me how many labels I need assuming that for every 25 cases ordered (in CASES SUMMARY worksheet) I will require 1 label. I need that information to be returned in “D” column in SUMMARY tab. For example now for store 79 I will require 3 labels, for store 130 I will need 1 label, store 181 will need 3 labels and so on. I also need to know how to change this setting so if I need to assume I need to print a label for every 50 cases ordered.
If macro is needed for this could that be worked out by button in SUMMARY worksheet.
Thanks in advance for help, please ask if you need any other info.

[AlphaFrog]

In your example workbook on sheet Cases Summary there are hidden numbers below each Cases Ordered row. What are those numbers and are they a regular part of the pasted data set?

If those hidden numbers are not part of your normal data, this formula would work. Put it in D3 and copy down...

Please Login or Register  to view this content.

Note the Criteria range (red) is offset by one row from the Sum range (green).