Good evening all!
I have a range of data that contains text in column A and numbers in column B. I have attached a copy of the data set I am working with.
I am using this as a form to know how many labels I will need to print for each letter. So I not only need to know the count of each letter in each cell with that range but I also will need to take that number and multiply it by the qty associated with it in column B.
Ex. Cell A2 has the Contents...AM/AN. So there are 2 "A's", 1 "M" and 1"N". Then in column B the quantity shows 6 so I would take each of these values and multiply by 6 so I know how many labels I need for each letter in that cell and do that same for each cell in that range. I would then need to create either a list or a table that sums all of these values for each letter and shows me how many I need to have printed.
I am not shy about using VBA when I can and if it would make it easier and faster to run this process, then I would love to learn how to do that. I am familiar with associating a macro to an action button and running the macro and would like to do that with this.
Please let me know if you have any questions and I look forward to seeing your ideas!!!!