Search results

@deb sure bro, i have learned a lot of thing from this Group and you too if any problem i will knock your door He he he... how was your week end, mine good

@smittal i am not sure why you want to display the 0 value in chart but as my knowledge i think it will not display the chart for 0 value please check attached file in Sheet2

@saints Try the below code if you want to delete the multiple results in the sheet2 Sub delete_B2() Dim LR As Long, i As Long If Len(Range("B2")) = 0 Then MsgBox " There is nothing to delete!", , "ALERT !" Else If MsgBox(" Are you sure that you wish to delete the content?", vbYesNo...

@SRINATH SOMAYAJI Welcome to Chandoo.org glad you are here, as a blind shot please try this =INDEX(B:B,MATCH($A1,A:A,0)) May be it solve other wise please upload a sample file Note: Ooops 3 minute late from SirJB7

@deb The Code works perfect, i have small doubt if we have two or more then it delete only first matched criteria Thanks

Thanks for your Quick Response, i gave the id please check your profile Thanking you

Thank you for your replay here is my mail id - sgmpatnaik@gmail.com

Hello Good Morning I have small doubt that is is it possible to create a code for Mouse and Keyboard Movements, i have searched in google but i fail so i decided to get the solution from our Gurus / Ninjas Thanking you With Regards Patnaik

@VDS Please look @ this link http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/ if any doubt please come back Thanks

@rkpatel Please Try the Below Code Private Sub Worksheet_Change(ByVal Target As Range) ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("A2:A2000"), _ SortOn:=xlSortOnValues, Order:=xlAscending...

@rkpatel Please try the below code in Worksheet Module Private Sub Worksheet_Change(ByVal Target As Range) With ActiveWorkbook.Worksheets("Sheet1").Sort .SetRange Range("A:A") .Header = xlGuess .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End...

@Salil you can try another method with Array formula Ctrl+Shift+Enter also =IFERROR(INDEX(D:D,MATCH($F$5&$G5,$B:$B&$C:$C,0)),"") Thanks

@iRasim another approach try this place the formula in C1 =VLOOKUP($B2,$J$2:$N$200,K$2,FALSE) and drag to right side

@deb Bhai ooops :oops: ! i miss that part sorry i think now i have to move to take some drink Thanks and sorry again for my mistake, Let me check that part if any issue i will inform Thanking You Cheers

@deb Bhai Thanks for Your kind words and i am using Office 2007 coming to your point sorry to say this your formula is not work i think you didn't check the formula in my file in BP & GP Tab it's getting the result from only List sheet of Opening Balance if possible please upload the sample...

@Somendra Please Check my sample file which is i attached in my previous post if any issue please inform me Thanks

@deb Here i attache a sample file please check in BP & GP Tab

@Somendra yes it is right because in H5 and I5 is the Brand Names and D7 also the Brand Names of the H5/I5

@deb Bhai in the List Tab i have mention the Party names in C6:c50 and In H5 = ABC AND I5 = XYZ and from H6 to I50 i have given the Quantity of Opening Balance Say H5 - ABC I5 - XYZ 10 5 -5 15 Hope it clear Thanks

@NARAYANK991 Thanks for your valuable replay, yes i forget to mention the End Date Column Sorry for that now coming to point about my question is that In List Tab i have mention the Party Named in the Column C and In Column H5 & I5 i mention the Brand Name, from H6 to I50 i mention the Party...

Hello i have small problem that is i want to add the Start Date and End Date in a Sumproduct Formula as a extra Critera my formula is =SUMPRODUCT(('Dealer List'!$C$6:$C$50=$C9)*('Dealer List'!$H$5:$I$5=F$7),'Dealer List'!$H$6:$I$50)+SUMPRODUCT(('Dispatch Register'!$F$6:$F$3490=$C9)*('Dispatch...

@VDS Sorry for my late replay, i can't under stand why the formula is not stand in your system any how Please try another one Say your date in Range A1 = 30/11/2013 in B1 = Text(a1,"dd") in C1 = Text(a1,"mm") in D1 = Text(a1,"yyyy") Hope it's clear your problem Thanks

Glad your problem solve

@VDS yest it can be done using with Text Function say your Date in A1 as = 03/12/2013 simple type in B1 as = TEXT(A1,"ddmmyyyy") then the date filed will be display as 03122013 Hope it clear now other wise please upload a sample file Thanks

@VDS sorry i can't understand what you say if possible please upload a sample file then i will try to solve your problem as per my understanding in the Govt. section there are some VBA Experts who build the format the date field should be enter as text format due to the Regional setting is...