store data in memory array and then paste to sheet all at once

Hi all,

can I store data in an array in memory and then put that into a sheet all at once?
I've got a sheet that gets data from webqueries - the unique identifier is in column A and retrieved data is in subsequent columns.
For example:

in column A, from cell 2 down, I have a list of classes
'math, science, english, biology' etc
in columns B - F, row 1, I have student names
'jack, sophie, peter, janet, peter'

The webscrape will retrieve math scores for all students - I want to store those scores into an array in memory, then do the next webscrape (science scores) etc.
So in the end I'll have an array with data, that I just want to fill into the sheet all at once.

For reasons too complicated to explain, I can not put the data in the sheet every time I get the scrape result.

How would I go about and do this - seems to me like a simple 2-dimensional array, but I've got two challenges.
a) the order of the classes keeps changing
b) the number and order of the students keeps changing

How would I create an array so I know to put 'science' in the second row of the array and 'peter' in the 5th column of the array?
Any help is much appreciated!

OK, this works great, thanks a lot.

Now for another challenge - I put the same range in two arrays

ar1 and ar2

ar1 contains the values I want to put in the sheet, so I do that by saying: "Sheet3.Range("A5").Resize(Ubound(ar1), Ubound(ar1, 2)) = ar1"
However, the values in ar2, I want to put as cell comments in the corresponding cells.

Is there an easy way to do this, or will this be looping?

Thanks again for any assistance!

Hi JasperD,
I am not quite sure I understand your question. Cell comments are properties of range, so each cell has its own comment property. I do not see how to get around other than, I am afraid the dreaded word, "Looping". If you want to play with the properties and methods of a range, an array will not help as you need to access of each of these through a range. An array is simple a collection of data and these data share the same variable. It speed up the process of looping as these collections of data act as a single item in unison.