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
Bookmarks