Hello Friends -
I have Items(articles) and its unit of measure (uom) excel (extracted from system).
Now, I need to find the item and enter its respective closing stock. Can you please advise how I can perform that in excel.
Have attached a proforma, in excel.
Thanks in advance for your usual expertise support.
Hello,
Could you please specify how and from where should the closing stock be calculated?
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Hi! The closing stock is taken manually and need to be coded
Your item is duplicate in range.
Are you required unique item with sum qty.
If you mentioned required result its more helpful & clear ideas.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks Man!
The first name might come double; Example
Dilmah Tea Bag
Dilmah Coffee bags
Dilmah Green
It is short of information. Please manual input "before"and "after" table.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks