hi everyone! is it possible to integrate the "Find" tool in cells of a worksheet when its reference are the worksheets of another workbook and automatically display the detail of it. e.g. workbook1 is the reference which have 3 worksheets wherein have a unique item name w/ its corresponding description; workbook2 is composed also of classified worksheets in which during type completion of the item name the description will automatically display on its corresponding cell.
Bookmarks