Search results

@All Thanks for Your Christmas Wishes

@Somendra Thanks for your kind words, as per OP requirement the formula was changed let see what the OP requirement the invoice to be continue or stand alone Regards

@JAMIR Please check my uploaded file may be it will helpful to you please change the formula as give below in the Column G and Drag Down =IF($A3="02","",IF($A3="03","",(SUM(H$3:$H3)+10249&" / "&$A3&"-"&TEXT($B3,"dd-mm-yyyy")))) other wise please inform Thanks

@Somendra Misra I tried another method for the Invoice No. with Helper Column in the Helper Column i use the formula as =IF($A3="02",0,IF($A3="03",0,IFERROR($A3/$A3,0))) and in Iv No. =IF($A3="02","",IF($A3="03","",(SUM(H$3:$H3)&" / "&$A3&"-"&TEXT($B3,"dd-mm-yyyy")))) for the continue...

@Hui Sir, Good Morning, Thanks for your quick response and it's works perfect Thanking you With Regards

Hello i have one user form in that UserForm i have placed one List Box and One TextBox. now what i want i want popup the Text in Text Box of List Box2nd option, i mean in my list Box i mention as a = Split("meter, inch, foot, yard", ",") b = Split("m, In, Ft, Yd", ",") when i select the...

@kachiba nice one

@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