$$Excel-Macros$$ userform need to search & display the value in respective text box

[Prajakt Pande]

Dear Specialist,

Attached the excel file for your reference. with useform.
I want to search via roll on codes (length of roll on codes are fix with 8
digest),
If I put 4 digest in text box of roll on codes and hit the search button
after this other text box suppose to be populate where the value matched
with text box value. Even need to view previous and next value matched by
hitting previous button and next button
For example :-
I enter roll on codes in text box i.e. 123456 and hit the search button
then  it need to show first code in text box of roll on code which is
12345678, then name Rabbit, Duty in 10%  units Y

If hit the next button then it need to show next match value, and if hit
the next button the need to show next matched value, and if hit the
previous button then need to show previous match value.

Roll On Code Name duty in %Unit's
 12345679  Hourse  2% N
 12345610  Lion  0% N
 12345611  Tiger 0% N
 12345678  Rabbit   10%   Y

Please help thanks in advance. Attached the excel file for your reference.

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


ROLL ON CODES.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Power Point Template

[chandra sekaran]

Thanks Noorain.Ansari,

Best Regards
chandru



On Tue, Feb 21, 2012 at 11:12 AM, NOORAIN ANSARI
wrote:

> Dear Chandra,
>
> Please find attached Power point Template.
> Save you PPT as .pps format, It will run automatic..
>
> Hope it might be help to you.
>
>
>
> On Tue, Feb 21, 2012 at 10:05 AM, chandra sekaran 
> wrote:
>
>> Dear all
>>
>> Any one advice to me  Best Power Point Template for my presentation with
>> animation  company realted
>>
>> 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
>>
>
>
>
> --
> 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
>

-- 
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$$ is ther any way to keep subject line while opening outlook new mail

[renuka chari]

hi
Noorain

i know that formula, but i neet To Address,bcc Address  & Subject.  At
a Single glance



thanks







On Feb 19, 11:34 am, NOORAIN ANSARI  wrote:
> Dear Vijay/Renuka,
>
> Please use it to keep subject line while opening new outlook window..
>
> *=HYPERLINK("**mailto:"&G2&"?Subject="&"Ladger*<%22&G2&%22?Subject="&"Ladge­r>
> * statement",G2)*
>
> See attached sheet.
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
> On Sat, Feb 18, 2012 at 2:12 PM, Vijayendra Rao 
> wrote:
>
>
>
>
>
> > Hi Noorain,
>
> > It will work only one cell at a time, is it possible to put subject to
> > multiple cellls at a time.
>
> > Regards,
> > Vijayendra
>
> > 2012/2/17 NOORAIN ANSARI 
>
> >> Hi Renu,
>
> >> Please see attached Screen shot, it might be helpful
>
> >> On Fri, Feb 17, 2012 at 1:17 PM, Renukachari Kasee 
> >> wrote:
>
> >>> *hi*
> >>> *all*
> >>> *can you help me, actually this is older post only*
> >>> *
> >>> *
> >>> *thanks *
>
> >>> --
> >>> 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.
>
> > 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/*
>
>  HyperlinkSelectionExample .xls
> 45KViewDownload- 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.

-

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

[PrIyAnKa]

Dear Akhilesh

ODIN is a software ,where trades are being done of clients,its being used
in sharemarket

On Sun, Feb 19, 2012 at 1:39 PM, airen  wrote:

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

-- 
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$$ Power Point Template

[chandra sekaran]

Dear all

Any one advice to me  Best Power Point Template for my presentation with
animation  company realted

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

$$Excel-Macros$$ Conditional formatting

[Anil Gawli]

Hey dude.

Just select all the cells .
go to Conditional formatting -> manage rules->select new rule
click on format only cells that contain "blanks " and click on format
and select the white color. that's it.

On 2/18/12, 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
>


-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

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


Question.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

[rajeyssh]

Is there any body in the group using spread sheet for NSE, BSE, MCX or
all exchange data. If yes and if you want to share it with the group,
please send it to me.
thanks

-- 
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$$ Rank with override (urgent need)

[dewbro2]

I am working on a spreadsheet with close to 300 shipping lanes and
about 10 carriers per lane.  I have succeeded in ranking each lane by
the lowest to highest freight cost; however, now I need to figure out
how to override the rank so that I can designate a preferred carrier
for a rank position (1 thru 3).  If I designate a rank for a carrrier,
the other ranks need to recalculate to the next position.  Can someone
tell me if this can be down and how?  I need this to wrap up a bid
project, so any help would be greatly appreciated.

The formula I am using to rank is:  =SUMPRODUCT(--($A$2:$A$39=A2),--
(F2>$F$2:$F$39-G2))+1

Sample spreadsheet is provided below.

Thanks

COLUMNS:
A = MSL_ID*, B = CARRIER, C = TOTAL FREIGHT, D = Override of
Rank(Preferred Carriers), E = CURRENT RANK, F = RANK THAT I WANT


AB  C   D   E   F
21075-01022 ABC 855.64  1   4
21075-01022 CDE 875.61  1   2   1
21075-01022 EFG 910.68  2   3   2
21075-01022 DEF 1040.64 4   5
21075-01022 BCD 1100.61 3   5   3
21075-01022 AFN 1157.76 6   7
21075-01022 FGH 1257.64 7   8
21075-02702 FGH 1006.24 1   1
21075-02702 CDE 1032.53 2   2
21075-02702 ABC 1033.1653   3
21075-02702 EFG 1107.63 4   4
21075-02702 BCD 1191.65 5   5
21075-02702 DEF 1241.39 6   6
21075-02702 AFN 1264.57 7   7
21075-04106 CDE 1321.37 2   1   2
21075-04106 BCD 1367.37 3   2   3
21075-04106 ABC 1411.8851   3   1
21075-04106 EFG 1427.36 4   4
21075-04106 FGH 1456.24 5   5
21075-04106 AFN 1551.9  6   6
21075-04106 DEF 1570.69 7   7

-- 
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$$ Help with code please.

[Bob]

There will never be more than 1 of the same number. I just need it to
select the sheet that it's on and then select the cell where it's
located. Thanks in Advance

On Feb 19, 8:58 am, "dguillett1"  wrote:
> 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- 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$$ how to find a text in a folder

[raghu gr]

hi,

Thanks this is very good. thank you

with regards
raghu
On Mon, Feb 20, 2012 at 3:11 PM, xlstime  wrote:

> Hi Raghu,
>
>
> you can use "*Agent Ransack *" searching software
>
> http://mythicsoft.com/page.aspx?type=agentransack&page=home
>
>  On Sun, Feb 19, 2012 at 11:41 PM, raghu gr wrote:
>
>>  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
>>
>
>
>
> --
> .
>
>
> --
> 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$$ Ok - I will sir, anyway Mr. Assa thanx for the help!

[NOORAIN ANSARI]

Good weblink Asa, thanks for sharing with group..
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm

On Mon, Feb 20, 2012 at 7:30 PM, Asa Rossoff  wrote:

> You're welcome.
>
> You might find the following page useful for simple macro tips and
> examples: http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
> 
>
> (I'm not associated with the website)
>
> Regards-
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mohammed Muneer
> *Sent:* Monday, February 20, 2012 4:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Ok - I will sir, anyway Mr. Assa thanx for
> the help!
>
> ** **
>
> 
>
> ** **
>
> ** **
>
> 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
>



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

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

[dguillett1]

I didn’t do columns F & G so use this
Sub ConsolidateTotalsSAS()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i + 1, 1) = Cells(i, 1) Then
Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
Rows(i + 1).Delete
End If
Next i
End Sub


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

From: Aamir Shahzad 
Sent: Monday, February 20, 2012 11:11 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Dear Jorge,


See the third table in attached sheet. 

Aamir Shahzad

On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques  wrote:

  Hi friends, i have a problem, 
  1. i trying to use a report and i have to sum the column H, G, F, if the 
orders numbers are equal and 
  2. leave the information in column B,C,D, gathered. 
  3. The problem is that i was doing it with formulas, but didn´t have a 
dinamic range that´s the first, 
  4. then the system has changed, the report is generated by a sql, so i loose 
the formulas everytime i generate a report and i can´t gather the column B,C,D.
  5. is there any way i can do it, by macro, running it after i push the report 
from SQL? Thank you very much.


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

Aamir Shahzad


-- 
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$$ Looking for a Macro which can capture the keystroke timing....

[Indrajit $nai]

Hi All,

Is there any coding is available which can capture the "Keystroke" in a
Excel file, Like whenever I am pressing alt+ctrl+del or locking the system
it will automatically capture the timing in a Excel file. If the coding is
available then please provide me the same.

Thanks in advance for all of your support.

-- 
Indrajit

Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking any action in
reliance on the contents of this information is strictly prohibited and may
be unlawful.

-- 
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$$ macro tort excel data & email to party

[dguillett1]

Should do it

Sub ConsolidateTotalsSAS()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i + 1, 1) = Cells(i, 1) Then
Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
Rows(i + 1).Delete
End If
Next i
End Sub

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

From: Amit Desai (MERU) 
Sent: Monday, February 20, 2012 10:01 AM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ macro tort excel data & email to party

Dear All,

 

Please find attached sample file. In first sheet there are data that needs to 
be sorted work shop wise. In the second sheet email ids are mentioned where we 
need to send those sorted data per workshop.

 

Please let me know if we have macro for that.

 

Best Regards,

Amit

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Maries
Sent: 20 February 2012 21:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro for excel data to email

 

Check these links...

http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html

http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html




On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU)  
wrote:

Dear Friends,

 

Is there any macro for sending excel data to emails of different vendors?

 

Best Regards,

Amit

 

 




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 communications are timely, 
secure or free from computer virus or other defect.

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




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 war

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

[Aamir Shahzad]

Dear Jorge,

See the third table in attached sheet.

Aamir Shahzad

On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques  wrote:

> Hi friends, i have a problem,
> 1. i trying to use a report and i have to sum the column H, G, F, if the
> orders numbers are equal and
> 2. leave the information in column B,C,D, gathered.
> 3. The problem is that i was doing it with formulas, but didn´t have a
> dinamic range that´s the first,
> 4. then the system has changed, the report is generated by a sql, so i
> loose the formulas everytime i generate a report and i can´t gather the
> column B,C,D.
> 5. is there any way i can do it, by macro, running it after i push the
> report from SQL? Thank you very much.
>
>
> --
> 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,

Aamir Shahzad

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


data aglomeration.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ macro for excel data to email

[Amit Desai (MERU)]

Thanks. Email is being sent...but I need to following steps;


1)  Sort the data as per Vendors from first sheet,

2)  Email to each vendor as per second sheet.

3)  Cc to amit.de...@merucabs.com

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 20 February 2012 22:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro for excel data to email

Dear Amit

Please try it..

Sub maildata()
Dim a As Workbook
Dim data As Range
Set data = ThisWorkbook.Sheets(1).UsedRange
data.Copy
Set a = Workbooks.Add
a.Sheets(1).Cells(1, 1).Select
ActiveSheet.Paste
MsgBox ThisWorkbook.Path
a.SaveAs ThisWorkbook.Path & "Automatic_ Email.xls"
a.Close
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim SigString As String
Dim Signature As String


Application.ScreenUpdating = False
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
With olMail
.To = "noorain.ans...@gmail.com"
.CC = "noorain.ans...@one97.net"
 .Subject = "Incoming Status!"
.Body = "Messages " & vbCrLf & vbCrLf & " Thanks " & vbCrLf & "Regards" & 
vbCrLf & " Noorain Ansari"
.Attachments.Add ThisWorkbook.Path & "Automatic_ Email.xls"
.Send
 End With

Set olMail = Nothing
'Kill ThisWorkbook.Path & "\abc1.xls"
End Sub

See attached sheet..

On Mon, Feb 20, 2012 at 9:00 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Friends,

Is there any macro for sending excel data to emails of different vendors?

Best Regards,
Amit



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 communications are timely, 
secure or free from computer virus or other defect.
--
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 

Re: $$Excel-Macros$$ List Box Like Tally Software

[chandra sekaran]

Dear Maries ,

First of i would thanks for valuable effort , but what i expected  like
this only if Activate D1 Cell then Immdiataly like below Unique Customer
will shown below on the D1 Cell , than i Enter  Lletter  than Start
with L only Bold & selected  like that .


   *Cutomer  Name* Lotus  ABC COMPAY  Adako TarimForward
InternationalHAND ASSO*LOTUS 123 PVT* ***LOTUS PVT* **MURUGA
COPANY LTDReckitt BenckiserSCJ ArgentinaVAPCO XYZ  LTD


Thanks for your help

Regards
chandru












On Mon, Feb 20, 2012 at 8:28 PM, Maries  wrote:

> Hi,
>
> I got your logic. Check the attachment.
>
> Type your text in cell D1 & Enter. It will give answer.
>
> Regards,
>
> MARIES.
>
>
> On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran 
> wrote:
>
>> Hi maries,
>>
>> thanks for your Reply,
>>
>> MyOutput Sheet  D1 Activate  then  My List of Cutomer  may
>> shwon  seperate  list box or Below D1 Cell   there itself we want to select
>> or  like  sheet Name  Tally List box like that  if possible  [ First time i
>> do not know what are the customer are there in my Data  so once D1 is
>> Activate  Unique My Cutomer will display   if possible  please 
>>
>> Regards
>> chandru
>>
>>
>>
>>
>>
>> On Mon, Feb 20, 2012 at 5:54 PM, Maries  wrote:
>>
>>> Hi,
>>>
>>> Find the attached file. If you type first name in search cell,
>>> respective datas will show below.
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>>
>>> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran >> > wrote:
>>>
 Dear all
 Here with attached  List Box like Tally   is this possible with
 excelonce  Active  List box or Cell   shown under  all name  after
 enter first letter  than showing start with all names  like that
 Advance Thanks for all

 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

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

$$Excel-Macros$$ Help on gathering duplicate summing and counting

[Jorge Marques]

Hi friends, i have a problem,
1. i trying to use a report and i have to sum the column H, G, F, if the
orders numbers are equal and
2. leave the information in column B,C,D, gathered.
3. The problem is that i was doing it with formulas, but didn´t have a
dinamic range that´s the first,
4. then the system has changed, the report is generated by a sql, so i
loose the formulas everytime i generate a report and i can´t gather the
column B,C,D.
5. is there any way i can do it, by macro, running it after i push the
report from SQL? Thank you very much.

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


data aglomeration.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ macro tort excel data & email to party

[Amit Desai (MERU)]

Dear All,

Please find attached sample file. In first sheet there are data that needs to 
be sorted work shop wise. In the second sheet email ids are mentioned where we 
need to send those sorted data per workshop.

Please let me know if we have macro for that.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Maries
Sent: 20 February 2012 21:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro for excel data to email

Check these links...

http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html

http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html


On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Friends,

Is there any macro for sending excel data to emails of different vendors?

Best Regards,
Amit



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 communications are timely, 
secure or free from computer virus or other defect.
--
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


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 communications are timely, 
secure or free from computer virus or other defect.

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

Re: $$Excel-Macros$$ macro for excel data to email

[Maries]

*Check these links...*

http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html

http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html



On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU)
wrote:

>  Dear Friends,
>
> ** **
>
> Is there any macro for sending excel data to emails of different vendors?*
> ***
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> --
> 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 communications are timely, secure or
> free from computer virus or other defect.
>
> --
> 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$$ macro for excel data to email

[Amit Desai (MERU)]

Dear Friends,

Is there any macro for sending excel data to emails of different vendors?

Best Regards,
Amit



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 communications are timely, 
secure or free from computer virus or other defect.

-- 
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$$ Ok - I will sir, anyway Mr. Assa thanx for the help!

[Asa Rossoff]

You're welcome.

You might find the following page useful for simple macro tips and examples:
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm

(I'm not associated with the website)

Regards-

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: Monday, February 20, 2012 4:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ok - I will sir, anyway Mr. Assa thanx for the
help!

 



 

 

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

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

[dguillett1]

Agree fully on the subject line. It is a problem with this group. 
sub runallmacros()
call macro1
call macro2
call macro3
end sub

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

From: xlstime 
Sent: Monday, February 20, 2012 2:54 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Hi, Friends I have a ?


Hi Mohammed Muneer,

you must be use proper subject line or Use concise, accurate thread titles.
for get quick attention or answered.
  

On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer  wrote:

  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




-- 
.

-- 
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$$ Ok - I will sir, anyway Mr. Assa thanx for the help!

[Mohammed Muneer]

 

 

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$$ List Box Like Tally Software

[chandra sekaran]

Hi maries,

thanks for your Reply,

MyOutput Sheet  D1 Activate  then  My List of Cutomer  may shwon  seperate
list box or Below D1 Cell   there itself we want to select or  like  sheet
Name  Tally List box like that  if possible  [ First time i do not know
what are the customer are there in my Data  so once D1 is Activate  Unique
My Cutomer will display   if possible  please 

Regards
chandru





On Mon, Feb 20, 2012 at 5:54 PM, Maries  wrote:

> Hi,
>
> Find the attached file. If you type first name in search cell, respective
> datas will show below.
>
> Regards,
>
> MARIES.
>
>
> On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran 
> wrote:
>
>> Dear all
>> Here with attached  List Box like Tally   is this possible with excel
>> once  Active  List box or Cell   shown under  all name  after enter first
>> letter  than showing start with all names  like that
>> Advance Thanks for all
>>
>> 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
>>
>
>   --
> 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$$ I need a help with connecting to SQL Server 2008

[Markkim]

Hi

it's getting frustrated.

I tried to use Excel 2007 to extract data from SQL Server 2008 R2.

But I think it fails to connect to the server.

>From Excel 2007, connection from data tab, I can access to the server
and get data. the following is the connection string I got from the
property.

Provider=SQLOLEDB.1;Persist Security Info=True;User
ID=ReadingEggTeam;Data Source=reportsrv;Use Procedure for
Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MSERVER-
DELL;Use Encryption for Data=False;Tag with column collation when
possible=False;Initial Catalog=ReadingEggTracking

>From a book called 'Wrox Excel 2007 VBA Programmers Reference', I
tried to do the following below and I get an error at
"rsData.Open sSQL, sConnect, adOpenForwardOnly, adLockReadOnly,
adCmdText"

Dim rsData As ADODB.Recordset
Dim sConnect As String
Dim sSQL As String

' Create the connection
sConnect = "Provider=SQLOLEDB;" & _
"Data Source=ReportSrv\report; Initial Catalog= ReadingEggTracking;" &
_
"User ID=ReadingEggTeam; Password=1234;" & _
"Network Library=dbmsscon"

sSQL = "SELECT * from TrialTracking;"

' Create the Recordset object and run the query.

Set rsData = New ADODB.Recordset

rsData.Open sSQL, sConnect, adOpenForwardOnly, adLockReadOnly,
adCmdText




Then I tried to use the connection string I got it from the connection
property. It didn't work.


I think there is something wrong with connection string. Can you tell
me what it is wrong pleasE?

I can not figure it out... T T;;

cheers

-- 
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$$ Date (value pest) query

[Kal xcel]

tahnks a lot to all

On Sat, Feb 18, 2012 at 12:13 PM, Asa Rossoff  wrote:

>  Hi Kal,
>
> Here's a solution using a UDF (user-defined function).  It solves an issue
> I saw with the other proposals that they will generate a new date any time
> a cell is edited, even if not changed, or even during any worksheet
> calculation.  It also works when multiple serial numbers or document IDs
> are entered or changed in one operation (copy/paste, fill) unlike the
> Worksheet_Change event proposed (although that could be overcome).
>
> ** **
>
> Personally, I would usually prefer a Worksheet_Change event, since
> formulas aren't ideally suited to retaining permanent values, and depending
> on how written, Worksheet_Change could allow for manually
> changing/correcting the date (a formula couldn't do that unless the
> override were entered in another cell).  Worksheet_Change could also only
> calculate a new date if the date cell is empty, offering maximum protection
> against accidental recalculation.  On the other hand, the code would
> probably need to be maintained later if the worksheet layout changes, and
> not everyone is comfortable with that.
>
> ** **
>
> Here's my UDF version that stores the last serial number/key value and
> date in a hidden cell property called ID, allowing it to only calculate a
> new date if the serial number/key value changes:
>
> ** **
>
> Function FreezeDate(KeyValue As String) As Variant
>
> Const IDTag = "FreezeDate", FormatString = "-mm-dd"
>
> Dim lastID As String, newID As String, ParsedID() As String
>
> Dim retDate As Variant
>
> On Error Resume Next
>
> ** **
>
> ' Return empty string if no KeyValue or bug.
>
> retDate = ""
>
> 
>
> ' No KeyValue, no return date
>
> ' -- But the ID is preserved and the last date saved will be returned*
> ***
>
> 'if a matching KeyValue is subsequently provided for this cell
>
> '(useful for copy/paste date preservation)
>
> If KeyValue <> vbNullString Then
>
> With Application.Caller
>
> lastID = .id
>
> ParsedID = Split(lastID, "&")
>
> If UBound(ParsedID) = 2 And ParsedID(0) = IDTag Then
>
> ' Seemingly valid ID found, be ready to return last date**
> **
>
> retDate = CDate(ParsedID(2))
>
> ' Truncate date from lastID for newID/lastID comparison***
> *
>
> lastID = ParsedID(0) & "&" & ParsedID(1)
>
> End If
>
> newID = IDTag & "&" & KeyValue
>
> If newID <> lastID Then
>
> retDate = Date
>
> .id = newID & "&" & Format(retDate, FormatString)
>
> End If
>
> End With
>
> End If
>
> 
>
> FreezeDate = retDate
>
> End Function
>
> ** **
>
> To use this UDF, put it in any module (or a new module) in the Visual
> Basic Editor, then in the date column, use this formula (as written for row
> 2):
>
> =FreezeDate(A2)
>
> ** **
>
> Replace A2 with a reference to any value that you want the date to be
> associated with.  If that value changes, the date will be recalculated, but
> not for any other reason.
>
> ** **
>
> There is a limitation to this UDF:  There are certain symbol characters
> that the KeyValue can't contain or the UDF will malfunction.  That's
> because not all characters can be stored in a cell's ID property (the ID
> property is designed for HTML export use).
>
> ** **
>
> To see how the old date and KeyValue (or serial number) is stored, you can
> use this UDF to view the hidden info:
>
> ** **
>
> Function id(ref As Range)
>
> Application.Volatile
>
> id = ref.id
>
> End Function
>
> ** **
>
> Asa
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kal xcel
> *Sent:* Friday, February 17, 2012 3:00 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Date (value pest) query
>
> ** **
>
> Dear Experts,
>
>  
>
> I am trying to make a document tracker, where I want to put date
> automatically. If you see the attachment, when I am giving serial no.
> Document no. & date will be appeared automatically. But next day that date
> changing to current date which I don’t want. 
>
> Is there any process to keep the date fixed.
>
> Please help.
>
> -- 
>
> *Kalyan Chattopadhyay*
>
>  
>
> *Executive Sales Coordinator*
>
> *R. S. H. Pvt. Ltd.*
>
> ** **
>
> --
> 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 

Re: $$Excel-Macros$$ Pivot table

[Prajakt Pande]

Dear Maries,

Thats right good one.

Thanks & Regards,
Prajakt Pande

On Mon, Feb 20, 2012 at 1:58 PM, Maries  wrote:

> *PFA*
>
> On Thu, Feb 16, 2012 at 10:04 AM, Maries  wrote:
>
>>  Hi,
>>
>> Find the attached file. It will work.
>>
>> Sheets("NDC").Select
>> ActiveWorkbook.Names.Add Name:="datas", RefersToR1C1:= _
>> "=OFFSET(NDC!C1,0,0,COUNTA(NDC!C1),COUNTA(NDC!R1))"
>> ActiveWorkbook.Names("datas").Comment = ""
>>
>> Range("A1").Select
>>
>> ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
>> SourceData:= _
>> "=datas", Version:=xlPivotTableVersion10). _
>> CreatePivotTable TableDestination:="", TableName:="PivotTable21",
>> _
>> DefaultVersion:=xlPivotTableVersion10
>> ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
>> ActiveSheet.Cells(3, 1).Select
>>
>> The above highlight change done in your coding.
>>
>> Regards,
>>
>> MARIES.
>>
>> On Thu, Feb 16, 2012 at 9:12 AM, ashjain2...@yahoo.co.in <
>> ashjain2...@yahoo.co.in> wrote:
>>
>>> Dear Boss,
>>>
>>> Please find the file, Where i am using recording macro.. and get the
>>> pivot
>>> table but every date i go and change the row in macro before run, Every
>>> day data get increasingrequest you to please fix the macro so that in
>>> row will increasing than not need to change row in macro
>>>
>>> Exaple :- today i have 2709 Row but tomorrow will be 2810 and day after
>>> tomorrow it will be 2920 or 3000
>>>
>>> Ashok
>>> -
>>>
>>> --
>>> 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

Re: $$Excel-Macros$$ Needle Gauge Chart Calculation

[hilary lomotey]

Thanks for this Dave, what is the purpose of the offset function you used.
thanks

On Sat, Feb 18, 2012 at 11:27 PM, David Grugeon wrote:

> OK.
>
> first I find the number in the dial which is the greatest number less than
> or equal to the required value.  I use match to find how far down it is
> from J2.  This number goes in P7.
>
> Then I find out the chart value and corresponding angle for that lower
> amount and these go int P8 and Q8
> Next I find the next value (which will be the chart indication above the
> lowest amount greater than the price).
> This goes in P9 and Q9
> Now we can interpolate the actual price by calculating the excess of the
> price over the lower price as a proportion of the gap between the prices.
>  This is used to calculate the angle required (or more precisely the scale
> value required for the needle).  All this is done in the formula in Q11.
>
> The formula in Q11 could be expressed
>
> the angle for the lower threshold +(the price less the lower
> threshold)divided by the difference between the upper and lower thresholds
> multiplied by the difference between the lower and upper angles.
>
> Let me know if this is not clear.
>
> Best regards
> David Grugeon
>
> On 19 February 2012 04:52, hilary lomotey  wrote:
>
>> Wow Dave,and wow again, this is a  gret solution, never mind
>> replying late, this is so incredible. after a while i thought it was
>> not possible, great mind you got over there, thumbs up seven times,
>> but sorry man you need to expalin the relevance of using the offset
>> function there and the formula for getting the angle required. i was
>> just browsing through what you did and cant see how the whole stuff
>> you done applies to the chart. or i guess the angle required is
>> connected to the price, could you kindly explain to me the logic
>> behind this.
>>
>> On 2/18/12, David Grugeon  wrote:
>> > Forgot the attachment
>> >
>> > On 16 February 2012 18:44, hilary lomotey  wrote:
>> >
>> >> Thanks Dave,
>> >>
>> >> thanks a lot for responding, i have attached the file to demonstrate
>> what
>> >> i want to achieve, basically what i want is when a stock is selected i
>> >> want
>> >> the needle to move to price of the stock, the stock prices are within
>> the
>> >> range specified in the file attached headed" prices".
>> >>
>> >>
>> >> On Thu, Feb 16, 2012 at 12:00 AM, David Grugeon 
>> wrote:
>> >>
>> >>> Because the graduations on the dial are non linear (and not even
>> >>> logarithmic) you cannot automatically calculate the values.  You have
>> to
>> >>> do
>> >>> it by trial and error.
>> >>>
>> >>> I have made a new column with my suggestions.  You could fine tune
>> this
>> >>> if you wanted to by using more fractional numbers but for practical
>> >>> purposes my suggestions will probably be adequate.
>> >>>
>> >>> I do not understand exactly what you are trying to do so if this is
>> not
>> >>> OK try giving more of an explanation.
>> >>>
>> >>>
>> >>> On 16 February 2012 00:51, hilary lomotey  wrote:
>> >>>
>>   Dear Experts,
>> 
>>  i have  created a speedometer chart, however i  am trying to
>> calculate
>>  the needle or indicator using the parameters as attached but having
>>  difficulty in doing so, i would be grateful if i get some
>>  suggestions.thanks
>> 
>>  --
>>  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-promot

Re: $$Excel-Macros$$ how to find a text in a folder

[xlstime]

Hi Raghu,


you can use "*Agent Ransack *" searching software

http://mythicsoft.com/page.aspx?type=agentransack&page=home

On Sun, Feb 19, 2012 at 11:41 PM, raghu gr  wrote:

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



-- 
.

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

[xlstime]

Hi Prasad,


you can use *Advance Filter* function with macro recording .

for learn advance filer
http://www.contextures.com/xladvfilter01.html



On Sun, Feb 19, 2012 at 9:19 PM, Prasad Gadgil  wrote:

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



-- 
.

-- 
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$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[Asa Rossoff]

Hello Mohammed,

Agree on the subject line bit.. please use a short decsriptive subject line
- and best not to change the subject line if you post again, it can be more
difficult for others to follow the thread.

 

To your question:  the main part "How to merge the multiple macros in single
program?" - I understand that question. but I don't understand what your
sample data that looks like payroll records has to do with it.  Or what
filtering the payroll data in various ways has to do with it.

 

CALL is a VBA/macro command, as xlstime says that can execute other
VBA/macro procedures.  But, CALL is optional an usually not used. It is as
simple as typing the name of another sub procedure as in this example, which
doesn't use call:

 

Sub Macro1234 ()

'Execute Macro1 if user hits "Yes" button.

If MsgBox("Execute Macro1?",vbYesNo)=vbYes Then Macro1

'Execute Macro2 if userr hits "Yes" button.

If MsgBox("Execute Macro2?",vbYesNo)=vbYes Then Macro2

'Execute Macro3 if user hits "Yes" button.

If MsgBox("Execute Macro3?",vbYesNo)=vbYes Then Macro3

'Execute Macro4 no matter what!!!

Macro4

End Sub

 

Sub Macro1 ()

MsgBox "MACRO 1 !"

End Sub

 

Sub Macro2 ()

MsgBox "MACRO 2!"

End Sub

 

Sub Macro3 ()

MsgBox "MACRO 3 !"

End Sub

 

Sub Macro4 ()

MsgBox "MACRO 4 !"

End Sub

 

Hope this helps.

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of xlstime
Sent: Monday, February 20, 2012 12:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express
properly in my previous mail - so let us have it right now)

 

if i am not wrong u can use CALL macro function 

On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer 
wrote:

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




-- 
.

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

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

[xlstime]

Hi Mohammed Muneer,

you must be use proper subject line or Use concise, accurate thread titles.
for get quick attention or answered.


On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer wrote:

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



-- 
.

-- 
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$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

[xlstime]

if i am not wrong u can use CALL macro function

On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer wrote:

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



-- 
.

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