Yes you need a macro if you want to fully automate it and replace the old data. however it seems that column E is used for the new info, so maybe you could just set a formula that checks if there is a value in column E, and if so, then use that data rather than the original data.

ie =if(E1="",original calculation,revised calculation)

Matt