I need to compare the worksheet names in Workbook A with a table in Workbook B. If the worksheet name exists, I need to see if there's an entry in the next column of that table. If nothing, leave as is but if there's something, then I need to replace the worksheet name in Workbook A. Is this possible?