HELP! I have a Spreadsheet in which Columns F & G retrieve the Month (F) and Year (G) of the date in column E.
The formula is as follows:
=IF(ISBLANK($E2),"",VLOOKUP(MONTH($E2),Months,2,FALSE))
Problem: Spreadsheet lags due to Formulas sitting in cells of COlumn F & waiting for a value to be inputed beside them.
What I need: I want to remove the formulas i have in columns f and g and have a vba code that will populate F & G with this formula =VLOOKUP(MONTH($E2),Months,2,FALSE)) for every cell that is not blank in COlumn e.
Meaning,
If E2 is blank, then no formula in F2 or G2
if E2 is not blank, F2 & G2 calculate Month and Year (Respectively).
for every row in my range...
Gracias in advance!
PS- I have a dynamic range that auto arranges itself, so the code could be to just apply it within that range when ever a change is made to the worksheet? (i could be way off, just a suggestion).
Bookmarks