date:20120226

Re: $$Excel-Macros$$ Re: date format

2012-02-26 Thread Maries

Great... Powerful Logic.

On Mon, Feb 27, 2012 at 6:49 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hi Lee, try
>
> For the Week,
>
> =WEEKNUM(TEXT(A1,"\-00\-00"))
>
> For the month,
>
> =TEXT(TEXT(A1,"\-00\-00"),"")
>
> HTH
> Haseeb
>
> --
> 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$$ Find Distance and Time between two cities using Google Map In excel

2012-02-26 Thread PrIyAnKa

Nice one..

On Sat, Feb 25, 2012 at 6:42 PM, Maries  wrote:

> *Great!!! Thanks Ashish...*
>
>
> On Sat, Feb 25, 2012 at 5:01 PM, ashish koul wrote:
>
>> Hi Group
>>
>> Try this udf it will help you in finding the time and distance between
>> two cities using Google Map
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> 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$$ $$Excel-Macros$$ Validate text and number in PAN

2012-02-26 Thread Vijayendra Rao

Thanks Sam, Maries & Haseeb.

All three solutions are working fine.thanks again.

Regards,
Vijayendra

2012/2/27 Haseeb Avarakkan 

> Hi Sam,
>
> I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
> before the fourth digit :-) , like
>
> ABCDE   1D
>
> Hi Vijayendra,
>
> This is my try. Firstly define 3 names to avoid INDIRECT function.
>
> Name: *Alpha*
> On refers to:
> ={"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"}
>
> Name: *Row*
> Refers to: ={1;2;3;4;5}
>
> Name: *Col*
> Refers to: ={6,7,8,9}
>
> Then use this formula in Data Validation >> Custom. Make sure you have
> unselect *Ignore blank*
>
>
> =SUMPRODUCT(ISNUMBER(MATCH(MID(C2,Row,1),Alpha,0))*ISNUMBER(MID(C2,Col,1)+0)*ISNUMBER(MATCH(MID(C2,10,250),Alpha,0)))=20
>
> HTH
> Haseeb
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



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

Regards,
Vijayendra
94491 67631

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Re: $$Excel-Macros$$ date format

2012-02-26 Thread NOORAIN ANSARI

Hi Sara,

Addition in Venkat Formula :

For weeknum
=WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))
For Month
=MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))
On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV  wrote:

> Hi ,
>
> Try This,
>
>
> *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))*
>
>  *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile 
> *
>
>
> On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee  wrote:
>
>> i have date in this format-- 20011012... yrmmdd..  i want to extract week
>> no and month from this date. what is the formula
>>
>> --
>> 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$$ ifError not woking with excel 2003 version

2012-02-26 Thread NOORAIN ANSARI

Dear Chandra,

Please try it..in excel 2003 version

=IF(ISERROR(INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4))),"",INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4)))

-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*
On Mon, Feb 27, 2012 at 10:24 AM, chandra sekaran wrote:

> Dear all,
>
>
>
> IFERROR  function/forumula  is not working excel 2003 verson
>
>
> =_xlfn.IFERROR(INDEX(Data!$A$3:$A$640,SMALL(IF(_xlfn.IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4)),"")
>
> how i modify to excel 2003 version
>
> 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

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

2012-02-26 Thread chandra sekaran

Dear all


this file  not working with excel2003   iserror  function

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) 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$$ ifError not woking with excel 2003 version

2012-02-26 Thread somcpardeshi

Try by using as below
=if(iserror(formula),on error,formula)

Thanks and Regards,

Somnath C Pardeshi

Sent from BlackBerry® on Airtel

-Original Message-
From: chandra sekaran 
Sender: excel-macros@googlegroups.com
Date: Mon, 27 Feb 2012 10:24:13 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ifError not woking with excel 2003 version

Dear all,



IFERROR  function/forumula  is not working excel 2003 verson

=_xlfn.IFERROR(INDEX(Data!$A$3:$A$640,SMALL(IF(_xlfn.IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4)),"")

how i modify to excel 2003 version

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

Re: $$Excel-Macros$$ Pivot table

2012-02-26 Thread Maries

Hi,

This is the third time, you posting the same question. Already
issue rectified .

*Please check this link:*

https://groups.google.com/forum/?fromgroups#!searchin/excel-macros/$20the$20file,$20Where$20i$20am$20using$20recording$20macro..$20and$20get$20the$20pivot$20table$20but$20every$20date$20i$20go$20and$20change$20the$20row$20in$20macro$20before$20run,$20Every$20day$20data$20get$20increasin/excel-macros/kvvQZ0HTMTM/1NY_KL1xP3IJ

Keep on forwarding same mail will not help.

If you want any other way of solution, Please reply with details.

Regards,

MARIES.

On Mon, Feb 27, 2012 at 8:29 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
>
>
> -
>
> --
> 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$$ Excude some sheets in macro

2012-02-26 Thread Cab Boose

Hi

See attachedI workbook. XL2000

Refer to summary sheet

I am wanting to extract data from some sheets into summary sheet.  I can
exclude 1 sheet ok, but when I try to exclude others I get syntax error.

The line of code with problem is:

If Worksheets(k).Name = "summary", "forms", "admin" Then GoTo nextk

I do not want to copy cells in   summary, forms, or admin.  Something to do
with the commas, have tried also without the commas.

Should I clear the summary sheet each time before paste or delete sheet and
make a new one called summary?

Thanks and regards

Charlie Harris

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


ExclSheetsVBA.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN

2012-02-26 Thread Haseeb Avarakkan

Hi Sam,

I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces 
before the fourth digit :-) , like

ABCDE   1D

Hi Vijayendra,

This is my try. Firstly define 3 names to avoid INDIRECT function.

Name: *Alpha*
On refers to: 
={"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"}

Name: *Row*
Refers to: ={1;2;3;4;5}

Name: *Col*
Refers to: ={6,7,8,9}

Then use this formula in Data Validation >> Custom. Make sure you have 
unselect *Ignore blank*

=SUMPRODUCT(ISNUMBER(MATCH(MID(C2,Row,1),Alpha,0))*ISNUMBER(MID(C2,Col,1)+0)*ISNUMBER(MATCH(MID(C2,10,250),Alpha,0)))=20

HTH
Haseeb

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


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

$$Excel-Macros$$ Re: date format

2012-02-26 Thread Haseeb Avarakkan

Hi Lee, try

For the Week,

=WEEKNUM(TEXT(A1,"\-00\-00"))

For the month,

=TEXT(TEXT(A1,"\-00\-00"),"")

HTH
Haseeb

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

2012-02-26 Thread Venkat CV

Hi ,

Try This,

*=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))*

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee  wrote:

> i have date in this format-- 20011012... yrmmdd..  i want to extract week
> no and month from this date. what is the formula
>
> --
> 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$$ Pivot uncheck All

2012-02-26 Thread dguillett1

http://www.contextures.com/xlPivot05.html 

 
http://www.ozgrid.com/VBA/pivot-table-fields.htm 
or this idea

For Each pf In pt.DataFields
pf.Orientation = xlHidden
Next pf 

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

From: Kiran Kancharla 
Sent: Sunday, February 26, 2012 12:15 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Pivot uncheck All


Hi All, 

Below is the Macro I have recorded for unchecking the Pivot Table.

ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage = 
"(All)"

With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month")
.PivotItems("Jan").Visible = False
.PivotItems("Feb").Visible = True
End With

In the real case I have More than the 500 points to uncheck. 

I need macro to uncheck all selected in Pivot table and select only 1.

I have a separate macro to Select the required point. 

Please help.

I cannot attach the sheet as it has client information.
-- 

Thanks & Regards,
Kiran
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread Kiran Kancharla

Thanks a lot.

Will update you tomorrow on this..

Thanks,
Kiran

On Sun, Feb 26, 2012 at 11:57 PM, xlstime  wrote:

> you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters
>
>
>
>
>
> At the top of the window, on the Ribbon, click the *Options* tab under 
> *PivotTable
> Tools*. In the *Actions* group, click *Clear*, and then click *Clear
> Filters*. Be sure you really want to do this before you undo all your
> selections.
>
>
> On Sun, Feb 26, 2012 at 11:45 PM, Kiran Kancharla wrote:
>
>>
>> Hi All,
>>
>> Below is the Macro I have recorded for unchecking the Pivot Table.
>>
>>
>> ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage
>> = "(All)"
>>
>> With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month")
>> .PivotItems("Jan").Visible = False
>> .PivotItems("Feb").Visible = True
>> End With
>>
>> In the real case I have More than the 500 points to uncheck.
>>
>> I need macro to uncheck all selected in Pivot table and select only 1.
>>
>> I have a separate macro to Select the required point.
>>
>> Please help.
>>
>> I cannot attach the sheet as it has client information.
>> --
>> Thanks & Regards,
>> Kiran
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> .
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & Regards,
Kiran
9920456606

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Re: $$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread xlstime

you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters

or

At the top of the window, on the Ribbon, click the *Options* tab under
*PivotTable
Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters
*. Be sure you really want to do this before you undo all your selections.

On Sun, Feb 26, 2012 at 11:45 PM, Kiran Kancharla wrote:

>
> Hi All,
>
> Below is the Macro I have recorded for unchecking the Pivot Table.
>
>
> ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage
> = "(All)"
>
> With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month")
> .PivotItems("Jan").Visible = False
> .PivotItems("Feb").Visible = True
> End With
>
> In the real case I have More than the 500 points to uncheck.
>
> I need macro to uncheck all selected in Pivot table and select only 1.
>
> I have a separate macro to Select the required point.
>
> Please help.
>
> I cannot attach the sheet as it has client information.
> --
> Thanks & Regards,
> Kiran
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
.

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

$$Excel-Macros$$ Pivot uncheck All

2012-02-26 Thread Kiran Kancharla

Hi All,

Below is the Macro I have recorded for unchecking the Pivot Table.

ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage
= "(All)"

With ActiveSheet.PivotTables("PivotTable2").PivotFields("Month")
.PivotItems("Jan").Visible = False
.PivotItems("Feb").Visible = True
End With

In the real case I have More than the 500 points to uncheck.

I need macro to uncheck all selected in Pivot table and select only 1.

I have a separate macro to Select the required point.

Please help.

I cannot attach the sheet as it has client information.
-- 
Thanks & Regards,
Kiran

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread dguillett1

How about a macro solution. Change “I” to “H”

Sub gettitlesSAS()
Dim r As Long
Dim c As Long
Dim ms As String
For r = 2 To Cells(Rows.Count, 1).End(xlUp).Row
ms = ""
For c = 3 To Cells(1, Columns.Count).End(xlToLeft).Column
  If UCase(Cells(r, c)) = "Y" Then ms = ms & "," & Cells(1, c)
Next c
Cells(r, "I") = Right(ms, Len(ms) - 1)
Next r
End Sub

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

From: Sourabh Salgotra 
Sent: Sunday, February 26, 2012 10:23 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ help needed??

thanks for help sir 
i am already done with if statement. chk attachment.
and provide other solution vlookup/index-match




On Sun, Feb 26, 2012 at 9:33 PM, xlstime  wrote:

  please find the attachment 


  On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra  
wrote:

Dear sir, 
   plz download the attachment and help me...
-- 
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





-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.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$$ Extract last digit number

2012-02-26 Thread Lokesh Loki

Hi Maries,

Thanks for sending the valuable formula. Thanks a lot maries.

Regards
Lokesh.M

On Sat, Feb 25, 2012 at 10:04 PM, Maries  wrote:

> My Try:
>
> =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
>
>
> On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki wrote:
>
>> Hi Sam,
>>
>> Thank you very much for sending the formula.
>>
>> Regards
>> Lokesh.M
>>
>>
>> On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko wrote:
>>
>>> =SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","")
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko
>>>
>>>
>>> On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki wrote:
>>>
 Hi All,

 I need a formula to extract 20 only form the below text and fix the
 same in to next cell.


  Canada_20120223_E002_E001(20)

 regards
 Lokesh.M

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

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

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

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

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

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

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


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

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> 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, goo

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread Sourabh Salgotra

thanks for help sir
i am already done with if statement. chk attachment.
and provide other solution vlookup/index-match



On Sun, Feb 26, 2012 at 9:33 PM, xlstime  wrote:

> please find the attachment
>
> On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:
>
>> Dear sir,
>>plz download the attachment and help me...
>>
>> --
>> 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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.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


Copy of HELP NEEDED ON SUBJECTS.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread Sam Mathai Chacko

Instead of using the CONCATENATE function with multiple if conditions,
better to use a simple helper column with a small formula like this

J2=IF(C2="Y",IF(I2<>"",I2&",","")&C$1,TEXT(I2,""))

And H2=LOOKUP("ZZ",J2:N2)

Regards,

Sam Mathai Chacko

On Sun, Feb 26, 2012 at 9:33 PM, xlstime  wrote:

> please find the attachment
>
> On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:
>
>> Dear sir,
>>plz download the attachment and help me...
>>
>> --
>> 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
>



-- 
Sam Mathai Chacko

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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


HELP NEEDED ON SUBJECTS.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread Maries

My Try,

=IF(AND(C2="Y",COUNTIF(D2:G2,"Y")),$C$1&",",IF((C2)="Y",$C$1,""))&IF(AND(D2="Y",COUNTIF(E2:G2,"Y")),$D$1&",",IF((D2)="Y",$D$1,""))&IF(AND(E2="Y",COUNTIF(F2:G2,"Y")),$E$1&",",IF((E2)="Y",$E$1,""))&IF(AND(F2="Y",COUNTIF(G2:G2,"Y")),$F$1&",",IF((F2)="Y",$F$1,""))&IF(G2="Y",$G$1,"")

On Sun, Feb 26, 2012 at 8:03 PM, xlstime  wrote:

> please find the attachment
>
> On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:
>
>> Dear sir,
>>plz download the attachment and help me...
>>
>> --
>> 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


SOLVED BY MARIES_HELP NEEDED ON SUBJECTS.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help needed??

2012-02-26 Thread xlstime

please find the attachment

On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:

> Dear sir,
>plz download the attachment and help me...
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
.

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

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

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

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

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

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

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

Copy of HELP NEEDED ON SUBJECTS.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping

2012-02-26 Thread Kris

Hi,

Try this macro.


Sub kTest()
'Kris @ ExcelFox.com
Dim i   As Long, j  As Long
Dim n   As Long, m  As Long
Dim r   As Range
Dim wbkAAs Workbook
Dim wbkNAs Workbook
Dim wksNAs Worksheet
Dim CopyRng As Range
Dim MTHs, SUBs

Const MonthCol  As Long = 2 'adjust the Col No
Const SubColAs Long = 3 'adjust the Col No

Const SaveFolderAs String = "E:\Test\"  '<< adjust to suit

With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With

Set wbkA = ThisWorkbook
Set r = Range("a1").CurrentRegion

MTHs = GetUniques(r.Columns(MonthCol).Offset(1))
SUBs = GetUniques(r.Columns(SubCol).Offset(1))

With r
For i = LBound(MTHs) To UBound(MTHs)
For j = LBound(SUBs) To UBound(SUBs)
.AutoFilter MonthCol, "=" & CStr(MTHs(i))
.AutoFilter SubCol, "=" & CStr(SUBs(j))
Set CopyRng = .SpecialCells(12)
If CopyRng.Rows.Count > 1 Or CopyRng.Areas.Count > 1 Then
Set wbkN = Workbooks.Add
m = m + 1
On Error Resume Next
Set wksN = wbkN.Worksheets(m)
If Err.Number <> 0 Then
Set wksN = wbkN.Worksheets.Add
Err.Clear: On Error GoTo 0
End If
CopyRng.Copy wksN.Range("a1")
n = wksN.UsedRange.Rows.Count
wksN.Range("a2") = 1
wksN.Range("a2").AutoFill 
Destination:=wksN.Range("A2:A" & n), Type:=xlFillSeries
wksN.Range("b:c").EntireColumn.Delete
wksN.Name = SUBs(j)
Set wksN = Nothing
n = 0
End If
.AutoFilter
Next
wbkN.SaveAs SaveFolder & MTHs(i) & ".xls", 51
wbkN.Close
Set wbkN = Nothing: m = 0
Next
End With

End Sub
Private Function GetUniques(ByRef r As Range, Optional Crit)

Dim Flg As Boolean
Dim i   As Long
Dim UB1 As Long, v

v = r.Value2
Flg = Not IsMissing(Crit)

UB1 = UBound(v, 1)

With CreateObject("scripting.dictionary")
.comparemode = 1
For i = LBound(v) To UB1
If Len(v(i, 1)) Then
If Flg Then
If v(i, 1) = Crit Then
.Item(v(i, 2)) = Empty
End If
Else
.Item(v(i, 1)) = Empty
End If
End If
Next
GetUniques = .keys
End With

End Function

Kris





On Saturday, 25 February 2012 21:31:46 UTC+5:30, Somnath Khadilkar wrote:
>
> Sir,
>Basically I Have rows of info. in 6/7 colm.
>   depending upon the colm 1  and colm 2 entries i would like to
> make colm1 no of files with colm 2 no of sheets in them. I also need
> to introduce a S No. in each of the sheets. thats it.
>  the data of say 100 rows * 7 Colm in a single XL file/sheet will be
> SLICED into col1 ffiles of colm 2 sheets with the remaining  3 thru 7
> colm only. Well I need the S No 1 thru as many rows as a NEW Col in
> each sheet.
> If still unclear I will share a work file. [ I dont know if its called
> DOUBLE LOOPING ]
>
> On 2/24/12, Somnath Khadilkar  wrote:
> > Sir,
> >
> > The MASTER sheet contains 7 - 8 colm. infomation
> > viz.
> >
> > s nomonthsubnameroll 
> nostdmark
> > 1janmathameya1X10
> >
> > what I need is 'months' of files of 'subject' sheets rest all is to be
> > put as it is.
> > so if there are 12 months  and 3 subjects in MASTER all unique, the macro
> > should produce  12 distict files [ with name as that of month ] each
> > one having 3 sheets each row of these files contain remaining columns
> > of MASTER and an addl S No colm.
> > so the file jan will contain sheets only 'math' and the rows will be
> >
> > nameroll nostdmark
> > ameya1X10
> > smita4VIII40
> > indrani7IV70
> >
> > I need an addl. colm Sr No.
> > so it shus contain
> >
> > s nonameroll nostdmark
> > 1ameya1X10
> > 2smita4VIII40
> > 3indrani7IV70
> >
> > if there are more months the addl sheets should be present.
> >
> > hope i have given one ex which might thro more light.
> >
> > =mangal ho
> >
> > On 2/24/12, dguillett1  wrote:
> >> From what you have provided, I have no idea what you want. You need to
> >> explain with EXAMPLES.
> >>
> >>
> >>
> >> Don Guillett
> >> SalesAid Software
> >> dguille...@gmail.com

Re: $$Excel-Macros$$ Avg. Revisit in number of days

2012-02-26 Thread dguillett1

Perhaps a full explanation and examples would help.

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

From: Amit Desai (MERU) 
Sent: Thursday, February 23, 2012 10:42 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Avg. Revisit in number of days

Dear All,

With the help of our group..I could design the attached revisit sheet. 

1)  “D” Sheet – covers Date of cabs delivered on...

2)  “In” Sheet – covers Date of Cabs Received for repair ..

3)  “Summary” - total cabs visited & revisit count of cabs 0 time, 1 time, 
2 time etc...

4)  If I am working for revisit for Feb’12 (that is In dates for current 
month say Feb’12 & delivered in between Jan ), Revisit is considered say if cab 
was delivered earlier on 5th Jan’12 & if that cab received again say on 1st 
Feb’12 for repair (within 30 days). Here revisit will be considered as one 
revisit in 1 time bracket. But If that cab comes twice in 30 days...revisit is 
considered as one revisit in 2 times bracket.

5)  However I also would like to have avg. number of days of revisit for 
each cab visited & considered as revisit. That is numbers of days in which cab 
revisited is 27days (1st Feb to minus 5th Jan’12).

Request your help. Thanks in advance.

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

RE: $$Excel-Macros$$ Avg. Revisit in number of days

2012-02-26 Thread Amit Desai (MERU)

 Can some one please help?

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Amit Desai (MERU)
Sent: 24 February 2012 10:12
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Avg. Revisit in number of days

Dear All,

With the help of our group..I could design the attached revisit sheet.

1)  "D" Sheet - covers Date of cabs delivered on...

2)  "In" Sheet - covers Date of Cabs Received for repair ..

3)  "Summary" - total cabs visited & revisit count of cabs 0 time, 1 time, 
2 time etc...

4)  If I am working for revisit for Feb'12 (that is In dates for current 
month say Feb'12 & delivered in between Jan ), Revisit is considered say if cab 
was delivered earlier on 5th Jan'12 & if that cab received again say on 1st 
Feb'12 for repair (within 30 days). Here revisit will be considered as one 
revisit in 1 time bracket. But If that cab comes twice in 30 days...revisit is 
considered as one revisit in 2 times bracket.

5)  However I also would like to have avg. number of days of revisit for 
each cab visited & considered as revisit. That is numbers of days in which cab 
revisited is 27days (1st Feb to minus 5th Jan'12).

Request your help. Thanks in advance.

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

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$$ inventory sheet

2012-02-26 Thread Maries

Hi,

I don't know which version your are using. It is working in XL
2003,2007,2010.

It is provide as DEMO version by website. That's why it is fully protected.

I hope this clarify clear.

Regards,

MARIES.



On Sun, Feb 26, 2012 at 11:03 AM, Cab Boose  wrote:

> Hi
>
> I have  opened the file for webandmacros workbook posted here.  The first
> sheet for stock management is blank. No buttons/forms etc. The other sheets
> are ok and show the information.
>
> If I go to VBA to check the code for the VBA Project it asks for a
> password, which I do not know. Shoulod I need to have the password.
>
> Thanks
>
> Charlie
>
>
>
>
>
> On Sun, Feb 26, 2012 at 7:00 PM, raghu gr  wrote:
>
>> sir,
>>
>> Thank you, its good one.
>>
>> with regards
>> raghu
>>
>>
>> On Sun, Feb 26, 2012 at 12:56 AM, Maries  wrote:
>>
>>> Hi,
>>>
>>> Check this link,
>>>
>>> http://www.webandmacros.com/macro_excel_gestion_stocks.htm
>>>
>>> Regards,
>>>
>>> MARIES.
>>> On Sat, Feb 25, 2012 at 7:27 PM, xlstime  wrote:
>>>
 please fine the below link for excel inventory

 http://www.excelmagic.com/inventorymagic.html


 On Sat, Feb 25, 2012 at 7:31 PM, raghu gr wrote:

>
>
> Hi,
>
> How to maintain inventory in excel sheet, is there any excel sheet /
> template / macro.
>
> with regards
> 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
>>>
>>
>>  --
>> 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

Re: $$Excel-Macros$$ Re: date format

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

Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN

Re: $$Excel-Macros$$ date format

Re: $$Excel-Macros$$ ifError not woking with excel 2003 version

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

Re: $$Excel-Macros$$ ifError not woking with excel 2003 version

Re: $$Excel-Macros$$ Pivot table

$$Excel-Macros$$ Excude some sheets in macro

Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN

$$Excel-Macros$$ Re: date format

Re: $$Excel-Macros$$ date format

Re: $$Excel-Macros$$ Pivot uncheck All

Re: $$Excel-Macros$$ Pivot uncheck All

Re: $$Excel-Macros$$ Pivot uncheck All

$$Excel-Macros$$ Pivot uncheck All

Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ Extract last digit number

Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping

Re: $$Excel-Macros$$ Avg. Revisit in number of days

RE: $$Excel-Macros$$ Avg. Revisit in number of days

Re: $$Excel-Macros$$ inventory sheet

26 matches

Site Navigation

Mail list logo

Footer information