Re: $$Excel-Macros$$ search via macro like excel

[Maries]

PFA.

*Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))*

On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande wrote:

> Dear all,
>>
>> Roll on codes are maximum 8 digits, I want to search via roll on
>> codes, at least 4 digits,
>> Where ever it matches with sequence, need to update the other
>> information in respective field, with next and previous option,
>> If “Roll on code” is not available then search via NAME. Sheet
>> attached please help.
>> Thanks in advance,
>>
> Thanks & Regards,
> Prajakt Pande
>
> --
> 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

$$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[Mohammed Muneer]

How to merge the Multiple Macro's in single program?

My question is little jovial - but still it is trying to learn some
thing from u masters. Thanx anyway

 

This is only an example, that I put it here to show u exactly what I
want u to help me for. ( in fact, I need the logic - How I can merge the
multiple macros to form a single programming code).

Or else u can do a help by providing me with any website like this that
can fetch me the right/full explanation about the steps involved in
doing so?

 

 

 

 

If my data is like this: (with Filter buttons are on): (filtering
process taken up in anyway with the help of the "Cell" reference (or)
"Button". Its u r choice).

 

Ename

Start Date

End Date

Hours wor

Tot pay

Ded

Net pay

AA

1-Jan-12

31-Jan-12

  40.0 

 2,600.0 

  650.0 

1,950.0 

BB

1-Jan-12

31-Jan-12

  45.0 

 1,800.0 

  450.0 

1,350.0 

CC

1-Jan-12

31-Jan-12

  32.0 

 1,472.0 

  368.0 

1,104.0 

DD

1-Jan-12

31-Jan-12

  60.0 

 2,100.0 

  525.0 

1,575.0 

EE

1-Jan-12

31-Jan-12

  52.0 

 1,664.0 

  416.0 

1,248.0 

FF

1-Jan-12

31-Jan-12

  80.0 

 2,000.0 

  500.0 

1,500.0 

 

 

 

309.0 

   11,636.0 

   2,909.0 

8,727.0 

 

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

$$Excel-Macros$$ Hi, Friends I have a ?

[Mohammed Muneer]

How to merge the Multiple Macro's in single program?

 

 

 

 

 

If my data is like this: (with Filter buttons are on): (filtering
process taken up in anyway with the help of the "Cell" reference (or)
"Button". Its u r choice).

 

Ename

Start Date

End Date

Hours wor

Tot pay

Ded

Net pay

AA

1-Jan-12

31-Jan-12

  40.0 

 2,600.0 

  650.0 

1,950.0 

BB

1-Jan-12

31-Jan-12

  45.0 

 1,800.0 

  450.0 

1,350.0 

CC

1-Jan-12

31-Jan-12

  32.0 

 1,472.0 

  368.0 

1,104.0 

DD

1-Jan-12

31-Jan-12

  60.0 

 2,100.0 

  525.0 

1,575.0 

EE

1-Jan-12

31-Jan-12

  52.0 

 1,664.0 

  416.0 

1,248.0 

FF

1-Jan-12

31-Jan-12

  80.0 

 2,000.0 

  500.0 

1,500.0 

 

 

 

309.0 

   11,636.0 

   2,909.0 

8,727.0 

 

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

$$Excel-Macros$$ search via macro like excel

[Prajakt Pande]

Dear all,

Roll on codes are maximum 8 digits, I want to search via roll on
codes, at least 4 digits,
Where ever it matches with sequence, need to update the other
information in respective field, with next and previous option,
If “Roll on code” is not available then search via NAME. Sheet
attached please help.
Thanks in advance,

-- 
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$$ Update Data in Excel sheets from Master file

[Prasad Gadgil]

*Dear Friends,*

>
I am having data in master sheet & wish to different sheets based on  "Name
of the party"
as and when i update master sheet*

Thanks & Regards*
*Prasad Gadgil*
Cell: 9819442088

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


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

Re: $$Excel-Macros$$ combo box or list box help

[Prajakt Pande]

Dear Noorain,

Thnak for your help

On Feb 16, 9:12 pm, NOORAIN ANSARI  wrote:
> Dear Prajakt,
>
> Please see attached sheet with explanation.
>
> On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote:
>
>
>
>
>
> > Dear,
>
> > Good job, can you tell me how you made this.
>
> > Regards,
> > Prajakt Pande
>
> > On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote:
>
> >> Hi,
> >> Please chek it
>
> >> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> >> chatterjee.kolk...@gmail.com> wrote:
>
> >>> Dear Experts,
>
> >>> Please see the attachment.  I like store AREA1, AREA2 AND AREA3 in a
> >>> combo box or in Text Box.
>
> >>> Base on the value store in the combo Box or list box I like the name
> >>> should display in the sheets
>
> >>> suppose when i select in the combo box AREA1
>
> >>> It will display the name store in the AREA1 and so on.
>
> >>> Thanking you in Advance
>
> >>> Sanjib
>
> >>> --
> >>> -
>
> >>> --
> >>> 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,
> > Prajakt Pande
> > +971551388482
> > **
>
> >  --
> > 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://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>  Solved(With Process).xlsx
> 15KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
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$$ I Macros tutorial & software need

[Maries]

http://wiki.imacros.net/Main_Page

On Sun, Feb 19, 2012 at 8:46 PM, NOORAIN ANSARI wrote:

> Dear vijay,
>
> IMacro is a software you can learn it through study material.
> But i can't say any thing regarding good future.
>
> On Sun, Feb 19, 2012 at 12:22 AM, vijayajith VA 
> wrote:
>
>> Hi,
>>
>>
>> Is thr good future in learning Imacros?
>> Thanks
>>
>>
>> On Fri, Feb 17, 2012 at 11:12 PM, xlstime  wrote:
>>
>>> Hi Amit,
>>>
>>> iMacros is the *only* software that can *automate both Internet
>>> Explorer and Firefox.* You can control both web browsers directly from
>>> Excel.* iMacros works with every website *and can automate even the
>>> most complicated websites that use dialog boxes, frames, Javascript and
>>> AJAX can be automated. *Where other software fails, iMacros canautomate it.
>>> *
>>>
>>>
>>>
>>>  On Fri, Feb 17, 2012 at 5:46 PM, Amit Desai (MERU) <
>>> amit.de...@merucabs.com> wrote:
>>>
  Dear All,

 ** **

 Please explain what do you mean by imacros..

 ** **

 Best Regards,

 Amit

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
 *Sent:* 17 February 2012 15:04
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ I Macros tutorial & software need

 ** **

 Dear Veeru,

 Please find attached manual of Imacros.

 On Fri, Feb 17, 2012 at 1:15 PM, Veeru TOC  wrote:
 



 -- Dear group ,

  

  Anybody have mererial for imacros .

  

  

 *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
 *
 *   *Error! Filename not specified.*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




 -- 

 Thanks & regards,

 Noorain Ansari

 *http://noorainansari.com/*

 *http://excelmacroworld.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

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this m

Re: $$Excel-Macros$$ Conditional formatting

[Excel_Lover]

Sorry,The formula should be =" " (with a space) like this, as there is
formulas in your sheet.

On Sun, Feb 19, 2012 at 9:08 PM, Excel_Lover  wrote:

> Dear,
>
> Hope you are stuck in blank cells formatting, this can be done as follows,
>
> In Excel 2007,
>
> Conditional formatting => Highlight Cell Rules => Equal to, type formula
> ="" (not just "")
>
>
> On Sun, Feb 19, 2012 at 4:41 PM, PRAVESH KUMAR 
> wrote:
>
>> Hi,
>>
>>
>>
>> Please Help.
>>
>> On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR > > wrote:
>>
>>> HI,
>>>
>>>
>>> Please help...for conditional formatting
>>>
>>>
>>> PFA attached file
>>>
>>>
>>>
>>>
>>> Thanks
>>>
>>> Pravesh Kashyap
>>>
>>> --
>>> 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$$ how to find a text in a folder

[raghu gr]

Sir,


Sir some error in line,

Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File
Names").Range("c2").Value & "*", After:=wk.Cells(1, 1), _
LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)

pls help me.

Thank you
Raghu

-- 
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$$ Conditional formatting

[Excel_Lover]

Dear,

Hope you are stuck in blank cells formatting, this can be done as follows,

In Excel 2007,

Conditional formatting => Highlight Cell Rules => Equal to, type
formula =""(not just "")


On Sun, Feb 19, 2012 at 4:41 PM, PRAVESH KUMAR wrote:

> Hi,
>
>
>
> Please Help.
>
> On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR 
> wrote:
>
>> HI,
>>
>>
>> Please help...for conditional formatting
>>
>>
>> PFA attached file
>>
>>
>>
>>
>> Thanks
>>
>> Pravesh Kashyap
>>
>> --
>> 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$$ I Macros tutorial & software need

[NOORAIN ANSARI]

Dear vijay,

IMacro is a software you can learn it through study material.
But i can't say any thing regarding good future.

On Sun, Feb 19, 2012 at 12:22 AM, vijayajith VA wrote:

> Hi,
>
>
> Is thr good future in learning Imacros?
> Thanks
>
>
> On Fri, Feb 17, 2012 at 11:12 PM, xlstime  wrote:
>
>> Hi Amit,
>>
>> iMacros is the *only* software that can *automate both Internet Explorer
>> and Firefox.* You can control both web browsers directly from Excel.*iMacros 
>> works with every website
>> *and can automate even the most complicated websites that use dialog
>> boxes, frames, Javascript and AJAX can be automated. *Where other
>> software fails, iMacros can automate it.*
>>
>>
>>
>>  On Fri, Feb 17, 2012 at 5:46 PM, Amit Desai (MERU) <
>> amit.de...@merucabs.com> wrote:
>>
>>>  Dear All,
>>>
>>> ** **
>>>
>>> Please explain what do you mean by imacros..
>>>
>>> ** **
>>>
>>> Best Regards,
>>>
>>> Amit
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
>>> *Sent:* 17 February 2012 15:04
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ I Macros tutorial & software need
>>>
>>> ** **
>>>
>>> Dear Veeru,
>>>
>>> Please find attached manual of Imacros.
>>>
>>> On Fri, Feb 17, 2012 at 1:15 PM, Veeru TOC  wrote:*
>>> ***
>>>
>>>
>>>
>>> -- Dear group ,
>>>
>>>  
>>>
>>>  Anybody have mererial for imacros .
>>>
>>>  
>>>
>>>  
>>>
>>> *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
>>> *
>>> *   *Error! Filename not specified.*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
>>>
>>>
>>>
>>>
>>> -- 
>>>
>>> Thanks & regards,
>>>
>>> Noorain Ansari
>>>
>>> *http://noorainansari.com/*
>>>
>>> *http://excelmacroworld.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
>>>
>>> --
>>> Disclaimer: This message and its attachments contain confidential
>>> information and may also contain legally privileged information. This
>>> message is intended solely for the named addressee. If you are not the
>>> addressee indicated in this message (or authorized to receive for
>>> addressee), you may not copy or deliver any part of this message or its
>>> attachments to anyone or use any part of this message or its attachments.
>>> Rather, you should permanently delete this message and its attachments (and
>>> all copies) from your system and kindly notify the sender by reply e-mail.
>>> Any content of this message and its attachments that does not relate to the
>>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>>> been sent or endorsed by any of them. Email communications are not private
>>> and no warranty is made that e-mail communicat

Re: $$Excel-Macros$$ Help with code please.

[dguillett1]

If you are saying you want to look for it on all sheets you can wrap in a 
loop

for each ws in worksheets
ws.Select
Cells.Find(What:=IndividualSearch, 
LookIn:=xlValues,LookAt:=xlWhole).Activate

next ws

Or, are you saying there could be more than ONE hit?? BTW you don't need to 
select to work with the found item. More info??


Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Bob

Sent: Sunday, February 19, 2012 6:33 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Help with code please.

I almost have the code the way I need it. BUT I want it to Find
everything within in the same Workbook, not just on the Index
Worksheet. Thanks in advance!!!

Private Sub CommandButton1_Click()
Dim IndividualSearch As String
IndividualSearch = InputBox("What's the part number you're looking
for?", "Name Search entry box.")
If IndividualSearch = "" Then Exit Sub
On Error GoTo ErrorHandler
Worksheets("Index").Select
Cells.Find(What:=IndividualSearch, LookIn:=xlValues,
LookAt:=xlWhole).Activate
Exit Sub
ErrorHandler:
MsgBox IndividualSearch & " not found.", 64, "No such animal."
End Sub

--
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$$ Conditional formatting

[PRAVESH KUMAR]

Hi,



Please Help.

On Sat, Feb 18, 2012 at 12:38 PM, PRAVESH KUMAR wrote:

> HI,
>
>
> Please help...for conditional formatting
>
>
> PFA attached file
>
>
>
>
> Thanks
>
> Pravesh Kashyap
>
> --
> 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$$ RE: Mr. Don I am really really really thankful to u for help!

[dguillett1]

Glad to help. Noorain’s also worked just fine using formulas. I prefer using 
macros for this 

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mohammed Muneer 
Sent: Saturday, February 18, 2012 10:04 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ RE: Mr. Don I am really really really thankful to u 
for help!

Excellent, u r so nice.

 

Really I was struggling with this bloody problem……….

Good bye to the problemblemblemblemblemblem………..

 

Thanks & Regards,

Muneer,

CC…

 




From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Saturday, February 18, 2012 5:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r 
solved book - plz check.

 

See attached for this AUTOMATIC macro that does not need formulas. Just change 
a1

Private Sub Worksheet_change(ByVal Target As Range)

If Target.Address <> Range("a1").Address Then Exit Sub

Dim lr As Long

 

Rows(8).Resize(Cells(Rows.Count, 1).End(xlUp).Row).Delete

lr = Sheets("Data!").Cells(1, 1).End(xlDown).Row

With Sheets("Data!").Range("a2:p" & lr)

.AutoFilter Field:=1, Criteria1:=Target

.SpecialCells(xlCellTypeVisible).Copy Range("A8")

.AutoFilter

End With

End Sub

 

Don Guillett
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer 

Sent: Friday, February 17, 2012 10:38 PM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r solved 
book - plz check.

 

Dear Noorain can u plz check again there is a some problem confronting to 
execute properly.

 

 

 

 

 

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

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

$$Excel-Macros$$ Help with code please.

[Bob]

I almost have the code the way I need it. BUT I want it to Find
everything within in the same Workbook, not just on the Index
Worksheet. Thanks in advance!!!

Private Sub CommandButton1_Click()
Dim IndividualSearch As String
IndividualSearch = InputBox("What's the part number you're looking
for?", "Name Search entry box.")
If IndividualSearch = "" Then Exit Sub
On Error GoTo ErrorHandler
Worksheets("Index").Select
Cells.Find(What:=IndividualSearch, LookIn:=xlValues,
LookAt:=xlWhole).Activate
Exit Sub
ErrorHandler:
MsgBox IndividualSearch & " not found.", 64, "No such animal."
End Sub

-- 
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$$ Price Download from NSE - Urgent

[airen]

Hi Priyanka,

Can you give me the link from where I can download this Odin. I tried
it on net but unable to find it out.

Thanks
Akhilesh

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