Iterative Macro Sampling

Question

Hi,

I am trying to make a sampling iterative macro, however it appears that it is not working properly (or at all really).

Basically, I have some rows with revenue and cumulative revenue. Then based on some generated rows, I would want to output the first cumulative sum number after the generated numbers which should iterate (hopefully). Iterations should stop when the iteration reaches the last row, currently it is just a hardcoded number, but I would like it dynamic - havent figured out how to do that yet either.

I guess the main issue here is that im not able to pass the data from the generated rows over to the filter tool which currently is a mess.

I have provided a minimum viable program to illustrate this.

Hope some of you can push me in the right direction or point out what I have misunderstood.

(I have solved this without macros, but im trying to do it with macro)

Thanks in advance!

sample_mc.yxzp

mceleavey · Answer

Hi @DenisZ ,

Thanks for jumping on the call, and glad I could help.

I'll post the workflow here as well.

M.

mceleavey solution.yxzp

mceleavey · Answer

@DenisZ ,

that doesn't really help!

You can't use a dropdown in an iteration, without it being the same through all iterations. You can't select a value in a column in an iteration because that value doesn't exist yet, so you are literally just selecting a column.

I'm not even sure why you're iterating.

Are you simply trying to generate the rows then create all possible combinations?

We need more information about what you're trying to do.

I'm free for the next 30 minutes if you want to jump on a call. DM me if so and I'll send you an invite.

M.

DenisZ · Answer

Hi @mceleavey Yea, I was trying to see how I could change the formula. Basically, each iteration I want a new row from the generated rows tool. There is probably a better way to implement it....