Copy/Paste based on matched value that will change every second or so?

[vbagivesmeaheadache]

I'm in over my head with VBA! Please help.

I have a model with two paths. It iterates column data through one of two models based on values (I successfully VBA'd this part: go me! It took me 12 hours: oh no!)
I have two rows at the top of an output sheet that contain the current output of each model. As the inputs change about every second, the outputs do as well. (about, because the data isn't so that every-other column goes to one model or another, three could go to model 1 and then 5 could go to model 2 and so forth).

What I want is VBA to repeatedly look at cells AO3 and AO4 (since they will be updating as the model runs), find the corresponding values in AO6-AO35, and paste the values of the output in the correct row. AO3 and AO4 will always have the correct segment ID number--those change as the outputs change.

Screenshot for clarity..
I've not attempted to write any VBA for this yet because I can't find anything that matches and iterates and pastes.

Does anyone have any advice or code to point me to?

 

[vbagivesmeaheadache]

the AO3 and AO4 values and rows are directly linking to output cells from the models, which are excel formulas in other sheets. I can't influence that part, but I need to call those cells over and over again as the models iterate.

 

[vbagivesmeaheadache]

Ah, I solved it. Thank you!