RE: $$Excel-Macros$$ Cloud Storage

Charlie, Google docs offers both free file hosting (you can download and share your Excel files in their native format) and a web-based cloud computing platform that allows you to work on spreadsheets and other "office" documents online from a web browser (definitely in the category of "look-alike

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

In Excel 2007 Version On Wed, Feb 1, 2012 at 2:21 PM, Abdulgani Shaikh wrote: > in which Excel version it will work ? > > > On Wed, Feb 1, 2012 at 1:55 PM, NOORAIN ANSARI > wrote: > >> Dear Abdul, >> >> PFA >> >> -- Forwarded message -- >> From: ITP Abdulgani Shaikh >> Date: Wed

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

Noorain, Is there any version for Excel 97 - 2003? Thanks~ 2012/2/1 NOORAIN ANSARI > In Excel 2007 Version > > On Wed, Feb 1, 2012 at 2:21 PM, Abdulgani Shaikh > wrote: > >> in which Excel version it will work ? >> >> >> On Wed, Feb 1, 2012 at 1:55 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Ab

$$Excel-Macros$$ Liniking Pivot Tables

Hi Friends, This is lional and I am in need of a help. I have to prepare five different pivots for a single data set. in order to get the data in required format, I have to keep changing master data. Now I just want to know is there any way to link the pivots so that If I make any changes in the

Re: $$Excel-Macros$$ Liniking Pivot Tables

Dear Lional, Can you share any sample workbook with excel macro group. On Wed, Feb 1, 2012 at 3:27 PM, lional deo wrote: > Hi Friends, > > This is lional and I am in need of a help. > > I have to prepare five different pivots for a single data set. > > in order to get the data in required forma

Re: $$Excel-Macros$$ Display numbers in Lakhs

Dear Abdul, You can divide numbers by 1,000,000 to display in millions, but this changes the value of the number. A better way to display numbers in millions is to use a *Custom Number Format*. [image: Photobucket]

Re: $$Excel-Macros$$ Copy data from difference sheet to DataSheet

You do not have a “data” sheet. Are you saying you want to copy to “sheet1” Can you give and example which all field are write. Do you mean “white” (not colored) There was no recorded code showing your efforts Don Guillett SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesda

Re: $$Excel-Macros$$ Copy data from difference sheet to DataSheet

Sorry for not rightly explain but you understand right thing, I need data in sheet1 and cell has no color is actual "White" color. all headings are mention in sheet1, I require just value of them from difference sheet mentioned in attachment. Thanks Ashish Bhalara On Wed, Feb 1, 2012 at 7:43 PM,

Re: $$Excel-Macros$$ need help in the following excel exercise(Indirect & some more array functions)

This looks like classroom “homework” which you need to do yourself. Don Guillett SalesAid Software dguille...@gmail.com From: vvkgupta tycoon Sent: Wednesday, February 01, 2012 5:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need help in the following excel exercise(Indirect

Re: $$Excel-Macros$$ Copy data from difference sheet to DataSheet

You STILL need to tell us from where__to wherewith examples Don Guillett SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Wednesday, February 01, 2012 8:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy data from difference sheet to

$$Excel-Macros$$ Formula need

Hi all I need Formula which attached sheet any one help me Regads chandu -- FORUM RULES (986+ 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 q

$$Excel-Macros$$ Outlook automation help needed

Hi, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise in Outlook 2003. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip s

Re: $$Excel-Macros$$ Formula need

Please could you be a little more clear what you want. It is very hard to understand what you have written. Also, please avoid this practice of writing your requirement IN the file. The email text area is given to type in your text, not just to attach files. Sam On Wed, Feb 1, 2012 at 8:38 PM, ch

Re: $$Excel-Macros$$ Outlook automation help needed

Sounds more of a project request that a help request. Why don't you first do a search on the internet, try to put some macro together by looking for keywords that define your objective. Once you do work on that, bring that to the forum. Volunteers here will then be able to help you. Regards, Sam

Re: $$Excel-Macros$$ Liniking Pivot Tables

Each pivot table is linked to the other pivot table only through the pivot cache, and that too if they are using the same source. There is no way in Excel where you can filter one pivot table, and have the other pivot tables also to get filtered. The best you can look at is to have a sub routine c

$$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorai

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulation Brother !! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been c

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats NOORAIN ANSARI Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: xlstime Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:17:19 To: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ Most Helpful M

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulations to our expert guru. On 1 February 2012 22:18, wrote: > ** > Congrats NOORAIN ANSARI > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * xlstime > *Sender: * excel-macros@googlegroups.com > *Date: *Wed, 1 Feb 2012 22:17:19 +0530 > *

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Cong... Noorain Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:11:57 To: excel-macros Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Mo

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats Noorian !! Keep the flag flying !! Regards, Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 16:48:37 To: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re

$$Excel-Macros$$ Excel Macro to navigate IE

Hi All, If any of have Macro ''click'' or ''navigate'' internet explorer... My requirement is to click 3 hyper links and copy the data to Excel I have tried googling it.. But no luck.. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -- FORUM RULES (986+ members already BANNE

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

A mammoth effort Noorain. Congratulations. Congrats to Rajan also. Great support to the forum, you both. Sam Mathai Chacko On Wed, Feb 1, 2012 at 10:27 PM, wrote: > ** > Congrats Noorian !! Keep the flag flying !! > > Regards, > Krishnan > > Sent on my BlackBerry® from Vodafone > -

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Sam, U are also an very good resource for the group.. Ur knowledge is very helpful for all the members Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:41:24 To:

Re: $$Excel-Macros$$ Excel Macro to navigate IE

You can start with this Public Sub directa() Const strURL_c As String = "http://www.xyz.com"; Const strUsr_c As String = "ABC" Const strPwd_c As String = "DEF" Dim objIE As SHDocVw.InternetExplorer Dim ieDoc As MSHTML.HTMLDocument Dim tbxPwdFld As MSHTML.HTMLInputElement

RE: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Thanks U Sam J Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Feb/Wed/2012 10:41 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari A mammoth effort Noorain.

RE: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Great work Noorain, Congrats From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Feb/Wed/2012 10:12 To: excel-macros Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Hello Everyone, Noorain An

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Thanks a lot Sam. I will work on this and get back to u. Thanks Again. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:46:23 To: Reply-To: excel-macros@googlegroups

Re: $$Excel-Macros$$ Solve problem,Plz help me

Hi, please find the attachment.. On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC wrote: > > > Dear All, > > > Can i use pivot table up to data came below type but i required this type > of data > >Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains > Fail 12:14:59 IN-1009598 M

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are a player, Each & every one contribution great . chandru On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He h

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

congrates noorain bhai On Wed, Feb 1, 2012 at 9:31 AM, chandra sekaran wrote: > Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are a > player, Each & every one contribution great . > chandru > > On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > >> Hello Everyon

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012/2/2 chandra sekaran > Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are > a player, Each & every one contribution great . > chandru > > On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpfu

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank u once again. On Monday, January 30, 2012, dguillett1 wrote: > The formula simply reformats your entry to an entry that excel will use and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT > See atta

$$Excel-Macros$$ Please Help me to create summary and Macro.

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank u once again. On Monday, January 30, 2012, dguillett1 wrote: > The formula simply reformats your entry to an entry that excel will use and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT > See atta

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula

Really dont understand your output completly. Could you please explain the requirement more clearly even if sam's answer above solves your query. Thanks Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Liniking Pivot Tables

I kind of agree with sam on this, and dont think that there is a way by which any other pivot table will get effected by changing the value of one pivot table. If you often apply filter on the same kind of data, then you can always use the SLICERS in Excel, which should definitely solve your concer

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

great, Thanks for sharing.. On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan wrote: > Noorain, > > Is there any version for Excel 97 - 2003? > > Thanks~ > > > 2012/2/1 NOORAIN ANSARI > >> In Excel 2007 Version >> >> On Wed, Feb 1, 2012 at 2:21 PM, Abdulgani Shaikh >> wrote: >> >>> in which

$$Excel-Macros$$ To excel macro team

Hi, I'm not receiving mail summary from group posting anymore. Is there any reasons? Regards, Pascal -- FORUM RULES (986+ 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 Nee

Re: $$Excel-Macros$$ To excel macro team

Did you bathe today. Don Guillett SalesAid Software dguille...@gmail.com From: Pascal Baro Sent: Wednesday, February 01, 2012 3:48 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ To excel macro team Hi, I'm not receiving mail summary from group posting anymore. Is there any rea

RE: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulations Noorain. Great work and contributions. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Wednesday, February 01, 2012 8:42 AM To: excel-macros Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Most Helpful Member Jan'12 - N

RE: $$Excel-Macros$$ Excel Macro to navigate IE

Hello Kiran, Have you considered the approach of using web queries? Excel can automatically retrieve data from URLs that contain tables or XML/RSS and put it in a worksheet. Excel can also automatically refresh the data from the web on a set schedule if desired. The feature works in all version

Re: $$Excel-Macros$$ ExcelTest

Hi Noorain and Congratulations on your award. For Q1 it would be more interesting to ask for the maximum negative value. Otherwise it looks like a catch question. Regards David Grugeon On 31 January 2012 12:28, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Excel Test to analyze

$$Excel-Macros$$ Congrates.

Mr. Noorain, I felicitate u for u r cooperation to our group members. May God bless u with more greater talent than u possess know. Well done! Keep it up! Really I had no interest learn myself this sort of things and had no importance to try to educate myself in macro's or vba before I join thi

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula

Hi Sam, Your formulas resolves my problem and thanks a lot for the same. Can you please let me know the logic behind of this formula. Rohan, I wanted to pick the employees name from the same project and Sam done it in right way. Regards, Vijayendra 2012/2/1 Sam Mathai Chacko > Here's the resu

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulations Noorain... Keep it up. Regards, DILIPandey On 2/1/12, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been cons

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrets noorain Sent from BlackBerry® on Airtel -Original Message- From: Dilip Pandey Sender: excel-macros@googlegroups.com Date: Thu, 2 Feb 2012 09:28:46 To: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulations Noorain Ansari… keep the good work Regards, Vijayendra 2012/2/2 > Congrets noorain > > Sent from BlackBerry® on Airtel > > -Original Message- > From: Dilip Pandey > Sender: excel-macros@googlegroups.com > Date: Thu, 2 Feb 2012 09:28:46 > To: > Reply-To: excel-macros@go

$$Excel-Macros$$ Forrmula need

Dear all Here is my dataitem & Make is same then first item amount X 10 % should come same items and same make below formula need like thatany one help A B C D 1 ITEM MAKE AMOUNT FORMULA NEED 2 1XXX XYZ 1 1000 3 1XXX XYZ 12000 1000 4 1XXX XYZ 8000 1000 5

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulation Noorain. Hope you will keep helping us always in this fashion. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Vijayendra Rao Sender: excel-macros@googlegroups.com Date: Thu, 2 Feb 2012 09:48:00 To: Reply-To: excel-macros@googlegroups.com S

Re: $$Excel-Macros$$ ExcelTest

Hi Noorain, I have able to solve only 1st, 2nd and 5th questions. Regards, Vijayendra 2012/2/2 David Grugeon > Hi Noorain and Congratulations on your award. > > For Q1 it would be more interesting to ask for the maximum negative value. > Otherwise it looks like a catch question. > > Regards >

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Hi, Congrats to Noorain and to each and everyone of you who are helping people like us Regards, K. Praveena On Wed, Feb 1, 2012 at 1:11 PM, Bé Trần Văn wrote: > > > 2012/2/2 chandra sekaran > >> Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are >> a player, Each & e

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Asa, I agree with you. Excel can extract Web query. In my current requirement i don't have a constant URL to download the data. Like www.Google.com -> Calender -> (My case URL is only one) These kind of URLS I have. The Macro need to open IE click on Specified links and copy the data to Ex

RE: $$Excel-Macros$$ Excel Macro to navigate IE

Kiran, Can you give an example of a web page and the links the macro would click on it? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: Wednesday, February 01, 2012 9:25 PM To: excel-macros@googlegroups.com Subject: Re: $$Ex

Re: $$Excel-Macros$$ need help in the following excel exercise(Indirect & some more array functions)

Its not a class room "home work", using these functions I need to do my professional tasks. -Thanks, Gupta. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Asa, I am sorry. I can not give you the URL as it has some confidential information of my customers... Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Asa Rossoff" Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 21:27:42 To: R

RE: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Kiran, No problem. I wanted to investigate if their was any way to get web queries to work with your URLs. Notice that the links I gave describe how to work with parameters in some cases. Also you might be able to use Yahoo! Pipes or DERI Pipes to convert other URLs to XML format (and even

Re: $$Excel-Macros$$ Forrmula need

check the attachment. it may help providing sample file better than showing the data in message body On Thu, Feb 2, 2012 at 9:55 AM, chandra sekaran wrote: > Dear all > Here is my dataitem & Make is same then first item amount X 10 % > should come same items and same make below formula

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Asa, Thanks a lot for your try and hope for the best. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Asa Rossoff" Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 21:47:50 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Dear NOORAIN,   It is a success, you truly deserved. It is an achievement you have truly earned. I congratulate you on your success and wish you all the best for your future. Well done.   You met the challenge with determination, strength, and total confidence! Congrats!   LAKSHMAN... ___

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats Noorain !! -- FORUM RULES (986+ 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 attention or may not be answered. 2) Don't post a q

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congrats. On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been consistent contributor t

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulation...!!! Guru Ji... On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been consistent

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulations Noorain On Thu, Feb 2, 2012 at 5:27 AM, Asa Rossoff wrote: > Congratulations Noorain. Great work and contributions. > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain > *Sent:* Wednesday