Macro to copy and paste row if macro detects movement

which cells can be edited to cause this action?

i am having this code

Please Login or Register  to view this content.

now id like to copy only column d through h and paste only the values

change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

where x represents the row number.

Without additional information, this is the best I can offer

Originally Posted by 1800builder91

Hello. I need a macro to copy and paste a row to another sheet. For Example: If i edit cell d3 then the macro detects cell value or text changes and copies a3:k3 to another sheet in the same workbook

Maybe like this not test

Please Login or Register  to view this content.