Hi Ramesh, Attached is the sample file for your reference.. hope it meets ur requirements to the nearest...
You simply have to put the total stock in cell A2 and the stock requirements for the respective Branches in the cells B2,C2 and D2.. etc. The values will automatically get updated in the highlighted summary(orange color)... I've used conditional formatting for indicating the Branch where the stock requirement is more(it will be highlighted in red color) and lastly, I've used a small macro to pop up a message whenever the total stock is less than the required stock. So, whenever the value in cell A7 is negative i.e less than 0 a message will pop up saying *"Your Stock is less than what is needed, Please Distribute Accordingly"*. Have a good day.... :)) Regards, Manoj Kumar On Sat, Jan 8, 2011 at 1:06 AM, Ramkesh Maurya <sunscel...@gmail.com> wrote: > Dear All, > > *Wish u a happy New Year -2011.* > > Can anybody help me in distributiing Stocks from Warehouse to Branches. > > For example current position of DEL Warehouse is > > *DEL Warehouse* *Noida* *Gurgaon* *Faridabad* 100 (20) > 50 (10) > > (Data in brackets is negative i.e. shortage in the Branches) > > Now I want to distribute the available Stock (in this case it is 100 in DEL > Warehouse) in Branches :- > > *DEL Warehouse* *Noida* *Gurgaon* *Faridabad* (20) > (10) > > I have allocated 20 to Noida and 10 to Faridabad but not allocated any > stock to Gurgaon as there is no Shortage > > *1-Please suggest me if there is any formule that can allocate quantity > itself in branches ?* > > Here a problem arises When I have not enough Stock In the Warehouse. > Suppose I have only 25 available quantity in Warehouse and demand is 30 ( 20 > Noida+10 Faridabad) then > > *2-Is there any method to consider the priority for Branches ?* > Thanks & Regards > Ramkesh Maurya > Cell: 9958723273 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Manoj - $$Excel-Macros$$.xlsm
Description: Binary data
