Search results

Hi If the Name is Dhoni S. the output is coming as S. DHONI

Hi I have the Following Name Input 1) M.S. Dhoni 2) S. John I would Like the Output and intial should Come Last of the Name using formula Output Dhoni MS John S Regards Shahul

Hi I am attaching the same excel file in that i make cell C8 as Zero by changing E8 Column For that i have to change from C8 to C22 cell as Zero by Changing the E8 to E22 I Need the macro

Hi I have a two cells A1 & A2 A1 Cell contains Mr. A2 Cell Contains Name ie John When i put the formula in A3 Cell concatenate A1 & A2 Cell in it is coming as Mr.John. I the Result to Come as Mr. John in tha John should bold in word. Any one help on this. regard Shahul

Hi Please with the attached file. How to reduce the gap between dates for example 01st July and 2nd July 2014 regards Shahul

Sir The Formula is correct but if the name is huge for example 2000k names how to put the values.

if i filter with name the below table will automatically change

Hi I have the data in the above of the sheet. If i filter the Name as A then it will shows the Difference between Feb14 - Jan 14 (subtraction) and Difference Mar 14 - Feb 14. If i select the Name B then it will shows the difference of Feb 14 - Jan 14 of B and so on. I am attaching the sample...

Hi i have one doubt in Data Validation. For Data Validation i type the list range in one place in excel (Cells) For example in the attached file the list of range is E2 to E5 The Data Validation will come in C2 Range. If any body wrongly delete the cells between E2 to E5. The data...

hi deepak. the below part the same will come in the get picture of the contains extension of jpg or png pic = "C:\Users\Deepak\Pictures\may_poster_14_X_19_inch.jpg"

Hi i need the macro that if i add the add button in the sheet1 i get the file from the computer and save it in the sheet 2 page appropriate place given. regards Shahul

Hi I have a excel sheet which contains the raw data I want to filter the two criteria which is region and location The same will save in the Active path with the region name as file name i am attaching the raw data and output file. regards Shahul

hi can u kindly upload the sample file.

sir i want this in the macro

Hi I want the macro to copy the attached sample date to horizontal I attaching the input file and output file too. kindly do the needful. regards Shahul

hi luke if i open the file i want the first screen should appear always (Introduction Page) regards Shahul

Hi I have a forms in that there are five fields 1)Introduction 2) Personal details 3) Communication 4) Family Details 5) Education Details In that i wrote four macros. I need a Help if the person click on the Next Button it will go to the next Field For example if i am in introduction page if...

right sir. how you did that sir.

i want like this Monthwise with Date sorted. Month Name Date Remarks Feb 2014 D 27/02/2014 Due 1 April 14 A 16/4/2014 Due 1 June 14 B 04/06/2014 Due 1 June 14 B 04/06/2014 Due 1

Hi I have a Emp code in the Data B2 Cell if i change the Emp Code automatically B3 Cell need to be blank. The B3 Cell i will keep manually. I am attaching the file for your reference.

Hi Kindly find the attached list which contains the customer name and Due dates I want the Report Monthwise who are the customer due date occurrs and due no (For Example Due 1 , Due 2 etc) Regards Shahul

Hi i want to remove the page number (Water Mark) from a Page Break view. Kindly help regards Shahul

Hi use the below code Sub CopyNew() Dim wsNew As Worksheet Dim myRange As Range Dim strName As String Application.ScreenUpdating = False With Worksheets("Final") 'Can't use / in sheet names, changed format strName = Format(.Range("C1").Value, "dd-mmm-yyyy") Set myRange =...

i have a list of names in the excel sheets. i want to create the folder for the same and named in the excel sheets for example in the the excel sheet range i have following names Jan, Feb up to Dec. so the total name is 12 i want to create the 12 folders and folder name is jan, feb up to dec.

k sir