Update if exist,otherwise insert

Hello dear members.

I got one situation and I will try to explain it.

I got excel file with two sheets (Sheet 1-Template, Sheet 2-DB). Template is used by manager who appoints yearly targets on monthly base. After state and approve the targets the data will be copy and pasted into DB. But sometimes manager can change targets after approve step.

In this point I need that if the data stated on Template exist on DB, Update, otherwise insert new lines. Actually I wrote code to insert lines but I couldn't write the proper code for check. Please help me on this issue.

Please Login or Register  to view this content.

Mohan.r1980 I am so grateful to you for your code, really appreciate it. Actually code works when I add targets for the first time. But if I want to update the previous data I got "run-time error 1004" and code shows the problem for

Please Login or Register  to view this content.

. Please help me to solve that problem.

Mohan.r1980 your code works perfectly. you'r are really so talented. Thanks a lot for your support.