I want to maintain a real-time stock quantity Excel sheet. The list of stock is entered in the Excel sheet. There are multiple columns in the Excel sheet named 'Live'. The columns are of quantity sold, issued, stock refilled, etc. I have tried using the formula 'vlookup'. However, that functions only for one sale of one day because it doesn't take up the next day's sale values of the same quantity (added in the Excel sheet 'sale'. In the vlookup formula, I am using the name manager formula for updating sales.
I have also tried using the 'Consolidate' option of excel by adding the sale of the next day in the same columns, however, the 'Consolidate' function is not working correctly and I am getting the current stock quantity in negative. Specifically, it is showing entries, 50% more than the actual sales (if I calculate it manually).
NOTE: ALL THE COLUMNS ARE TRIMMED, SO THERE IS NO ISSUE OF SPACING ERROR.
40 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹1288
Hi , i can build a custom software for you , which can work exactly for what you are looking in excel file. There you can have whatever custom functionality you want to add which is not supported by excel . thanks
Hola buenas, soy esperta en excel y lo puedo ayudar en su problema , se uso se uso de formulas por lo cual lo puedo ayudar en lo que necesita
I will be able to do this quickly and I'm ensure that it works very well.. look for high quality, fast delivery, suitable budget. I can provide all what you need. kindly msg me I'm ready to start right away..