Better way to transfer data my way taking a long time

**welchs101** · 09-05-2011, 06:34 AM

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?

**welchs101** · 09-05-2011, 06:47 AM

forgot to add something to the output sheet......

**welchs101** · 09-05-2011, 06:52 AM

it should run now......

**jaslake** · 09-05-2011, 05:43 PM

Hi welchs101

The attached contains over 1500 recipes and takes less than 5 seconds to complete (granted...they're the same recipes and don't have 500 ingredients).

I've not modified your code significantly...commented out some lines that made no sense to me...added a few lines to give functionality I thought was necessary.

You've got a bunch of Functions going ...don't know if more direct methods would be better or not...just don't know.

Anyway...on my platform with 1500 plus recipes this is not an issue

the subroutine "put_ingredients" this takes a really long time

**welchs101** · 09-06-2011, 06:03 AM

thanks! i have not had time to look at the code to see whatyou did yet but i will try and get to it today after work. thanks again i really appreciate it!!!!!!!!!!!!!!!!!