RE: $$Excel-Macros$$ Cloud Storage

[Asa Rossoff]

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" -- and no
such web-based solution today has all the features that desktop office
software has).

 

If you want to be able to use the "real" Excel from anywhere, perhaps you
are looking for a hosted virtual desktop solution, where your operating
system and software reside on cloud servers and the "screen" can be streamed
to you on your computer or other computers.  I don't know a lot about this
market but apparently it is getting quite big.  Possibly mainly for
corporate accounts serving many users, like the offer here:
http://www.tucloud.com/hosted_virtual_desktop.html. Their plans start at 50
users and they advertise "less than a dollar a day" for Windows 7 and
Microsoft Office.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Tuesday, January 31, 2012 11:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Cloud Storage

 

Yes Cab 

You can use google docs facility to use online excel.

Click here for more information.

edutech.msu.edu/online/GoogleDocs/GoogleDocs.html

On Wed, Feb 1, 2012 at 12:05 PM, Cab Boose  wrote:

Hi

 

Is there anywhere online that MS Excel files can be stored and used.  No
look-a-likes but Excel.  Freeware or low cost.

 

Thanks

 

Charlie

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com




-- 

Thanks & regards,

Noorain Ansari

  http://excelmacroworld.blogspot.com/

  http://noorain-ansari.blogspot.com/

 

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 Abdul,
>>
>> PFA
>>
>> -- Forwarded message --
>> From: ITP Abdulgani Shaikh 
>> Date: Wed, Feb 1, 2012 at 11:28 AM
>> Subject: Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you
>> will like it
>> To: excel-macros@googlegroups.com
>>
>>
>> I am unable to download the Add in, can you please email it to me.
>> Regards
>>
>> On Mon, Jan 30, 2012 at 9:09 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Group,
>>>
>>> Find attached the Excel add-ins, which simply fantastic in our routine
>>> work.
>>> Just open the attachment in excel file and you can see there is an
>>> additional menu appears to your excel tab “My Menu”
>>> develop by one of our Group member Mr. Ashish Koul
>>>
>>> You can see almost all the functions we use are available in the menu
>>>
>>> http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html
>>>
>>> --
>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> --
>>> 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 question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Shaikh AbdulGani A R
>> ITP, STP, TRP, STRP
>>
>>  --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Darwin Chan]

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 Abdul,
>>>
>>> PFA
>>>
>>> -- Forwarded message --
>>> From: ITP Abdulgani Shaikh 
>>> Date: Wed, Feb 1, 2012 at 11:28 AM
>>> Subject: Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you
>>> will like it
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> I am unable to download the Add in, can you please email it to me.
>>> Regards
>>>
>>> On Mon, Jan 30, 2012 at 9:09 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Group,

 Find attached the Excel add-ins, which simply fantastic in our routine
 work.
 Just open the attachment in excel file and you can see there is an
 additional menu appears to your excel tab “My Menu”
 develop by one of our Group member Mr. Ashish Koul

 You can see almost all the functions we use are available in the menu

 http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html

 --




 --
 Thanks & regards,
 Noorain Ansari
  
 *http://excelmacroworld.blogspot.com/*
 *http://noorain-ansari.blogspot.com/*

 --
 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 question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> Shaikh AbdulGani A R
>>> ITP, STP, TRP, STRP
>>>
>>>  --
>>> 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 question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>>
>>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need He

$$Excel-Macros$$ Liniking Pivot Tables

[lional deo]

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 first pivot and the other pivots can also be
changed accordingly.

here the change which I am talking about is the changes like filters. for
instance, I am changing the report filter of a first pivot, will the other
pivots filter change at once? Is there any way exists to do that?

It would be more helpful If you guys can help me out in this.

kindly get back to me in case my question is not clear to you.

Thank you

Yours,
Lional

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[NOORAIN ANSARI]

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 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 first pivot and the other pivots can also
> be changed accordingly.
>
> here the change which I am talking about is the changes like filters. for
> instance, I am changing the report filter of a first pivot, will the other
> pivots filter change at once? Is there any way exists to do that?
>
> It would be more helpful If you guys can help me out in this.
>
> kindly get back to me in case my question is not clear to you.
>
> Thank you
>
> Yours,
> Lional
>
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[NOORAIN ANSARI]

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]

   - Choose Format > Cells
   - On the *Number* tab, select *Custom* from the *Category* list
   - Paste one of the following formulas in the *Type* field
  - To display millions with one decimal, paste *#.0,,;(#.0,,)*
  - To display millions with a dollar sign and one decimal, paste *
  $#.0,,;($#.0,,)*
  - To diplay millions with two decimal places, paste *#.00,,;(#.00,,)*
  - To diplay millions with a dollar sign and with two decimal places,
  paste *$**#.00,,;($#.00,,)*
  - To diplay millions with three decimal places, paste *
  #.000,,;(#.000,,)*
  - To diplay millions with a dollar sign and three decimal places,
  paste *$**#.000,,;($#.000,,)*



On Wed, Feb 1, 2012 at 11:13 AM, ITP Abdulgani Shaikh <
itpabdulg...@gmail.com> wrote:

> This is really good, but gives answer in million format and not in Indian
> lakh.
> Regards
>
> On Sun, Jan 29, 2012 at 11:35 AM, Mohammed Muneer wrote:
>
>> Mr. Prabhu go to Format cells:
>>
>> Go to "Numbers - currency - select Indian RUPEES - Then immediately come
>> out from currency and go to customs - do little correction like this
>> (chk the att copy of jpg file"
>>
>>
>>
>> Regards,
>> Muneer,
>> CC...
>>
>>
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com
>> [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu
>> Sent: Sunday, January 29, 2012 8:42 AM
>> To: MS EXCEL AND VBA MACROS
>> Subject: $$Excel-Macros$$ Display numbers in Lakhs
>>
>> Hi,
>>
>> In Excel I needs to convert numbers in to indian format and the value
>> should divided by lakhs and display in Lakhs.
>>
>> Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian
>> format)
>>
>> Plz help.
>>
>> Regards,
>>
>> Prabhu
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>> 
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Shaikh AbdulGani A R
> ITP, STP, TRP, STRP
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

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

[dguillett1]

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: Tuesday, January 31, 2012 10:09 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Copy data from difference sheet to DataSheet

Dear experts, 

I require the data copy from different sheet to DataSheet which attached 
herewith. In the attachment sheet, the filled which not colored, I need that 
data paste to DataSheet in which all field are write. I know about the record  
macro but not success to write code for this. Please suggest the simple code to 
copy from different type of sheet to a DataSheet. 

Thanks & regards

Ashish Bhalara
-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Ashish Bhalara]

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, dguillett1  wrote:

>   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:* Tuesday, January 31, 2012 10:09 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Copy data from difference sheet to DataSheet
>
> Dear experts,
>
> I require the data copy from different sheet to DataSheet which attached
> herewith. In the attachment sheet, the filled which not colored, I need
> that data paste to DataSheet in which all field are write. I know about the
> record  macro but not success to write code for this. Please suggest the
> simple code to copy from different type of sheet to a DataSheet.
>
> Thanks & regards
>
> Ashish Bhalara
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[dguillett1]

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 & 
some more array functions)

Hi Guys, 

Can some body help me in the attached worksheets. I would much appreciate if 
they could deliver with formulas.

Thanks & Regards,
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, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[dguillett1]

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 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, dguillett1  wrote:

  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: Tuesday, January 31, 2012 10:09 PM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Copy data from difference sheet to DataSheet

  Dear experts, 

  I require the data copy from different sheet to DataSheet which attached 
herewith. In the attachment sheet, the filled which not colored, I need that 
data paste to DataSheet in which all field are write. I know about the record  
macro but not success to write code for this. Please suggest the simple code to 
copy from different type of sheet to a DataSheet. 

  Thanks & regards

  Ashish Bhalara
  -- 
  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 question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

  -- 
  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 question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com


-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send emai

$$Excel-Macros$$ Formula need

[chandra sekaran]

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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


formula need.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Outlook automation help needed

[KAUSHIK SAVLA]

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 showing tax payable.

(Attachment file would be here from specific file path)

Kindly let me know in case you require further information.

Best Regards,
Kaushik Savla - Assistant Manager
JLT India Pvt Ltd

What I want to do - Firstly, I want Sender name to be captured
automatically as per email received from sender. Secondly, I want a code
which will write the above green highlighted text message automatically.
Thirdly, I want the file to be attached automatically. Pleas note I do not
want to send mail automatically, i want pop up box after reviewing of which
i can send the emails.


Please suggest me some solution. Your valuable time is highly appreciated
in this matter.

Anticipating your assistance on aforesaid matter.

Regards,

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula need

[Sam Mathai Chacko]

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, chandra sekaran wrote:

> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Sam Mathai Chacko]

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

On Wed, Feb 1, 2012 at 8:45 PM, KAUSHIK SAVLA wrote:

> 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 showing tax payable.
>
> (Attachment file would be here from specific file path)
>
> Kindly let me know in case you require further information.
>
> Best Regards,
> Kaushik Savla - Assistant Manager
> JLT India Pvt Ltd
>
> What I want to do - Firstly, I want Sender name to be captured
> automatically as per email received from sender. Secondly, I want a code
> which will write the above green highlighted text message automatically.
> Thirdly, I want the file to be attached automatically. Pleas note I do not
> want to send mail automatically, i want pop up box after reviewing of which
> i can send the emails.
>
>
> Please suggest me some solution. Your valuable time is highly appreciated
> in this matter.
>
> Anticipating your assistance on aforesaid matter.
>
> Regards,
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Sam Mathai Chacko]

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 created that will take
the pivot, the fields and what to change to as arguments.

Regards,

Sam Mathai Chacko

On Wed, Feb 1, 2012 at 3:59 PM, NOORAIN ANSARI wrote:

> 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 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 first pivot and the other pivots can also
>> be changed accordingly.
>>
>> here the change which I am talking about is the changes like filters. for
>> instance, I am changing the report filter of a first pivot, will the other
>> pivots filter change at once? Is there any way exists to do that?
>>
>> It would be more helpful If you guys can help me out in this.
>>
>> kindly get back to me in case my question is not clear to you.
>>
>> Thank you
>>
>> Yours,
>> Lional
>>
>>
>>  --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Ayush Jain]

 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 Noorain Ansari :*
[image: noorain.jpg]

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com

*Noorain, Many thanks for all your great support to group. Keep it up*

*Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
**
*Keep posting.

Regards
Ayush Jain
Group Manager
Microsoft MVP

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[xlstime]

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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[respuzy]

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 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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Hari]

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
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *NOORAIN ANSARI
> *Subject: *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 consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> .
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Yours,

Hari.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures 

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

[Kiran Kancherla]

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$$ 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 Noorain Ansari :*
[image: noorain.jpg]

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com

*Noorain, Many thanks for all your great support to group. Keep it up*

*Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
**
*Keep posting.

Regards
Ayush Jain
Group Manager
Microsoft MVP

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[krishnanm2006]

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$$ 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 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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  C

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

[Kiran Kancherla]

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 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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Sam Mathai Chacko]

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
> --
> *From: * resp...@gmail.com
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 1 Feb 2012 16:48:37 +
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *NOORAIN ANSARI
> *Subject: *Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain
> Ansari
>
> 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
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *NOORAIN ANSARI
> *Subject: *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 consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> .
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for vio

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

[Kiran Kancherla]

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: 
Reply-To: excel-macros@googlegroups.com
Subject: 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
> --
> *From: * resp...@gmail.com
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 1 Feb 2012 16:48:37 +
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *NOORAIN ANSARI
> *Subject: *Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain
> Ansari
>
> 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
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *NOORAIN ANSARI
> *Subject: *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 consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> .
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitiv

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

[Sam Mathai Chacko]

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
Dim tbxUsrFld As MSHTML.HTMLInputElement
Dim btnSubmit As MSHTML.HTMLInputElement
On Error Goto Err_Hnd
 'Create Internet Explorer Object
Set objIE = New SHDocVw.InternetExplorer
 'Navigate the URL
objIE.navigate strURL_c
 'Wait for page to load
Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
 'Get document object
Set ieDoc = objIE.document
 'Get username/password fields and submit button.
Set tbxPwdFld = ieDoc.all.Item("USER")
Set tbxUsrFld = ieDoc.all.Item("PASSW")
Set btnSubmit = ieDoc.all.Item("SUBMIT")

 'Fill Fields
tbxPwdFld.Value = strUsr_c
tbxUsrFld.Value = strPwd_c
 'Click submit
btnSubmit.Click
 'Wait for page to load
Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
Err_Hnd: '(Fail gracefully)
objIE.Visible = True
End Sub













Regards,

Sam Mathai Chacko


On Wed, Feb 1, 2012 at 10:27 PM, Kiran Kancherla wrote:

>
> 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 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Rajan_Verma]

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. 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 BlackBerryR from Vodafone

  _  

From: resp...@gmail.com 

Sender: excel-macros@googlegroups.com 

Date: Wed, 1 Feb 2012 16:48:37 +

To: 

ReplyTo: excel-macros@googlegroups.com 

Cc: NOORAIN ANSARI

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

 

Congrats NOORAIN ANSARI

Sent from my BlackBerryR smartphone from Airtel Ghana

  _  

From: xlstime  

Sender: excel-macros@googlegroups.com 

Date: Wed, 1 Feb 2012 22:17:19 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Cc: NOORAIN ANSARI

Subject: 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 consistent contributor to this excel forum but has
acheived this recognition for first time.
 

About Noorain Ansari :

noorain.jpg

 

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com   &
www.noorain-ansari.blogspot.com  

 

Noorain, Many thanks for all your great support to group. Keep it up


Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
 
Keep posting.
 
Regards
Ayush Jain
Group Manager

Microsoft MVP

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com




-- 
.

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES 

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

[Rajan_Verma]

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 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 Noorain Ansari :

noorain.jpg

 

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com   &
www.noorain-ansari.blogspot.com  

 

Noorain, Many thanks for all your great support to group. Keep it up


Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
 
Keep posting.
 
Regards
Ayush Jain
Group Manager

Microsoft MVP

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Kiran Kancherla]

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.com
Subject: 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
Dim tbxUsrFld As MSHTML.HTMLInputElement
Dim btnSubmit As MSHTML.HTMLInputElement
On Error Goto Err_Hnd
 'Create Internet Explorer Object
Set objIE = New SHDocVw.InternetExplorer
 'Navigate the URL
objIE.navigate strURL_c
 'Wait for page to load
Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
 'Get document object
Set ieDoc = objIE.document
 'Get username/password fields and submit button.
Set tbxPwdFld = ieDoc.all.Item("USER")
Set tbxUsrFld = ieDoc.all.Item("PASSW")
Set btnSubmit = ieDoc.all.Item("SUBMIT")

 'Fill Fields
tbxPwdFld.Value = strUsr_c
tbxUsrFld.Value = strPwd_c
 'Click submit
btnSubmit.Click
 'Wait for page to load
Do Until objIE.readyState = READYSTATE_COMPLETE: Loop
Err_Hnd: '(Fail gracefully)
objIE.Visible = True
End Sub













Regards,

Sam Mathai Chacko


On Wed, Feb 1, 2012 at 10:27 PM, Kiran Kancherla wrote:

>
> 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 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[xlstime]

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 Mains Fail 19:56:46   19:56:56   Rectifier Fail
> 19:56:46
>
>
>
> Req data:
>
>   indus id Text  IN-1008993 DG on load 12:16,Mains fail 12:14  IN-1009598 
> Mains
> fail 19:56,Rectifier fail 19:56
>
> plz find attachment of file
>
>
> *Thanks&Regards*
>
> * *
>
> *   **Veerendra.Vanam*
>
>   *TOC TEAM*
> * *  *Bhagyanagar Electrical & Contractors**
> ****H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>   Hyderabad-500072,-Andhra Pradesh
> **   **91-9177-444-840**,*
>
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Copy of problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[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 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 Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Seraj Alam]

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 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 Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Bé Trần Văn]

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 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 Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
>> , Priyanka, Lokesh and other folks for helping excel enthusiasts
>> voluntarily !! Keep it up !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

Noorain.
Congratulations to you, is recognized as the most useful members of the
forum.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Avinash Patil]

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 attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
>
>
--
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
Sent from Gmail Mobile

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Avinash Patil]

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 attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
>
>
--
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
Sent from Gmail Mobile

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Rohan]

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, 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Rohan]

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 concern.

Thanks,
Rohan.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Excel_Lover]

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 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, Feb 1, 2012 at 11:28 AM
 Subject: Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it...
 you will like it
 To: excel-macros@googlegroups.com


 I am unable to download the Add in, can you please email it to me.
 Regards

 On Mon, Jan 30, 2012 at 9:09 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Group,
>
> Find attached the Excel add-ins, which simply fantastic in our routine
> work.
> Just open the attachment in excel file and you can see there is an
> additional menu appears to your excel tab “My Menu”
> develop by one of our Group member Mr. Ashish Koul
>
> You can see almost all the functions we use are available in the menu
>
> http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html
>
> --
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  
> *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



 --
 Shaikh AbdulGani A R
 ITP, STP, TRP, STRP

  --
 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 question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



 --
 Thanks & regards,
 Noorain Ansari
  
 *http://excelmacroworld.blogspot.com/*
 *http://noorain-ansari.blogspot.com/*


>>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>>  --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to ex

$$Excel-Macros$$ To excel macro team

[Pascal Baro]

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 Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[dguillett1]

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 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 Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Asa Rossoff]

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 - 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 Noorain Ansari :

noorain.jpg

 

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com   &
www.noorain-ansari.blogspot.com  

 

Noorain, Many thanks for all your great support to group. Keep it up


Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
!! Keep it up !!
 
Keep posting.
 
Regards
Ayush Jain
Group Manager

Microsoft MVP

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Asa Rossoff]

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 of Excel
since Excel 97 (with some limitations to support in Excel 2008 on the Mac).

Here are some links with more information:

.http://www.mrexcel.com/tip103.shtml

.http://www.exceluser.com/explore/webqueries_1.htm

.http://www.vertex42.com/News/excel-web-query.html
http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-
parameters/

.
http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter
s-with-web-queries.aspx

 

Asa

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$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 BlackBerryR from Vodafone

Thanks & Regards.

Kiran

 

-- 

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 question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ ExcelTest

[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
David Grugeon

On 31 January 2012 12:28, NOORAIN ANSARI  wrote:

> Dear Group,
>
> Please find attached Excel Test to analyze you excel Skills.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
David Grugeon

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Congrates.

[Mohammed Muneer]

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 this group.

I am really thankful to everyone of our group.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Vijayendra Rao]

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 result.
>
> I have also sorted the list based on project. Please confirm if that is
> what you are looking for.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao 
> wrote:
>
>> Dear All,
>>
>> I want to put index & match formula (or any other formula) in attached
>> file, can you please help me to put the formula.
>>
>> Excel file is attached along with email.
>>
>> Regards,
>> Vijayendra
>> 94491 67631
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Dilip Pandey]

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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
> Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
> !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[dhartikumar]

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 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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru ,
> Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily
> !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Vijayendra Rao]

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@googlegroups.com
> Cc: NOORAIN ANSARI
>  Subject: 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 consistent contributor to this excel forum but has
> > acheived this recognition for first time.
> >
> > *About Noorain Ansari :*
> > [image: noorain.jpg]
> >
> > Noorain is a great poet and keep sharing his thoughts on different topics
> > throgh cool poems. Professionally, he is a Excel aficionado and presently
> > working as senior business analyst in One97 Communication Ltd. He is a MS
> > excel - vba expert and keep sharing his thoughts with this forum. You can
> > follow his blogs for Excel knowledge and cool poems :
> > www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
> >
> > *Noorain, Many thanks for all your great support to group. Keep it up*
> >
> > *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> ,
> > Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily
> > !! Keep it up !!
> > **
> > *Keep posting.
> >
> > Regards
> > Ayush Jain
> > Group Manager
> > Microsoft MVP
> >
> > --
> > 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 question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631

-- 
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 question in the thread of another member

$$Excel-Macros$$ Forrmula need

[chandra sekaran]

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
 1XXX
 ABC
 1500
 150
 6
 2XXX
 ABC
 44000
 4400
 7
 2XXX
 XYZ
 1
 1000
 8
 2YYY
 ABC
 100
 10
 9
 2YYY
 ABC
 95
 10
 10
 2YYY
 ABC
 75
 10
 11
 2YYY
 ABC
 85
 10
 12
 2YYY
 XYZ
 9874




Regards
chandru

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[chhajersandeep]

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
Subject: 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@googlegroups.com
> Cc: NOORAIN ANSARI
>  Subject: 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 consistent contributor to this excel forum but has
> > acheived this recognition for first time.
> >
> > *About Noorain Ansari :*
> > [image: noorain.jpg]
> >
> > Noorain is a great poet and keep sharing his thoughts on different topics
> > throgh cool poems. Professionally, he is a Excel aficionado and presently
> > working as senior business analyst in One97 Communication Ltd. He is a MS
> > excel - vba expert and keep sharing his thoughts with this forum. You can
> > follow his blogs for Excel knowledge and cool poems :
> > www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
> >
> > *Noorain, Many thanks for all your great support to group. Keep it up*
> >
> > *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> ,
> > Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily
> > !! Keep it up !!
> > **
> > *Keep posting.
> >
> > Regards
> > Ayush Jain
> > Group Manager
> > Microsoft MVP
> >
> > --
> > 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 question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
ಧನ್ಯವಾದಗಳು,
ವ

Re: $$Excel-Macros$$ ExcelTest

[Vijayendra Rao]

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
> David Grugeon
>
>
> On 31 January 2012 12:28, NOORAIN ANSARI  wrote:
>
>> Dear Group,
>>
>> Please find attached Excel Test to analyze you excel Skills.
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> David Grugeon
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Excel_Test_N.xls
Description: MS-Excel spreadsheet

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

[Praveena K]

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 & 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 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 Noorain Ansari :*
>>> [image: noorain.jpg]
>>>
>>> Noorain is a great poet and keep sharing his thoughts on different
>>> topics throgh cool poems. Professionally, he is a Excel aficionado and
>>> presently working as senior business analyst in One97 Communication Ltd. He
>>> is a MS excel - vba expert and keep sharing his thoughts with this forum.
>>> You can follow his blogs for Excel knowledge and cool poems :
>>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>>
>>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>>
>>> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema,
>>> Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel
>>> enthusiasts voluntarily !! Keep it up !!
>>> **
>>> *Keep posting.
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> 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 question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> 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 question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> Noorain.
> Congratulations to you, is recognized as the most useful members of the
> forum.
>
>  --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards,
K. Praveena.

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohib

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

[Kiran Kancharla]

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
Excel.

Thanks & Regards,
Kiran


On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff  wrote:

> 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 of
> Excel since Excel 97 (with some limitations to support in Excel 2008 on the
> Mac).
>
> *Here are some links with more information:*
>
> **·**http://www.mrexcel.com/tip103.shtml
>
> **·**http://www.exceluser.com/explore/webqueries_1.htm
>
> **·**http://www.vertex42.com/News/excel-web-query.html
>
> http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-parameters/
> 
>
> **·**
> http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameters-with-web-queries.aspx
> 
>
> ** **
>
> Asa
>
> ** **
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Kiran Kancherla
> Sent: Wednesday, February 01, 2012 8:58 AM
> To: excel-macros@googlegroups.com
> Subject: $$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 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 question in the thread of another member.
>
> ** **
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> ** **
>
> 4) Acknowledge the responses you receive, good or bad.
>
> ** **
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. 
>
> ** **
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> ** **
>
>
> --
> 
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & Regards,
Kiran
9920456606

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Asa Rossoff]

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: $$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
Excel. 

 

Thanks & Regards,

Kiran

 

 

On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff  wrote:

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 of Excel
since Excel 97 (with some limitations to support in Excel 2008 on the Mac).

Here are some links with more information:

.http://www.mrexcel.com/tip103.shtml

.http://www.exceluser.com/explore/webqueries_1.htm

.http://www.vertex42.com/News/excel-web-query.html
http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-
parameters/

.
http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter
s-with-web-queries.aspx

 

Asa

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$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 BlackBerryR from Vodafone

Thanks & Regards.

Kiran

 

-- 

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 question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





 

-- 

Thanks & Regards,

Kiran

9920456606

 

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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

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

[vvkgupta tycoon]

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, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Kiran Kancherla]

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: 
Reply-To: excel-macros@googlegroups.com
Subject: 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: $$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
Excel. 

 

Thanks & Regards,

Kiran

 

 

On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff  wrote:

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 of Excel
since Excel 97 (with some limitations to support in Excel 2008 on the Mac).

Here are some links with more information:

.http://www.mrexcel.com/tip103.shtml

.http://www.exceluser.com/explore/webqueries_1.htm

.http://www.vertex42.com/News/excel-web-query.html
http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-
parameters/

.
http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter
s-with-web-queries.aspx

 

Asa

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$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 BlackBerryR from Vodafone

Thanks & Regards.

Kiran

 

-- 

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 question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





 

-- 

Thanks & Regards,

Kiran

9920456606

 

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 
-

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

[Asa Rossoff]

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 merge and
manipulate data from multiple sources), and then use an Excel Web Query to
fetch that.  "Pipes" can be password protected with both services.

 

However, making a direct connection and parsing the data yourself (as in
your IE manipulation request) would be more secure than allowing
confidential data to pass through third-party servers with Yahoo or DERI
Pipes.

 

I will leave the IE stuff to others, as I haven't done it in many years and
don't have any ready examples. (Looks like Sam posted a good starting off
point)

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 9:34 PM
To: excel-macros@googlegroups.com
Subject: 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 BlackBerryR from Vodafone
Thanks & Regards.
Kiran

  _  

From: "Asa Rossoff"  

Sender: excel-macros@googlegroups.com 

Date: Wed, 1 Feb 2012 21:27:42 -0800

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: 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: $$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
Excel. 

 

Thanks & Regards,

Kiran

 

 

On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff  wrote:

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 of Excel
since Excel 97 (with some limitations to support in Excel 2008 on the Mac).

Here are some links with more information:

.http://www.mrexcel.com/tip103.shtml

.http://www.exceluser.com/explore/webqueries_1.htm

.http://www.vertex42.com/News/excel-web-query.html
http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-
parameters/

.
http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter
s-with-web-queries.aspx

 

Asa

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$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 BlackBerryR from Vodafone

Thanks & Regards.

Kiran

 

-- 

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 question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures a

Re: $$Excel-Macros$$ Forrmula need

[The Viper]

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 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
>  1XXX
>  ABC
>  1500
>  150
>  6
>  2XXX
>  ABC
>  44000
>  4400
>  7
>  2XXX
>  XYZ
>  1
>  1000
>  8
>  2YYY
>  ABC
>  100
>  10
>  9
>  2YYY
>  ABC
>  95
>  10
>  10
>  2YYY
>  ABC
>  75
>  10
>  11
>  2YYY
>  ABC
>  85
>  10
>  12
>  2YYY
>  XYZ
>  9874
>
>
>
>
> Regards
> chandru
>
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Great day,*
*viper*

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


SAMPLE.xls
Description: MS-Excel spreadsheet

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

[Kiran Kancherla]

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: $$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 merge and
manipulate data from multiple sources), and then use an Excel Web Query to
fetch that.  "Pipes" can be password protected with both services.

 

However, making a direct connection and parsing the data yourself (as in
your IE manipulation request) would be more secure than allowing
confidential data to pass through third-party servers with Yahoo or DERI
Pipes.

 

I will leave the IE stuff to others, as I haven't done it in many years and
don't have any ready examples. (Looks like Sam posted a good starting off
point)

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 9:34 PM
To: excel-macros@googlegroups.com
Subject: 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 BlackBerryR from Vodafone
Thanks & Regards.
Kiran

  _  

From: "Asa Rossoff"  

Sender: excel-macros@googlegroups.com 

Date: Wed, 1 Feb 2012 21:27:42 -0800

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: 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: $$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
Excel. 

 

Thanks & Regards,

Kiran

 

 

On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff  wrote:

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 of Excel
since Excel 97 (with some limitations to support in Excel 2008 on the Mac).

Here are some links with more information:

.http://www.mrexcel.com/tip103.shtml

.http://www.exceluser.com/explore/webqueries_1.htm

.http://www.vertex42.com/News/excel-web-query.html
http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-
parameters/

.
http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameter
s-with-web-queries.aspx

 

Asa

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$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 BlackBerryR from Vodafone

Thanks & Regards.

Kiran

 

-- 

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 question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
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 A

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

[Lakshman Prasad]

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...



From: Ayush Jain 
To: excel-macros  
Cc: NOORAIN ANSARI  
Sent: Wednesday, 1 February 2012 10:11 PM
Subject: $$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 Noorain Ansari :

Noorain is a great poet and keep sharing his thoughts on different topics 
throgh cool poems. Professionally, he is a Excel aficionado and presently 
working as senior business analyst in One97 Communication Ltd. He is a MS excel 
- vba expert and keep sharing his thoughts with this forum. You can follow his 
blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com & 
www.noorain-ansari.blogspot.com

Noorain, Many thanks for all your great support to group. Keep it up

Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , 
Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! 
Keep it up !!
 
Keep posting.
 
Regards
Ayush Jain
Group Manager
Microsoft MVP-- 
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 question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Kris]

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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Subhash Yadav]

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 to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Subhash Chand Yadav

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[Suman]

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 contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 









*Suman Kumar*

*Mob: +91-9810333884*

*RIM-+91-9555629292*

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<><>

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

[PrIyAnKa]

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, February 01, 2012 8:42 AM
>
> *To:* excel-macros
> *Cc:* NOORAIN ANSARI
> *Subject:* $$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 Noorain Ansari :*
>
> [image: noorain.jpg]
>
>  
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
>  
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
>
> *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru
> , Priyanka, Lokesh and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!**
>
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>
> Microsoft MVP
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>