I have recorded the macro to consolidate the 3 columns and can run when I call it from the module. Now I wanted to call the macro or put the code inside the sheet using "worksheet_change(byVal target As Range)" so that I will not have to call the macro every time the sheet is being updated.
I'm afraid this has been addressed before but the code I have found from the threads were too complicated for me to modify. Can anyone help me with this?
here's the file https://www.excelforum.com/attachmen...1&d=1489046876
Bookmarks