$$Excel-Macros$$ Google Heat Maps Charts In Excel

Hi All If you want to create world heat map chart using Google Map charts in Excel. Snapshot below - *To know more and download working file Visit * http://excelvbaprogramming.wordpress

$$Excel-Macros$$ Re: VBA Macros quiz #1

Visit this link https://groups.google.com/forum/?fromgroups=#!topic/excel-macros/lwyDr7R6LJk Regards Ayush Jain On Saturday, 17 November 2012 06:43:43 UTC+5:30, Orlando José Mézquita Fabián wrote: > > Hi Ayush, > > Where can I see the winners of quizzes? > > On Saturday, November 10, 2012 8:13:

$$Excel-Macros$$ Re: VBA Macros quiz #1

Hi Ayush, Where can I see the winners of quizzes? On Saturday, November 10, 2012 8:13:08 AM UTC-4, Ayush Jain wrote: > > Hello everyone, > > Here is another quiz for you to test VBA basics. There are 10 multiple > choice questions in the quiz and should not take more than 5 minutes to > complet

Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes

The problem is that Excel doesn't really "SEE" the hours, minutes, and seconds. What it "SEE"'s is a number. The date: Tuesday, November 13, 2012 16:48:41 is actually a number: (41226.700474537) DISPLAYED any way that you'd like it! This number is the number of days (41226) since 1/1/1900. The d

$$Excel-Macros$$ Re: Guide me in modifying the included code to import data into the current active sheet

Thank you Prince and everyone elso for helping me on this issue. On Friday, November 9, 2012 12:25:42 PM UTC-6, Best Of Luck wrote: > Hi, > > I was using the code below to import data into a Excel 2010 workbook with > only one sheet. I now have multiple sheets and I wont this macro to only

Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes

Hi Sam, Thanks for the advice. Yes, I had tried that. Yes, it visually changes it to what I want, but again - the "true" time still indicates seconds in addition to the hours and minuites. Under normal circumstances this may not be an issue, however I am using a vlookup formula afterwards for

$$Excel-Macros$$ Looking for formula to extract hours and minutes

Hi, I am looking for a formula that would extract hours and minutes. I want it to ignore the date and seconds and not round the minutes based on the seconds. Preferably wither in military time or with AM?PM so that it can be sortable. Here is the way the data is currently formatted. This

$$Excel-Macros$$ Re: Extracting details from one file to another file

Harish, By not describing how you get from the Input to the Output, you are assuming we can simply look at the two files and recognize immediately how you obtained your result. I looked, I cannot. Please describe what steps you go through to get from the point you RECEIVE the input data unti