Hi,
I have this file. In this file are basically two sheets i am using.
One of the sheets has recipes on it. I onlyl show a few recipes but there are hundreds. The other sheet is the "output" sheet and basically i am taking the recipes from one page and putting them on the other horizontally. But note......not all the ingredients in each recipe is teh same so i can just cut-n-paste.
Right now what i do is compare each ingredient from each recipe to the first row on the output page. If i dont find the ingredient then i add it. I also have to add the amount of each ingredient . You can look at my way in the code of the attached macro..........see the subroutine "put_ingredients" this takes a really long time and i am only putting "one" recipes ingredients cant imagine once i have hundreds...........
anyone know a better way?
Bookmarks