Could you please supply me with the VBA for the following: I have a formula that I would like to paste into a new month each month. So something for example I need to paste:
IF(ISERROR(VLOOKUP(CONCATENATE(YEAR($G30),MONTH($G30)),INPUTS!$A$8:$F$19,5,FALSE))," ",VLOOKUP(CONCATENATE(YEAR($G30),MONTH($G30)),INPUTS!$A$8:$F$19,5,FALSE)))) into April 2012 when today()>June 1, 2011.
If you could provide me with the VBA I would appreciate it. BTW, this formula is in cell H19.
Thank You
Tony
IF(ISERROR(VLOOKUP(CONCATENATE(YEAR($G30),MONTH($G30)),INPUTS!$A$8:$F$19,5,FALSE))," ",VLOOKUP(CONCATENATE(YEAR($G30),MONTH($G30)),INPUTS!$A$8:$F$19,5,FALSE)))) into April 2012 when today()>June 1, 2011.
If you could provide me with the VBA I would appreciate it. BTW, this formula is in cell H19.
Thank You
Tony
