Excel macro to copy data from one sheet to another and create borders.
Attached is a workbook that has 2 sheets.
Match colum B Unc path with Other sheet or sheets colum A
And update Colum D name into colum E on all sheets
Color the cells in the UNC is not found in 1 or all sheets
Create borders in all sheets as shown in the sheet1.
Sheet names can be any
No of sheets can be 1 or more
Index naming for this sheet will be the same