Looping on a multiple ranges of data

Hi, I'm relatively new to using VBA so this hopefully is a pretty easy question. I'm trying to get a macro to do a repetitive task on large set of data in excel.

I trying to write a macro that has the ability to run an excel formula on a set of data and paste the results somewhere then run the same formula one the next set of data a few rows down. I need this process to repeat a few thousand times so I was thinking some kind of loop but wasn't sure how to do it with having it loop on a different range of cells each time. I'd appreciate any help, Thanks!!

Hi Trent,

do you have any sample workbook to start with?

THanks
Lex

Hi,

Yeah, I have my working file with all my data and the formulas. I built a very rough macro to do the simulation on the entire set of data but there's no way I can use the same macro on different segments of the data. I know there's a better way of doing it, I'm just not as savvy with VBA as I am with excel. Below is an example of what I'm trying to write into VBA....
Capture1.jpg
Thanks for the reply

Trent