Hello!

In the same folder I have 12 files which have in one sheet 1000+ rows with numbers in the columns I to Q. Each file has a different number of rows. I want to generate the sum of the numbers in each column (I to Q) and extract the sums from all the 12 files into a new file.

Example (the sums are not in the files I have, I've listed them only to explain what I mean):

File 1:
	1	5	9	13	14	15	16	17	18
	2	6	10	14	15	16	17	18	19
	3	7	11	15	16	17	18	19	20
	4	8	12	16	17	18	19	20	21
Sum	10	26	42	58	62	66	70	74	78
File 2:
	14	15	16	17	18	19	20	21	22
	15	16	17	18	19	20	21	22	23
Sum	29	31	33	35	37	39	41	43	45
File 3:
	5	9	13	17	18	19	20	21	22
	11	27	43	59	63	67	71	75	79
	1	1	1	1	1	1	1	1	1
	1	1	1	1	1	1	1	1	1
	15	16	17	18	19	20	21	22	23
Sum	33	54	75	96	102	108	114	120	126
Now I would want to only have the sums in a new file:

10	26	42	58	62	66	70	74	78
29	31	33	35	37	39	41	43	45
33	54	75	96	102	108	114	120	126
How would a VBA macro which does this, look like?

Thank you for your help!