Dear Sir,
First of all I am not at all aware of VBA, since my actual file is with huge data I shall not be able to handle, second I clearly mentioned my desired result in my file, if you pls tell what more do you need, I shall again try to explain.
Dear Sir,
I don't know how should I have to proceed further.
Forum Rule : Cross Posting - I apologized for that, what more should I have to do ? After all I can't hold anyone's leg for this
Misunderstanding : I mentioned in detail against Mr. AlanSidman's post with an example attached, and I...
Dear Sir,
Thanks for your reply, see there is little misunderstanding. My desired result is not only based on source data, it based on the today's stock also, suppose if today's stock of guava is 150(I3), then in the calculation field (J3 to Q9, Yellow highlighted red font) is changed based on...
Dear Sir
You are absolutely right, we were needy for the solution, and were not getting solution that's why i told him to post. And for that I apologized. Now tell me for that am I not eligible to get the solution ? If so, I shall not post anything further against this issue
Dear Sir
You can do anything, you may delete my post also, you may cancel my membership also, but sir my life will not stop, if I don't get a solution that does not mean everything will be stopped. However, for your last query I can say if required / needed I use end number of doctors for my...
Yes sir my hubby posted that, I beg apology for that, but pls let me know one thing if I suffer from a disease & I can't get it treated properly by a doctor, shouldn't we go to another doctor ?
Dear All,
The attached file's H1 to Q9 is my existing result, where FRUITS are data validated & Stock Qty is manually entered.
Problem is now my result sheet is changed (D13 to J16), where D & E columns are existing figures & others are my desired results which would be formula based. It means...
But result is not coming Sir. I gave a screenshot of your file when I changed criteria data. Even when I am changing fruit then also result is coming wrong. I don't know what am I mistaking.
Dear Sir,
First of all am not an actor, a house wife & an employee, hence if you think it is a monologue, then I feel proud to be an actor as in my country actors earn huge amount. (LOL)
Second, I stated multiple times what result I need. I need not any more column or date. Refer post #24. In...
Dear Sir,
1) I am appending a file with more detail in the worksheet. Hope it will help you to understand what I need.
2) I don't know anything about binary file, in case your file helps me, am in dark how can I implement that in other file also. Though it's secondary matter.
3) If you need more...
Dear Sir,
Requesting you please check my file, I need that result only that I highlighted in yellow, if I put Stock 232, date 31-05-19 & fruit apple manually. but not getting sir.
Sir,
Misunderstanding. my desired result is in yellow in my file sir which would be based on the criteria which I highlighted in blue. But in your file it is not reflecting Sir.
As I want to know which invoice, which date, & which supplier's stock is lying on that particular date. From that I can calculate how many qty & how many days stock is lying.
Sir,
You are absolutely right.
Green - my purchase history
Blue - The Data that I shall put manually (Fruit Name, Date, & Stock Qty)
Yellow - is the result that I need.
But it would be on FIFO Basis. As you can see that I consumed / sold full qty which was purchased earlier, based on the stock...
It would be in the last Row if I put stock 445 manually
like this in yellow highlighted Area
STOCK DATE
31-05-2019
FRUIT
STOCK
SUPPLIER
INV NO
DATE
QTY
RATE
APPLE
445
SOM
35/59
17-05-2019
192
11.5
GK TRADER
15
19-05-2019
252
10
SM
102
43564
1
12