Hi, I have a huge excel file that has a lot of calculations. To help keep the file small and managable for updating, I want to just have formulas in one column that perform the calculations based on the current month. I then would like to make a macro that would copy that data to another column as values.
For example. Column G is my formula column. I open the file, select month Jan 2011, the formula column does it's thing based on data for that month, then I would like to have a macro copy that data as values into another column (Called Jan 2011). then next month, I select Feb 2011, the formulas update and the macro copys the data as values into another column called Feb 2011.
Is there a way to do that?
Thanks
For example. Column G is my formula column. I open the file, select month Jan 2011, the formula column does it's thing based on data for that month, then I would like to have a macro copy that data as values into another column (Called Jan 2011). then next month, I select Feb 2011, the formulas update and the macro copys the data as values into another column called Feb 2011.
Is there a way to do that?
Thanks
