Copy Content to another sheet

[dzrdw0]

I have this code which works fine but now I want the "Quantity" to be copied to"Inventory" sheet after user entering the quantity on "Invoice" sheet. Thanks.

Please Login or Register  to view this content.

[snb]

You'd better use the change-event, not the selection_change-event.

Please Login or Register  to view this content.

[royUK]

Using either event leaves no margin for error. If an incorrect amount is entered that will still be transferred. I would use a button to click after input & checking

[dzrdw0]

Thanks. snb. it works well and RoyUK, thanks for the suggestion.