Search results

Hi, One more option. Suppose your date in A1 apply =TEXT(A1,"mm/dd") is formula in B1. Thanks, SK

Hi Jiujen, You can use Dave code since i have forgot to skip the code if there is no match found. Thanks Dave. Thanks, SK

Hi Jiujen, Can you please insert a module and paste the below code and check. Sub movedata() Worksheets("sheet1").Select Range("a2").Select Do temp = ActiveCell.Value Worksheets("source").Select Range("a2").Select Selection.CurrentRegion.Select Selection.AutoFilter...

Hi Prakash, I have given some example with help of that i guess you can create your requirements. 2 codes one for disable and other one for enable Private Sub OptionButton1_Click() OptionButton2.Value = False OptionButton2.Enabled = False End Sub Private Sub Worksheet_Activate()...

Sorry Jason, Try this =IF($B$2=4000,IF($B$9=3%,C12),"") Thanks, SK

Hi, Can you paste the below formula in I6. I guess you looking for this. =IF(B2=4000,IF(B9=3%,C12)) Thanks, SK

Hi, Can you please upload the same workbook. Thanks, SK

Hi Akmalkhan, I am sorry about that. Let wait for our Excel Ninja to provide the corrrect soultion. Thanks, SK

Hi, please use the below code Note:Before running this macro make sure all other workbook are closed. This macro will open all the files in the specified path and check the sheet name then it will close with or without save deponds upon the sheet name. Sub openallworkbookandrename() Dim...

Hi, Please refer the below link for uploading the workbook. http://chandoo.org/forums/topic/posting-a-sample-workbook Thanks, SK

Hi, Can you please create a workbook and paste the below code change the path and run the code. Sub openallworkbookandrename() Dim path As Variant Dim excelfile As Variant Dim i As Integer MyDir = "C:Documents and SettingsABCMy Documents" 'please update your respective path to load the...

Hi Shaka, Can you please upload the same workbook. Thanks, SK

Hi s0rmpjmf, To Protect or Unprotect the worksheet use ALT+T , P, P To Protect or Unprotect the workbook use ALT+T , P, W Thanks, SK

Hi Maria, Can you try applying filter by manually. If it works then there should be problem with Field or Criteria. Thanks, SK

Hi, Can you please upload the same workbook. Thanks, SK

Thanks Deb & Amrit.

Hi, How to find out the names alone from a line. Ex: 1. Senthil Kannan Ram working in abc company 2. vinoth kumar working in xyz company Now i want a formula to extract the names only for 1. Senthil Kannan Ram 2. vinoth kumar Any help. Thanks, SK

Hi, Can you please upload the same workbook. Thanks, SK

Hi Luke, I tried the above code and it say Header found in row: 36. Thanks, SK

Thanks Hui.

Hi, I have created a macro and saved it as 2007 Add-in file now. how i will add that add-in the activeworkbook or how i will run that particular macro. Thanks, Suresh Kumar S

Luke, It would come in row # 35 to 45 depends upon the output report sometime it would come in 35th row or 40th row. The Header name would be starting with Income. Thanks, Suresh Kumar S

Hi, I have a data where the header may move from 35 to 45 (after running the report may be first time it will be in 35 and second time will come down to 45 )how do i can declare the title in code. By default the recorded macro code taken it as.PrintTitleRows = "$35:$40". Now i want to find...

Hi, Can you please upload the sample workbok. Thanks, Suresh Kumar S

Hi, Use =SUBTOTAL(109, I2:I107) or change the calculation from manual to automatic under formulas menu. Thanks, Suresh Kumar Sa