Hello friends, I have inventory xls file, I have Input, Inventory and stock sheets, I enter data in input sheet it automatically add to inventory sheet. But I want to link inventory sheet to stock sheet If purchase word is in the cell it should add to stock sheet and if sell word is in the cell it should subtract from the stock sheet. Pls help.....
Bookmarks