I need an Excel Expert
Budget: ₹600 – ₹1,500 INR
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.
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.