I have been trying to create a stock sheet for a friend of mine & got stuck on few things.
1. Not able to change date to dd/mm/yyyy format on Product Received & Product issued worksheet. In turn, want it to show the month through formula in next cell.
2. Is there any way, to show Present stock status in product issued sheet for the item in question. I tried SUMIF formula but must be doing something wrong as it doesnt pick data for current product item selected.
3. Wish to display all the items in the dependent list by selecting the value in the main list on Stock report sheet. This can be done using Vlookup & indirect function that i have googled so far but not able to apply it correctly.
Attaching the file for the reference. Any help or a clue will be much appreciated.