Recent content by Ravindra

Dear All, I need to get value through passing reference from another sheet. Please help, kindly find the attached file.

yes VBA is mandatory, no other choice. Please help me.

Hi All, I want desired output in one sot. I need to split the text automatically into same row cells. Please see the enclosed file and help me in this concern.

I am unable to do it. I just need the functionality in my sheet. I appreciate for your kind support here.

Hi All, I need to convert different currencies into different currencies. I simply want to achieve that task by entering To be converted currency in first column and converted currency in another column. For better understanding my need, please refer to the attached file. Moreover, there are...

Hi All, Greetings for the day !!!! I am having problem with attached file. It is filling cells while selecting "September" month from combo box. Please see it and help me to fix this problem. Many-many thanks...

It is a nice solution which you have provided me, but I want cell a1:c1 to be merged in single cell a1 and so on with another cell to represent month. please see attached file with required modification....and do more needful. Have a great day !!!!

Hi Sir, I have done little bit changes in designing . Please help me now in this concern. Moreover, your coding is really awesome. Since a coding is called perfect coding which is a little. Please......help..... Regards, Ravindra Bisht

I am not able to understand this below given code:- For Each rng In Range("A1:X1") If rng <> [Y1].Value Then rng.EntireColumn.Hidden = Not (rng.EntireColumn.Hidden) Next Application.ScreenUpdating = True End Sub ...... As far as by this programming..I can say that you are using for each loop...

Please clarify me following codes. I will really appreciate you for this kind of help. Code (vb): Option Explicit Option Compare Text Sub HideIt() Dim rng As Range Application.ScreenUpdating = False Columns("a:x").EntireColumn.Hidden = False For Each rng In Range("A1:X1") If rng <>...

Hi All, I have a workbook with the record from January to August. I have added 8 button for Jan...August and two extra button for Show All and Hide All respectively. I also added a Active X combo box for the selection of month. Now, I want such sort of functionality with added controls so...

Thanks...

Hi All, I am newbie in VBA programming. I am puzzled in below given query:- There are three cells b1,b2, and b3 respectively for the input of three numbers i.e. number1,number2,and number 3 respectively. There are two cells b5 and b6 for the showing total and average respectively. I have used...

Thank you so much...

Dear All, I need three different way to Calculate the value for specified person as per their department except first one is given. Kindly see the attached sheet and help me to learn excel. I will really appreciate your effort. Thanks....