Forum Discussion
Seedling distribution
ms_mit Great you could get it to work. And what's 15 minutes for a job that would otherwise take perhaps a whole day of copying and pasting. Now that I look back at the query, I see I was over-thinking the matter by adding the Grouped Running Total. We can do without and it will probably speed up the process. See attached.
let me reach home and look at your post again so I can help..I am on the road taxi reading this Hope you have the excel file attached so I can take a logical look
HiDonald_Genes_ I have put a fresh copy of my Excel file here if you want to give it a try. As I mentioned below, My goal is to assemble the list of bags of tree seedlings on the left side of this worksheet from the data included in the 'Base Data' table to the right.I am still stumped about how to enumerate a list of Farmer Names according to the qty of seedlings each one gets and then further assign tree species in the correct number to that list and finally the qty of seedlings of each species that goes in eat bag. It becomes more complicated when there are multiple species in one bag. Any help you can give will be very much appreciated.
Ultimately, I have to run the final list through a mail merge to do a whole lot of labels but that is another subject.