Req for help - column comparison (wksheet2) and delete from worksheet1

[richardatkinson]

Hello,

I've read a few threads and I've partially solved my issue but it would be great if someone can help with the hard bit

I have a main/original worksheet1 - column A is the list of workstations
I have worksheet2 where I manually copy/paste the workstations in column A of worksheet1 and alongside in column B I have pasted an updated list of workstations.

Column B may not contain one of the original workstations in column A. I have identified them by adding a column C;
Column C = Found in A but not B (i.e. They do not appear because they have been upgraded)
=IF(ISNA(VLOOKUP(A2,$B$2:$B$65535,1,FALSE)),"PC Not Updated","")

Column B may contain a new workstation not in the original list column A - I have identified them by adding a column D;
Column D = Found in B but not A (a new workstation perhaps from storage has appeared)
=IF(ISNA(MATCH(B1,A:A,0)),B1,"")

I have attached a file. These are the actions for the macro
1) Column C in worksheet2 contains blank cells - these are the workstations that have been updated. The corresponding row for the PC name (e.g. London4 in Column A) in sheet1 should be deleted (e.g. sheet1 row 5).
2) Column D in worksheet2 contains the names of workstations that are new. A new row and the name of the new workstation should be added to column A in sheet1 (e.g. add London11 to the bottom row of column A sheet1 - no need to worry about what goes in the other columns)

Any help much appreciated

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[richardatkinson]

done and updated question