Hello everyone. I need some advice in handeling a large amount of data in excel. I shall describe this quickly: I have a list of 420 stocks. For each of these 420 stocks, I have prices, currency, volume and several other types of data, for each day drom 01/01/2009 to 31/12/2013.

That is a lot of data.

My purpose is to summarise all this data to be used for some useful calculations. I'm not talking anything too complicated, just for example, getting the average price every stock on the list for those 4 yearsof trading. Or, another example, making a colum in which currency and volume are multiplied. Again, for each stock, for each day.

So the problem here is how to actually make these small, but numerous computations, and how to best organise the data so that it's easier to make those calculations.

So far, I have two files: the first has all the dates and types of data in colums, for each stock, and there is a 1 blank colum gap between each stock, and this carries on to the right side of the sheet. Everything is in one sheet only.

The second file has each stock's data seperated by tabs, with the name of each stock on the tabs (although, I can just have the tabs be sheet1,sheet2,etc).

Question 1: Considering the type of calculations I need to preform (mostly basic maths), which of the two file arrangements should I use so it is easier to programme macros?

Question 2: Given the fact that I have no idea how to actually code VBA or make macros that would fit this dimension of data, what would you suggest as an automatization system? For example, I was thinking if it was possible to mirror the actions done in one tab os data to ALL the other tabs in the file. That way, I could work only on one tab and then have all the actions already replicated in all the other tabs.

Thank you very much for all the help!!