Hi everyone! I have a problem that I cant solve so ill try to explain
I have 2 collums, one with Names or Ingredients, and another with a number values.
I need a macro that analices this information, pick the lowests values, and generates a new table with all the ingredients below, lets say, 75, BUT the total sum of it must not be more than 75.
so:
- create a table with:
- lowest values of ingredientes (and the ingredient name) in crescent order(<75)
- untill the sum reach 75, so the table must stop creating itself when the sum its 75 or more.
i dont know if i explain myself good, so let me know and ill try to explain it better!
regards!
Bookmarks