I have a Locator Workbook that has Shelf location in column A and Item Description in column B. I also have A Work Book that emplyoees use to place orders to my warehouse. Whenever we change a location we have to do it on both books, Is there a way I only need to do it on one workbook and it updated the other?