Need to find the row number for a particular record to edit

[SMILE]

Hi
I am attaching a file.
This is to create a membership data for an group.
I have the data in the sheet "DATA" . The new data is adding through the sheet "ADDNEW" . It is working perfect.
I need help in editing any record by calling Membership no. in F5 in sheet "EDIT".
After I edit the record, I need to replace the record in "DATA" sheet.
I tried a lot to code it but I failed in finding the row.
Can someone help me.
Thanks

[zbor]

You can add in your cuurent sheet:

Please Login or Register  to view this content.

If it's existing Membersip ID then it will overwrite it. If not it will add in next row.

[SMILE]

Hi zbor
I tried edit my code and I am getting the following error.

Run-time error '1004':
Unable to get the Match property of the WorksheetFunction class

Its working for existing ID, but getting error for new entries.
I am attaching the file with the modification, if you can look on it.
Thanks

[zbor]

Here, try this: