Compile Error: Expected End Sub

Trying to create macro the will search to match data on an entry tab with data on a tab called data. When I find a match, I want the contents of E25 to be posted to column O in the corresponding line on the data tab.

I keep getting the compile error. I originally called the macro option1. A friend helped with the code and he has it as worksheet_change. Can't seem to get it changed and working.

Thanks for your help.

Dcauth

Please Login or Register  to view this content.

You need to remove the first few lines:

Please Login or Register  to view this content.

Please use code tags when posting code per the forum rules.

Dom

You've got a sub with the Private Sub Worksheet_Change event in it. You need to delete one of them

Please Login or Register  to view this content.