Re: $$Excel-Macros$$ Need a macro to update charts automatically

Dear Atul, Please use below code to update Chart Automatic.. * Private Sub Workbook_Open() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Calculate Next Set wks = Nothing End Sub* also visit on below web link.. http://spreadsheetpage.com/index.php/tip/upda

Re: $$Excel-Macros$$ Median in Pivot Table

Dear Atul... Please visit on below link..hope it will help to you Excellent Example of Pivot table... http://www.contextures.com/excel-pivot-table-summary-functions.html - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http

Re: $$Excel-Macros$$ Worksheet Combobox to list available macro

Dear Johann, Please see attached sheet, i hope it will help you.. otherwise please provide more explanation.. On Fri, Dec 16, 2011 at 2:45 PM, johann wrote: > Hi, > > Does someone know how to list macros from current opened workbooks in > a worksheet control combobox? More precisely, I'd like t

Re: $$Excel-Macros$$ Help on isblank & iferror

Dear Vijay, Please find solution with Isblank+Iferror Combination.. =IF(*ISBLANK(A2)*=TRUE,"",*IFERROR*(VLOOKUP(A2,Sheet1!$A:$A,1,0),"not recieved")) - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.co

$$Excel-Macros$$ Need assistance in Functions related to Financial Calculation

Hi Group, Can any one help me with the financial calculator templates or formulas, functions to calculate Simple intrest, Compound interest and Interest on Recurring deposit. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use co

$$Excel-Macros$$ Financial Tools in excel.

Dear All, I need financial excel tool for analysis of different situation. You are requested to send me this kind of sheet. Regards, Ankit -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

Re: $$Excel-Macros$$ shortcut key .

Dear Vijay, Incase of 2007+ you can use... *CTRL+SHIFT+L* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA

Re: $$Excel-Macros$$ shortcut key .

Hi, When the filters are On and you want to Check or Uncheck certain items, u can use Alt+Down Arrow, and then check or uncheck it by using "Space" button On Mon, Dec 19, 2011 at 4:43 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Incase of 2007+ you can use... > > *CTRL+SHIFT+L* > > -- > Thanks & r

Re: $$Excel-Macros$$ shortcut key .

Yes, to check and uncheck the filters you can use the bar. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wil

$$Excel-Macros$$ Re: Financial Tools in excel.

Not sure what your requirement is. Finance is a huge subject. Please try to create some sample and let us know, what exactly are you tryingy to accomplish. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ pls fill up this sheet with this pattern

The question is what do you intend to do with it afterwards. Perhaps a looping macro would serve your needs??? Don Guillett SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Sunday, December 18, 2011 11:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ pls fill up this

Re: $$Excel-Macros$$ Compare character types in 2 character string

=TYPE(VALUE(LEFT(H2,1)))=TYPE(VALUE(RIGHT(H2,1))) Here you go. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic

$$Excel-Macros$$ Re: Fwd: Vba Code for Outlook

You can use a macro to send the emails, however you would have to a Excel sheet to store the name of the recipients and email address. Can write a macro if that works fine for you !! Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

$$Excel-Macros$$ Re: Excel Add-In or XLSTART file not working

Anyone ? This is a really annoying issue that I am just unable to fix. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick a

Re: $$Excel-Macros$$ Compare character types in 2 character string

You can also use.. =ISERR(--LEFT(A3,1))=ISERR(--RIGHT(A3,1)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 16, 2011 at 11:27 PM, StephenM w

Re: $$Excel-Macros$$ Re: Excel Add-In or XLSTART file not working

Dear Fin, Try thorugh below link, Hope it will help to you.. http://www.jkp-ads.com/articles/startupproblems.asp otherwise.. can you open the files in the XLSTART folder manually? If so, I'd try to - open them - save as a different name - delete the original files - open the duplicates again -

RE: $$Excel-Macros$$ Median in Pivot Table

You can more or less include non-supported aggregate functions in a pivot table by calculating the aggregates in advance and including them in columns with your source data, then in the pivot table, group your pivot the same way the aggregates were calculated. To include those values unchanged in

RE: $$Excel-Macros$$ Median in Pivot Table

Update -- Where I said "In Cell A2, to grab the first value, put =Sheet1!B2"; you can actually use the following syntax in Excel 2010 to reference the first value in that table field from anywhere in the workbook: =Table1[@Type] Asa From: excel-macros@googlegroups.com [mailto:excel-macros

Re: $$Excel-Macros$$ Median in Pivot Table

Excellent Explantion of Medion function Thanks Asa.. On Tue, Dec 20, 2011 at 9:08 AM, Asa Rossoff wrote: > Update -- > > Where I said "In Cell A2, to grab the first value, put =Sheet1!B2"; you > can actually use the following syntax in Excel 2010 to reference the first > value in that tab

$$Excel-Macros$$ jpj file convert in excel file

Hi friends, I need some help, I m trying a sacen file convert in excel file by ocr but I m not able to convert proper, so help me. Regards Anil -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

$$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

Dear all, I have created a report to copy the data from a sheet to another. However, i use isempty to check where to paste the data, but I found there is performance issue. Is there any other way out other than using Isempty()?? File: http://www.sendspace.com/file/64pseo Below can find the code

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

Dear Darwin, You can use *(Cells(i, 3)=""* or *(Cells(i, 3)=vbnullstring* instead of * IsEmpty*(Cells(i, 3)). - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

**with Small correction Dear Darwin, > > You can use *Cells(i, 3)=""* or *Cells(i, 3)=vbnullstring* instead of * > IsEmpty*(Cells(i, 3)). > > - > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com

RE: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

Hi Darwin, Instead of looping through all the cells, use the RANGE.Find method. Here's a modification of your routine (I commented out lines I replaced) that I think will have the same result, but uses RANGE.Find for speed: Sub reportdata() 'Paste the data according to the date of report D

Re: $$Excel-Macros$$ Re: Excel Add-In or XLSTART file not working

Thanks Noorain, appreciate the response. The problem however isn't the opening of files so much as it is the execution of the macros contained therein. I tried the articles recommendations and it didn't help. The code I pasted works fine when manually pasted into excel vba editor, however if I

$$Excel-Macros$$ Fwd: Drop down list

Dear All, Could we use drop down function using "if" condition. Example is attached Regards. Ankit -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Ne