Delete rows with macro - with an extra challenge

Hi guys,

I found this:

http://www.excelforum.com/excel-gene...s-not-met.html

My problem is on my sheet I have a User Login | User Name | Actions

It might be 1 user doing 10 changes. In that case the User Login and User Name will be in Row 1 and Row 10 but not in between. I was thinking of adding to the macro some kind of if statement to say if A1 = Admin and A2 = Blank then Copy A1 to A2 unless A2 is not blank

Will that work? Also can someone please help me with that :D

I did upload a test document.

So:

1. I have to get a way to add the names automatically in the blank space (in column User Login and User Name

2. I have to delete all record in Sheet 1 with the names in Sheet 2 (the name of the sheet is Names)

Thanks

To your question 1.

select the range and run the macro

Please Login or Register  to view this content.

Question 2
no name Sheet2 is matching with Sheet1,