Search results

@Gaurang Thanks for your kind words, welcome back if any problem Gaurang we all are learners and we can learn more from this forum Thanks

@Gaurang Mhatre ok Gaurang i think the file was corrupted when that uploaded please download the file again from this link https://dl.dropboxusercontent.com/u/75654703/Gaurang.xlsm if any issue let me know Thanks

Where is your Attachments !!!!

Thanks for your kind words Glad you solve it

@webmax Please Try this, say your amount in A1:A4 100000 500000 50000 1000000 in B1 = A1/100000 Then Copy and Drag Down Another Way put the Value 100000 in C1 copy it and select the range A1:A4 and past special and select divide option and ok, it is done if any problem please inform Thanks

@Afarag Hi, Please download the file i have set my previous codes only for All Tab Buttons rest tabs you can set if any problem please inform Thanks

@Gaurang Glad your problem solve, can you tell me what type of error you are getting from my file

@pratapkumar mohapatra Welcome to Chandoo.Forum, Glad you are here as a new member i would like to request please read the Forum Rules and before any question please search in Google or the Top right side of the Google Search...

@Gaurang Mhatre Hi, Have a look at this file may be it will help you if any problem please let us know Thanks

@Afarag Hi, May be the Hyperlink is not properly for the hidden sheets so please place the command button in Sheet1 and use the below code for hide and unhide the sheets Private Sub CommandButton1_Click() 'Unhide the active sheet and 'Goto to 'Sheet1' With ActiveWorkbook.Worksheets("Sheet2")...

@Wilco Hi, i think it is better to upload a sample file as per your requirement and may be one of our members and Ninja's can help you

@NARAYANK991 My Hearty Congrats for your 6k Mile stone Cheers and advance Happy New Year :DD Regards

@ram Please Check This file here is a New Tab named with Sgmpatnaik, if any issue please inform

@Abhijeet Please check this link may be it will help full to you other wise please inform http://www.ozgrid.com/forum/showthread.php?t=151803 Regards

@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