I need to write a macro that will take anything entered in column A of a worksheet titled Forecast, Range (A9:A200), and have it automatically entered onto the ccoresponding cell in column A on a worksheet titled Realized, range (A9:A200). But I have column A on Forecast filled with formulas dependent on other cells. So people will not be entering into Column A, but rather filling in J and K, which will populate column A. So when something pops up in column A, I want it to move to the Realized sheer as well.
I apppreciate your help.