So, as per attached file, I have list of stores in DATA worksheet. This whole page will be pasted into worksheet every time the sheet will be used.
I want this macro to tell me how many labels I need to print I need 1 label per 25 cases, so for example if I have 51 cases ordered per store I will need 3 labels printed. That will increase with every 25 cases that store will order.
My labels are saved in PDF file (1 store per page per label) so I dont need to know which store number it is but page that this store is on. Number of pages are represented by small digits in row 8, 11,14 for example. I need this macro to return information:
1. about how many labels I need for every store (given its 1 label per 25 cases)
2. number of page it is on needs to be multiplied in the same cell separated by comma
3. all of the numbers from all stores needs to be consolidated in one cell, separated by comma.
4. PDF can only allow 99 characters to be put in pages print option so it would be good if this string of data would be separated into strings of no more than 99 characters.
5. This is to be done in Summary tab after pressing the button.
Could anyone be of any help with this?
Bookmarks