Macro what should be used to update the value of a cell ?

**deryits** · 12-11-2014, 11:16 AM

Please help me , I'm still new at macros . I want the value in cell " C17 " could replace the existing value in the column " L " sheet " DH ". Thanks for helping...

**SyracuseWolvrine** · 12-11-2014, 04:41 PM

Since you didn't specify what row on Sheet DH, Column L to replace, this will replace all values in that column. I'm also assuming that the data in C17 is on a different sheet, titled OriginalSheet.

Please Login or Register  to view this content.

Or to replace just 1 row ... in this example, Column L, Row 5:

Please Login or Register  to view this content.

**deryits** · 12-11-2014, 08:38 PM

Thanks for the advice, I want to update value at column L in sheet "DH", with value in cell C17, according value at A2 in sheet "Preview" (which using vlookup)