Moving formulas in a cell based on date entry ?

Hello everyone. I have the following situation. I have written code [please see below] which places formulas into specific cells within a workbook.

Please Login or Register  to view this content.

This sort of works, but not really. You see I need the placement of the formulas to be dependent on a global variable fDate. Without loss of generality the formulas are in the range "G29:G63". Now, I have a global variable fDate which is determined by the user entering a date in the following format dd-mmm-yyyy for example 30-apr-2010. Within the range "E27:P27" are the months of the year 2010, where E27 = "January", and so on. Here is what I need to happen, but I am clueless as to where to start. If for example the user enters in the date "fDate = 30-apr-2010", I would like to put the formulas into "H29:H63" I also need to copy the range "G29:G63" and paste-special-values back into the same range, "G29:G63".

If I understand what you're doing, you're rolling forward for each month. You want to pastespecial the values in column G, then accumulate totals again in column H:

Assuming you have a cell named "fDate" where the date is entered.

Please Login or Register  to view this content.