Friends, Any update on this?
Thanks, AJ On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain <abhishek....@gmail.com>wrote: > Dear friends, > > Attached along a data wherein in some rows, quantity and amount for items > nos are both positive which is my inventory. > > In other rows one of the either or both are negative or nil. What I need to > do is to adjust the negative and nil values from the positive values > available for that particular item no. The macro should search for the > negative/zero values in quantity and amount columns and if it is found in > either of the column it should shift the available quantity/amount (with > rate) to the adjacent columns and in the rows from where the data is shifted > the row address of destination is written. > > An Example - > > At Row 16 - The quantity is 0 and amount is negative for item no. > 002001010001. Now for this item no., the positive values are available at > row no. 14. The macro should cut the Location Code, Quantity, Amount and > Rate (D14:G14) and paste it in H16:K16) and in D14 the destination row no. > is written - H16. (probably with different color). > > Hope some one helps me with this. This is a bit urgent. > > Thanks & regards, > > AJ > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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