Search results

@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...

@VDS you are using the word format i think it is better to use the Excel file, i will give you some details how to maintain what is your format please fill all in the Sheet1 and link to Sheet2 with this formula =MID($a1,COLUMN()-1,1) and drag to right and down for your better knowledge i...

@joharmenezes Not sure what you are trying but you can try this =IFERROR(VLOOKUP(A1&"*",Sheet3!$A$1:$B$3,2,FALSE),"") or =IFERROR(VLOOKUP("*"&A1&"*",Sheet3!$A$1:$B$3,2,FALSE),"") for your knowledge i attached the sample file Hope it will solve other wise please inform Thanks

@VDS we don't need any personal information here we just want your column heading with dummy dates and dummy contents of your data that's all and your expecting result data That's all Hope you understand Thanks

@VDS if possible please give us a sample file with your desire requirement, it is good to solve your problem correctly Thanks