aSSISTANCE WITH ROW DELETE BASED ON MULTIPLE VLOOPUP CRITERIA FROM ANOTHER WORKBOOK

[sintek]

Hi All

I have attached a workbook for your perusal. On Sheet 5 there is a button which allows a entry for a row no. When pressed, that row is deleted on Sheet 5. However what I need to accomplish as well is the following:

At the same time as that rows information is deleted, I need vba code to use vlookup to take information from that row on Sheet 5 and find the duplicate information on Sheet Temp and delete that row on Sheet Temp aswell.

Is this possible.

[sintek]

Been playing aroound but no luck...Any ideas

Please Login or Register  to view this content.

[sintek]

Hi All

Any possible feedback to get me on the right track.

[sintek]

Hi All

Have come up with this code and I feel that I'm on the right track. Please have a look and share your thoughts.
Code does not delete row on Temp Sheet though.

Please Login or Register  to view this content.

[sintek]

Guys...Eureka, I figured it out...

The code

Please Login or Register  to view this content.

must be after the 2nd End If Before Next