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

Dim arvar() as Variant
'arvar has two dimnesions 5000, 20
For i = 1 To Ubound(arvar, 1)
	For j = 1 to UBound(arvar, 2)
		'I want get the information and place it in the other sheet
		'calculations will be done, presumable throught the Application.Calculate		

		thisworkbook.Sheets("Sheet1").Range("C4:C" & (4 + UBound(arvar,2) &).value = arvar(i,j)
		'I want to place the arrays in certain data range
                'then recalculate
		Sheets("Sheet1").Calculate
		'then another range will have new calculation results which i will want to copy
		Range("E4:E20").Select
		Selection.Copy
		'Now I want to put add this into a new array that will progressively
		
	next j
'now I want to move to the next row of the column, and do the whole processs over again
next i

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