Re: If value match of textboxes then overwrite the value of column(N)

[HaroonSid]

hi,
i am sending data to my sheets using textboxes

for example

if textbox1, textbox2, textbox3 and textbox4 value match with sheets value then overwrite the data of textbox5

textbox1.value = "N"
textbox2.value = "MASTER"
textbox3.value = "PB"
textbox4.value = "FBC"

and textbox5.value = 151 then change only value of Column(n) = 151 instead of 150(this value were before in column(n)

1.JPG
thank you

[HaroonSid]

This is my original code to send data sheet

Please Login or Register  to view this content.

and change this one to avoid duplicate entry, i apply this only textbox2 and its working ok, now i also want to apply this code to textbox1, textbox2, textbox3 and textbox4

Please Login or Register  to view this content.

Please Login or Register  to view this content.