Hi,

I was hoping to get some help with a couple excel problems I am having. I have a range and I need to be able to add rows to the range, expanding it. I also need to use the SUM function for one column inside of the range that also needs to be able to expand as rows are added. The last thing is taking a different column in the same range with dates in it and making a formula that spits out the oldest date in the set. I have been searching different forums for quite a while now and I think I need to make a couple macros, but I have never been comfortable making them on my own so I was hoping for some guidelines to follow as I will have to apply the solution to multiple ranges.

Thanks,

Sarah