Search results

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

Dear All, First of all, I would like to pay thanks to all of you who helps here and share their valuable time to a needed person. Today, I have one query what has been given below:- I want to fetch data from multiple work-book through particular one cell. For example:- I have three sheets name...

I just want all the records to be placed as vertical wise. I will really appreciate your any kind of help in this concern. Thanks......

Dear All, I have an urgent query as has been given below:- There are 5 columns in excel and I need to place the records of 4 columns respectively are Print Date, Letter Type, Producer Id, and Issue Date these depend on the unique Vendor Number in horizontal. I have also given blank filed to...

Sir, your knowledge is awesome. I would be grateful to you, if you refer me any book to get all these type of function. As I have done MCA along with I have done vocational training in .NET

Hello Hui, Hope you are doing well. Kindly see my requirement given below:- I want to have modification in above query, Since I want , if someone clicks on particular rows' voice button than that rows' meaning text should be voiced. For example:- If click on Cell B8 then Defy should be...

Hi Hui, thanks for your kind help, as given code is given for second row as stated in my question. But I changed coulmn reference from B2:B12 to A2:A12 and it works fine since system can't read hindi font untill we add third party add-on application. But I need some modification in given code, I...

YES,,,SURE I HAD ENABLED IT WHILE RUNNING MACRO.

Sorry Brother! It is not functioning at all .:) Moreover, I have MS-office 2007.

Dear all, I am again here after a long span of time with a new query, Hope you are doing well. Well, I am demonstrating my query below:- I am maintaining a meaning sheet in excel , there are two columns in it, First one is word and second one is meaning of that in Hindi. I want to add a third...

Dear All, First of all I would like to pay thanks you all for helping me so much here. Today, I am having a question given below:- There is one Excel sheet contains two column:- 1.IP address,2.UserName Basically We have Remote Access based Project at our office so each user is granted a...