Iterative Macro Question

Is it possible to pull in the data that is considered finished and union it onto every looped data stream once it's deemed finished by your condition?

Something like this

My current filter condition to loop the data is when 2014 = end% and if it doesn't it subtracts the increment from 2014

-I ultimately will have more than just A,B adjustments. I could have A,B,C,D , etc. all with varying ending %'s

Results of current iterative macro:

2014	2015	2016	Start %	End %	Increment	Adjustment	Scenario
.35	.4	.4	.4	.2	.05	A	1
,35	.4	.4	.4	.15	.05	B	1
.3	.4	.4	.4	.2	.05	A	1
.3	.4	.4	.4	.15	.05	B	1
.25	.4	.4	.4	.2	.05	A	1
.25	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.2	.4	.4	.4	.15	.05	B	1
.15	.4	.4	.4	.15	.05	B	1

Results I'm looking for:

2014	2015	2016	Start %	End %	Increment	Adjustment	Scenario
.35	.4	.4	.4	.2	.05	A	1
,35	.4	.4	.4	.15	.05	B	1
.3	.4	.4	.4	.2	.05	A	1
.3	.4	.4	.4	.15	.05	B	1
.25	.4	.4	.4	.2	.05	A	1
.25	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.2	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.15	.4	.4	.4	.15	.05	B	1

Macros

Iterative Macro

Accepted answers

WestonProhaska

I was able to solve it using @FrederikE's suggestion.

Attaching my solution for the future incase anyone googles and stumbles upon this thread.

Test.yxzp

All comments

FrederikE

Hey @WestonProhaska,

Not 100% sure if I understand you correctly, but you could append the result data to the loop again and also add the iteration number. At the following iterations, you can always do the check if

org. Iteration Number = Iteration Number.

If yes, keep the data, if no delete it instead.

WestonProhaska

Hey @FrederikE

I'll attach an example of what I have.

Essentially, when I have one adjustment row that meets the criteria I want to have that record continue to show up in further iterations despite being finished.

IE: if I'm counting upwards

I have adjustment A that ends at 1

Adjustment B that ends at 2

Adjustment C that ends at 3

I want the data to look like this after the iterations get through the one counting the highest:

A1

A1
B2

Edit: I was able to get it to work up until a certain point, but it resumed dropping data.

Test.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703