Auto-replace a cell's formula with its value

I want to: automatically replace a cell (that has a formula) with its value the moment the cell becomes non-blank.


For example, I have three columns B, G, M with formulas in them. Each cell in these columns are blank until their row's cell in column A is filled out.

When A2 is filled out - B2, G2, and M2 will show a value and no longer be blank. At this moment, I would like B2, G2, and M2 to instantly replace themselves with the calculated value, so that they no longer contain formulas.

I do not want to click a button or perform any action to accomplish this, other than filling in A1. This should work when I fill in A2 and A5, etc.


As I understand it, this requires VBA. Thank you for any help you can provide me!

Can be done..

Please attach your sample workbook..

Here!

Right click on the sheet and select view code & paste it there

Please Login or Register  to view this content.

*Your workbook is currently .xlsx. You will have to save it as .xls or .xlsm to store the Macro

Glad it helped!

Please mark the thread as solved..