Re: $$Excel-Macros$$ Fwd: Formatting Required

2013-10-26 Thread SUDHIR VERMA
pls try this On 27/10/2013, SUDHIR VERMA wrote: > On 26/10/2013, Ravinder wrote: >> Simply try this formula =IF(D5="",C5,G6) and dragdown >> >> Or >> >> pfa >> >> >> >> From: excel-macros@googlegroups.com >> [mailto:excel-macros@googlegroups.com] >> On Behalf Of Javed Khan >> Sent: Saturday, Oct

Re: $$Excel-Macros$$ Fwd: Formatting Required

2013-10-26 Thread SUDHIR VERMA
On 26/10/2013, Ravinder wrote: > Simply try this formula =IF(D5="",C5,G6) and dragdown > > Or > > pfa > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Javed Khan > Sent: Saturday, October 26, 2013 3:25 PM > To: excel-macros@googlegroups.com > Subjec

Re: $$Excel-Macros$$ Require a formula

2013-10-26 Thread ashish koul
try the attachment On Sun, Oct 27, 2013 at 11:04 AM, KAUSHIK SAVLA wrote: > Hi Team, > > Need a formula which will do the following in attached spreadsheet: > > I want to group the Ageing (Column E) as below:- > > less than or equal to 7 Upto 7 More than 7 but less than or equal to 14 > Gre

$$Excel-Macros$$ Require a formula

2013-10-26 Thread KAUSHIK SAVLA
Hi Team, Need a formula which will do the following in attached spreadsheet: I want to group the Ageing (Column E) as below:- less than or equal to 7 Upto 7 More than 7 but less than or equal to 14 Greater than 7 but less than or equal to 14 More than 14 but less than or equal to 30 Greater

Re: $$Excel-Macros$$ Pivot table format

2013-10-26 Thread xlstime
not possible in pivot table use separately 1. Select the range that contains blank cells you need to fill. 2. Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option. 3. Click OK, and all of the blank cells have bee

Re: $$Excel-Macros$$ How to install power pivot addin

2013-10-26 Thread xlstime
if u want to install powerpoint add simply use excel shortcut (alt+T+I) . Enjoy Team XLS On Sun, Oct 27, 2013 at 10:07 AM, Amit Desai (MERU) wrote: > Dear Friends, > I would like to install power pivot addin in excel. I have excel 2010 > installed on my home PC. I hav

Re: $$Excel-Macros$$ How to install power pivot addin

2013-10-26 Thread ashish koul
see if it helps http://social.technet.microsoft.com/wiki/contents/articles/714.powerpivot-install-the-powerpivot-add-in-for-excel.aspx On Sun, Oct 27, 2013 at 10:07 AM, Amit Desai (MERU) wrote: > Dear Friends, > I would like to install power pivot addin in excel. I have excel 2010 > installed

$$Excel-Macros$$ How to install power pivot addin

2013-10-26 Thread Amit Desai (MERU)
Dear Friends, I would like to install power pivot addin in excel. I have excel 2010 installed on my home PC. I have downloaded required .net file & 1 power pivot related file. Pls help with further steps to follow so that I can install adding. Best Regards, Amit Disclaimer: This message and its

Re: $$Excel-Macros$$ Simple Sum Macro not working

2013-10-26 Thread Ganesh N
Thanks Ashish On Sun, Oct 27, 2013 at 9:42 AM, Ganesh N wrote: > Hi Team, > > Im new to macro may i know why this macro not working. Please help me on > that. > > Sub MyFirstProgram() > Range(“B2”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B3”).Select > ActiveCell.Value = Inp

Re: $$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-10-26 Thread ashish koul
r u using 2010 On Sun, Oct 27, 2013 at 1:27 AM, ChillingMBA wrote: > Hi Ashish, > > Thank you for the code! > > I wrote a procedure to call functions defined by you. But in getHTML > function at ".send" I am getting error message of "Access is Denied". Can > you please help me in resolving the i

Re: $$Excel-Macros$$ Simple Sum Macro not working

2013-10-26 Thread ashish koul
Sub MyFirstProgram() Range("B2").Select ActiveCell.Value = InputBox("Enter value") Range("B3").Select ActiveCell.Value = InputBox("Enter value") Range("B4").Select ActiveCell.Value = InputBox("Enter value") Range("B5").Select ActiveCell.Value = InputBox("Enter value") Range("B6").Select ActiveCell.

Re: $$Excel-Macros$$ Excel Macro to print, slecting range, printer and orientation etc

2013-10-26 Thread ashish koul
try this way http://mariaevert.dk/vba/?p=6 On Sun, Oct 27, 2013 at 8:26 AM, Howard Rambin wrote: > I am new to macros in Excel (wiz at lotus keyboard macros). > > I don't have not problem recording a simple print macro with just a range > selection, but when I go to select a printer, fit to pa

$$Excel-Macros$$ Simple Sum Macro not working

2013-10-26 Thread Ganesh N
Hi Team, Im new to macro may i know why this macro not working. Please help me on that. Sub MyFirstProgram() Range(“B2”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B3”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B4”).Select ActiveCell.Value = InputBox(“Enter value”) Ra

$$Excel-Macros$$ Re: Want to get your question answered quickly?

2013-10-26 Thread Howard Rambin
Not sure that this is place to ask questions but I can record a macro in excel 2010 to print, with a selected range, but when I try to record one that does that but then goes beyond to select printer, orientation etc., it bombs On Saturday, November 3, 2012 2:34:25 AM UTC-5, Ayush Jain wrot

$$Excel-Macros$$ Excel Macro to print, slecting range, printer and orientation etc

2013-10-26 Thread Howard Rambin
I am new to macros in Excel (wiz at lotus keyboard macros). I don't have not problem recording a simple print macro with just a range selection, but when I go to select a printer, fit to page etc, I get errors. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

2013-10-26 Thread ChillingMBA
Hi Ashish, Thank you for the code! I wrote a procedure to call functions defined by you. But in getHTML function at ".send" I am getting error message of "Access is Denied". Can you please help me in resolving the issue? Also if I am directly trying to call function, it gives me error of "#Va

RE: $$Excel-Macros$$ Pivot table format

2013-10-26 Thread Kashan Abbas
Dear Group plz help From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Pivot table format Date: Sat, 26 Oct 2013 09:54:54 +0500 Dear Plz reply From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot tab

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

2013-10-26 Thread SUDHIR VERMA
It can be possible through Google Drive or Sky Drive. On 26 October 2013 17:22, Excel_Lover wrote: > Dear All, > > What is the best way to share and View the excel dashboard online. > > Basically, We have one excel dashboard which we send by e-mail on > updation. What I need is an alternate sol

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

2013-10-26 Thread ashish koul
try this http://office.microsoft.com/en-in/sharepoint-server-help/introduction-to-excel-services-and-excel-web-access-HA010105476.aspx http://msdn.microsoft.com/en-us/library/ms572330(v=office.14).aspx http://blogs.msdn.com/b/mvpawardprogram/archive/2012/05/21/embedded-excel-services-on-your-websit

$$Excel-Macros$$ To Share and View Excel Dashboards.

2013-10-26 Thread Excel_Lover
Dear All, What is the best way to share and View the excel dashboard online. Basically, We have one excel dashboard which we send by e-mail on updation. What I need is an alternate solution to the users to view this online than downloading it from e-mail every time. Appreciate your suggestions.