Search results

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

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.

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

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

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

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

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

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

Dear All, I would like to know how to make a hyperlink such that one can just open sheet according today's date. Hint:- ServerAddressAssignment 18.xlsx in above 18 sepecifies day of date which ,,I just want to take this day by =day(date()) thus on daily bases I can use this hyperlink...

Dear All, I want to have visual basic controlles included in sheet as per my requriment being indicated on sheet(MYASSIGN). Synopsis:- MYASSIGN sheet will contain record for specified column which are BATCH NUMBER, #IMAGES, #COMP, #CLAIMS, INDEXER, CLAIM TYPE and CLIENT. All records will be...

Dear All, How to add hyperlink by function in a workbook to open same workbook's sheet. I know function is- hyperlink() but don't know how to give parameter. Synopsis:- There are multiple sheets named 1,2,3,.31(showing date).I want to give on each page thus on click I get current date's...

Dear All, Again I'm here to make my excel sheet more featured.I want to add a logic from VB in excel to make my sheet more flexiable. I have 5 sheets and sheet name are 1,2,3,4,5(Name the sheets as 1, 2, 3, 4, 5) Now I want to add a button in each page. Now suppose today date is 27 as...

Dear All, I have multiple sheet of the day with name 1,2,3,4...31 that contains these column given reocrd my be vary since I just gave you a format of my query. MISC HCFA UB DEN CORRES INVOICE 48 15 100 50 10 80 .Now I want have another sheet that contains one extra data...

Dear All, Please help me as per give details- H I 13 FROM TO 14 08:30 08:50 =I14-H14 TOTAL MINUTE ==(HOUR(I15)*60)+MINUTE(I15)=20 unit(specific accoring project)=I16/I15=1.3333333 but accoring project need if unit exceed by integer than it would be...

CLAIMS CLAIM TYPE 2 HCFA 5 HCFA 2 MISC 5 DEN 3 MISC 4 UB 6 HCFA 4 HCFA 1 DEN 5 UB 6 HCFA 2 MISC 1 MISC MISC HCFA UB DEN INVOICE TOTAL 0 0 0 0 0 0 Dear All, I need...