How to substract values in one column from another in every possible combination?

Hi everyone!

I'm pretty new here and I have a problem that I need to solve... I'm not really good with Excel (2007), which means that the first time I have read the word 'macro' was 2 day ago when I began searcing for a solution for my problem.

So, basically I need a macro that can substract every value in a column from every value in another column in all possible combinations. For example:

A column

1
2
3

B column

4
5
6

C column

(A-B in every combination)

1-4 = -3
1-5 = -4
1-6 = -5
2-4 = -2
2-5 = -3
2-6 = -4
3-4 = -1
3-5 = -2
3-6 = -3

Of course C column is only showing -3, -4, -1, etc... And I have more values than three in each column (from 6-30).

I would really appreciate your help. And please explain things to me very simply, I'm not really good with computers.

Alice

Thank YOU very much!!! I think it works!!!