Creating a New dataarray from an existing datarray after calculations take place

Folks I will have a two dimensional array (lots of rows and lots of columns) from a data dump.

1)I first have to load a data dump into a data array.
2)Then put the value of each row of data (example: 10,30,34,50,234,554,3334) into another sheet where a series of user-defined calculations will reference this data.
3) Each "row" of the data array will be used in a calculation. These cells will be offset by a certain amount.
4) I want to copy the result of the calculation and then store them all into another data.
5) After I have populated a NEW data array, I want to paste the contents into another sheet.

This isn't the most efficient method of doing this but I have some institutionally binding reasons for doing it this way. I have the following code, and I am hoping if you can all help me through this.

My initial strategy: Have two loops. for each row of the array dimensions (There will be thousads) take the contents and place them in another

Please Login or Register  to view this content.

Any help would be much much appreciated.

Patel45,

Thank you for the suggestions. The original array is set. As per the link you provided, which i referenced earlier, I have set the initial data array. The issue s all of the other components:

Namely, the new data array (the result of the calculations), will not have the same dimensions as the original data array. so for instance the original data array could have 5000 rows and 20 columns but the resultant calculations could product 5000 rows and 50 columns. The calculations will be user defined and will change. Thats why the loop needs to be set but the calculations can be done later.

If you have any suggestions for taclking that issue