Is it possible to have a macro adjust to a certain row, specified by a date ?
Optimally, I'm looking for a macro that will look for the current month in Column A (i.e. September) and insert the formula:
IF(OR(ISERROR(MATCH(B1,'[Performance.xls]Manager'!$C:$C,0)),B1=""),"",INDEX('[Performance.xls]Manager'!$A:$G,MATCH(B1,'[Performance.xls]Manager'!$C:$C,0),6))< The formula pulls data from a static file that is updated monthly, therefore, I'll insert a CopyPasteValue macro so that the data is not lost with each new month >
Is there code that knows where to insert the formula according to date ? Guidance appreciated - Mark
Optimally, I'm looking for a macro that will look for the current month in Column A (i.e. September) and insert the formula:
IF(OR(ISERROR(MATCH(B1,'[Performance.xls]Manager'!$C:$C,0)),B1=""),"",INDEX('[Performance.xls]Manager'!$A:$G,MATCH(B1,'[Performance.xls]Manager'!$C:$C,0),6))< The formula pulls data from a static file that is updated monthly, therefore, I'll insert a CopyPasteValue macro so that the data is not lost with each new month >
Is there code that knows where to insert the formula according to date ? Guidance appreciated - Mark
ReturnData.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | $1:$301 | Agnos | Agger | Bison | Berk | Dom | Dirk | ||
2 | Name | ||||||||
3 | Feb-02 | 0.67% | 0.68% | 0.52% | -1.43% | -4.26% | 1.90% | ||
4 | Mar-02 | 0.20% | 0.19% | 1.25% | 3.71% | 2.12% | -0.80% | ||
5 | Apr-02 | 0.83% | 0.85% | 1.76% | 3.27% | 1.29% | 5.80% | ||
6 | May-02 | 1.01% | 0.91% | 1.21% | 0.21% | -2.17% | 1.90% | ||
7 | Jun-02 | 0.41% | 0.41% | -1.00% | -1.64% | -9.44% | 6.20% | ||
8 | Jul-02 | 1.07% | 1.07% | -0.25% | -4.27% | -4.19% | 4.30% | ||
9 | Aug-02 | 0.51% | 0.52% | 1.60% | -4.37% | 6.05% | 1.10% | ||
10 | Sep-02 | Manager'!$C:$C,0)),B1=]0.13% | |||||||
11 | Oct-02 | ||||||||
12 | Nov-02 | ||||||||
13 | Dec-02 | ||||||||
Sheet1 |