Hello all,

I am pretty new to macros and am trying to learn more and use it as I go.

I am working with a "mother" file that has month by month donations for about 100 individuals over the course of 5 years (so i have about 60-70 columns). I have created some analysis of these numbers such as sum and average donation with in the file.

What I want to do is write a macro to

look up a value and the formula from the "mother" file and repeat it over the course of the years in a new file.


I tried recording a macro, the problem is when I run the macro - it just duplicates the number from the previous month and does not look at the number for the corresponding month.
Jan FEB MAR APR
Sum 12 15 14 12
Average 4 5 3 6
Count 3 4 2 4


For example if the above is the mother file, with the macro I have now,

Jan numbers are repeated over and over again. How can I tell the macro to look at the next column and so on. Also, I can't see the macro to record more than one of the numbers.


THANK YOu FOR YOU HELP

Matthew