Hi Experts,
I have dates in the format dd-mmm-yyyy in Column "E" and Qty (Nos) in Column "F". In user form, text-box on inputting the required date, I need the sum of qty to be calculated with respect to all dates in range "E" and the Sum Qty in a msgbox.
Pls help.
Try this...
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks a lot. Working Perfect.
If I would like to derive the result for a selected period, I have another Userform with two text boxes Start date and End Date. How do I go about? Thanks in advance.
You may want to create another thread for the 2nd part of your inquiry. I don't know when I'll have time to look into this for you....by creating a new thread, more people will have an opportunity to see your thread and try to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks