in my inventory file, i have arrival, consumtion, repack, sold...
in my WH sheet, i want to lookup or sumif but with 2 criteria data match, the code and the tarima... for example, in arrival sheet, the encoder input the code and the tarima ( where the stock was place), in WH sheet, i want to automatic add if the two criteria match, same as in repack sheet but it will minus in WH sheet.. also i need to link it to tarima sheet, so that i will know what tarima is empty or fulls.. i have attached the file.. tnxs
Bookmarks