Search results

Hi, I have create 4 CheckBoxes if all the four CheckBoxes are not checked then the macro(already i have) should not run and it should through error message "Please select the above option". Please provide a code of me. Thanks, Suresh Kumar S

Hi, Can you please refer the below link. http://www.addictivetips.com/windows-tips/enable-all-macros-in-excel-2010/ Thanks, Suresh Kumar S

Thanks Kevin I got the below formula from google search. =SUMPRODUCT(--(TEXT($A$1:$A$1000,"mmm-yy")=TEXT(D1,"mmm-yy"))) Both works fine. Thanks, Suresh Kumar S

Hi, I have the following dates and i want the sum of each months. 24-Jan-13 28-Jan-13 31-Jan-13 01-Feb-13 05-Feb-13 Output: Jan-13 3 Feb-13 2 Thanks, Suresh Kumar S

Hi, Suppose you have 1:15 in A1 and paste the below formula in B1. =B1*24&" Hours" Thanks, Suresh Kumar S

Hi, Are you looking in the bleow format. Row Labels Sum of EU Sum of NA 2011 $351 $12 2012 $2 $235 2013 $232 $35 Grand Total $585 $282 If So after pivottable please select sum of EU under Values and then select value field settings then number format then currency then select $...

Hi, Can you please download the below file and check. http://www.2shared.com/file/m8bxVDyB/Book2.html Thanks, Suresh Kumar S

Change the Formula from Manual to Automatic Under Formulas Menu - Calculation Options

Hi, Paste the below formula on sheet2 B2 (change the last number (2) according to your output) =INDEX(Sheet1!$A$1:$D$27,MATCH(Sheet2!A2,Sheet2!$A$1:$A$27,0),2) Thanks, Suresh Kumar S

Hi, Again error message Please share the file. The link you're trying to access can't be used to share files. Please ask the file owner to provide you with a shared link instead Thanks, Suresh Kumar S

Sir, I will upload once i reach home. Thanks, Suresh Kumar S

Sir, That would be great if you share with me. Thanks, Suresh Kumar S

Welcome bvanscoy678

Hi, I got the error message The item you are trying to access has either been deleted or is unavailable to you Thanks, Suresh Kumar S

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

Hi C T, Use Find and Replace to ignore #N/A. Thanks, Suresh Kumar S

Hi, Under which column you want the output please specify the column number Ex:=INDEX(Sheet1!$A$1:$A$27,MATCH(Sheet2!A1,Sheet2!$A$1:$A$27,0),4) Thanks, Suresh Kumar S

Thanks SP & Hui

Hi, Try the below code under "PrivotTable1" please replace your pivotTable Name Private Sub Worksheet_Activate() ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh End Sub Thanks, Suresh Kumar S

Hi, I have workbook with different sheets with different range (in each sheet) i want to print out all the sheets with all the different range in one page for each sheet. Any Macro is there? Thanks, Suresh Kumar S

Hi, Is it possible to refer the next workhseet in conditional format. Thanks, Suresh Kumar S

Thank You very much Narayan.

Hi, How do I will compare 2 different format dates? A1 = 13/02/2012 (DD/MM/YYY/) B2 = 20100213 (YYYYMMDD) C2 = TRUE ( I need formula) Thanks in advance, Suresh Kumar S

Thanks XLD

Hi, Suppose I have data from A1:A14 as shown below 1 2 3 4 5 6 7 8 9 10 11 12 13 14 I want a formula to combine all the numbers to one like 1,2,3,4,5,6,7,8,9,10,11,12,13,14 Thanks, Suresh Kumar S