Help with selecting and copying non contiguous ranges

[dchard]

In Excel 2003 I have a spreadsheet that looks something like this>
2004 Units
Product Jan Feb Mar ... Total
ABC 1 1 2 4
124 2 0 1 3

2004 $
Product Jan Feb Mar ... Total
ABC 10 10 20 40
124 30 0 15 45

I would like to create a vb sub that allows the user to highlight the month column under the 2004 units section and will copy the formulas that are in the previous months column to the user selected column. I would also like the it to skip down to the 2004 $ section and copy the formulas there as well. So, user highlights the MAR cell under 2004 units and the procedure will select the Feb column for product rows (do not select the heading rows) in both the 2004 units and 2004 $ section and copy them to the MAR column. This is a forecast spreadsheet and I want the user to be able to run a macro/vb procedure that will copy formulas in that will link to actuals.

Thanks

Deb Chard