Sorry, ignore the previous mail.. pls find the attached one...
On Tue, Jan 11, 2011 at 12:20 PM, Manoj kumar < manoj.vishwakarma...@gmail.com> wrote: > 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
