Re: $$Excel-Macros$$ All the sheet names in one sheet

[NOORAIN ANSARI]

Dear Santosh,

Best Resource of Excel4 Function is :

*http://www.cpearson.com/excel/Call.htm*

On Tue, Jul 17, 2012 at 12:02 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Noorain,
>
> Thank you for your solution,yes it is working fine.
>
> Recently I have come with these functions like "Get.Cell" and
> "Get.workbook"(the one used by you in the solution).
>
> I am unable to understand how these functions work.These functions are not
> available in HELP screen of excel.
>
> Are there any other functions also available apart from the above two.If
> so then would request you to please help me and the group with that.
>
> It will be of great help for us.
>
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> Date: Mon, 16 Jul 2012 15:21:11 +0530
> Subject: Re: $$Excel-Macros$$ All the sheet names in one sheet
> From: noorain.ans...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Dear Santosh,
>
> Please create a name range with below formula..
>
> *=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")*
>
> and use below formula to extract sheet name in column A.
>
> *
> =IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
> *
> See attached sheet for more information.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1
> automatically via formula of a workbook *without a macro.*
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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) 

Re: $$Excel-Macros$$ Error--Cant Exit Design Mode

[Anil Gawli]

Pl share u r excel sheet  to make us clear...
Regards,
Gawli Anil

On Tue, Jul 17, 2012 at 11:39 AM, NOORAIN ANSARI
wrote:

> Dear Hanumant,
>
> Please share your workbook with group.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> -- Forwarded message --
> From: hanumant shinde 
> Date: Sat, Jul 14, 2012 at 1:36 AM
> Subject: $$Excel-Macros$$ Error--Cant Exit Design Mode
> To: Excel Group 
>
>
>  Hi friends.
>
> there is huge macro file which throws an error as "Cant exit design Mode"
> for few users at few occasions.
> we don't know when and why this error comes but it was told us that this
> error comes when we open Office 2003 file which has ActiveX control buttons
> in office 2007 version.
>
> can you provide your thoughts and feedback.
>
> Workaround:
> if we simply open the error file and save it after giving error the issue
> disappears but reappear after few days. we have no idea why is it happening.
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Fwd: $$Excel-Macros$$ Error--Cant Exit Design Mode

[NOORAIN ANSARI]

Dear Hanumant,

Please share your workbook with group.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- Forwarded message --
From: hanumant shinde 
Date: Sat, Jul 14, 2012 at 1:36 AM
Subject: $$Excel-Macros$$ Error--Cant Exit Design Mode
To: Excel Group 


Hi friends.

there is huge macro file which throws an error as "Cant exit design Mode"
for few users at few occasions.
we don't know when and why this error comes but it was told us that this
error comes when we open Office 2003 file which has ActiveX control buttons
in office 2007 version.

can you provide your thoughts and feedback.

Workaround:
if we simply open the error file and save it after giving error the issue
disappears but reappear after few days. we have no idea why is it happening.


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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to
excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$

[NOORAIN ANSARI]

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

On Tue, Jul 17, 2012 at 11:32 AM, NOORAIN ANSARI
wrote:

>
> On Mon, Jul 16, 2012 at 11:12 PM, sherry ..  wrote:
>
>>
>>
>> *Hi,*
>>
>> *Hope you are doing great today..*
>>
>> *Please find the updated hotlist of my consultants..*
>>
>> *Please send the requirements to she...@nityainc.com or feel free to
>> call me at 801-833-0416*
>>
>> * *
>>
>> *Consultant*
>>
>> *Technology*
>>
>> *Location*
>>
>> *Relocation*
>>
>> *Karthik*
>>
>> *Oracle apps Finance functional consultant*
>>
>> *Moore, OK*
>>
>> *Anywhere*
>>
>> *Konda*
>>
>> *Oracle Apps SCM Consultant*
>>
>> *Chicago,IL
>>*
>>
>> *Chicago, IL*
>>
>> *Arun*
>>
>> *Oracle Apps Techno- functional*
>>
>> *Texas*
>>
>> *CA and UT*
>>
>> *Chanikya*
>>
>> *Oracle Apps technical Consultant*
>>
>> *Indianapolis, IN*
>>
>> *Anywhere *
>>
>> *Padma*
>>
>> *.Net Developer*
>>
>> *Salt Lake City, UT*
>>
>> *Salt Lake City, UT*
>>
>> *Shilpa*
>>
>> *Informatica Developer*
>>
>> *Hopkins, MN*
>>
>> *Salt Lake City, UT*
>>
>> *Sneha*
>>
>> *Java Developer*
>>
>> *Kansas City, MO*
>>
>> *Only TX*
>>
>>
>>
>> *Thanks & Regards**...**?*
>>
>> * *
>>
>> *Sherry*
>>
>> *NITYA** **Software Solutions, Inc***
>>
>> *Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***
>>
>> *Email: **she...@nityainc.com* *; Web: **
>> www.nityainc.com* **
>>
>> *[image: Description: Description: Description:
>> http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
>> Description: Description: http://images.wisestamp.com/gtalk.png]**: **
>> sherry.nityainc***
>>
>> *9690 South 300 West, #319 Salt Lake City, UT 84070***
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$

[NOORAIN ANSARI]

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

On Mon, Jul 16, 2012 at 11:12 PM, sherry ..  wrote:

>
>
> *Hi,*
>
> *Hope you are doing great today..*
>
> *Please find the updated hotlist of my consultants..*
>
> *Please send the requirements to she...@nityainc.com or feel free to call
> me at 801-833-0416*
>
> * *
>
> *Consultant*
>
> *Technology*
>
> *Location*
>
> *Relocation*
>
> *Karthik*
>
> *Oracle apps Finance functional consultant*
>
> *Moore, OK*
>
> *Anywhere*
>
> *Konda*
>
> *Oracle Apps SCM Consultant*
>
> *Chicago,IL
>*
>
> *Chicago, IL*
>
> *Arun*
>
> *Oracle Apps Techno- functional*
>
> *Texas*
>
> *CA and UT*
>
> *Chanikya*
>
> *Oracle Apps technical Consultant*
>
> *Indianapolis, IN*
>
> *Anywhere *
>
> *Padma*
>
> *.Net Developer*
>
> *Salt Lake City, UT*
>
> *Salt Lake City, UT*
>
> *Shilpa*
>
> *Informatica Developer*
>
> *Hopkins, MN*
>
> *Salt Lake City, UT*
>
> *Sneha*
>
> *Java Developer*
>
> *Kansas City, MO*
>
> *Only TX*
>
>
>
> *Thanks & Regards**...**?*
>
> * *
>
> *Sherry*
>
> *NITYA** **Software Solutions, Inc***
>
> *Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***
>
> *Email: **she...@nityainc.com* *; Web: **
> www.nityainc.com* **
>
> *[image: Description: Description: Description:
> http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
> Description: Description: http://images.wisestamp.com/gtalk.png]**: **
> sherry.nityainc***
>
> *9690 South 300 West, #319 Salt Lake City, UT 84070***
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sherry's HotList

[NOORAIN ANSARI]

Hi Sherry,

Please follow forum rule no. 5

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

On Mon, Jul 16, 2012 at 11:12 PM, sherry ..  wrote:

>
>
> *Hi,*
>
> *Hope you are doing great today..*
>
> *Please find the updated hotlist of my consultants..*
>
> *Please send the requirements to she...@nityainc.com or feel free to call
> me at 801-833-0416*
>
> * *
>
> *Consultant*
>
> *Technology*
>
> *Location*
>
> *Relocation*
>
> *Karthik*
>
> *Oracle apps Finance functional consultant*
>
> *Moore, OK*
>
> *Anywhere*
>
> *Konda*
>
> *Oracle Apps SCM Consultant*
>
> *Chicago,IL
>*
>
> *Chicago, IL*
>
> *Arun*
>
> *Oracle Apps Techno- functional*
>
> *Texas*
>
> *CA and UT*
>
> *Chanikya*
>
> *Oracle Apps technical Consultant*
>
> *Indianapolis, IN*
>
> *Anywhere *
>
> *Padma*
>
> *.Net Developer*
>
> *Salt Lake City, UT*
>
> *Salt Lake City, UT*
>
> *Shilpa*
>
> *Informatica Developer*
>
> *Hopkins, MN*
>
> *Salt Lake City, UT*
>
> *Sneha*
>
> *Java Developer*
>
> *Kansas City, MO*
>
> *Only TX*
>
>
>
> *Thanks & Regards**...**?*
>
> * *
>
> *Sherry*
>
> *NITYA** **Software Solutions, Inc***
>
> *Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***
>
> *Email: **she...@nityainc.com* *; Web: **
> www.nityainc.com* **
>
> *[image: Description: Description: Description:
> http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
> Description: Description: http://images.wisestamp.com/gtalk.png]**: **
> sherry.nityainc***
>
> *9690 South 300 West, #319 Salt Lake City, UT 84070***
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date to be formatted in to Customised Format

[Jayaprakash S]

Thanks a Ton Master :-)

Working fine !!

have a gud day!

JP.

On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI
 wrote:
> Dear JP,
>
> Please use below formula for desired output.
>
> =CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))
>
> or
>
> =TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM")
>
> See attached sheet for reference.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, Jul 17, 2012 at 10:32 AM, Jayaprakash S 
> wrote:
>>
>> Dear Experts,
>>
>> Good Morning...
>>
>> Need your Help in formatting the Given Date  in to customised format
>> per attachment...
>>
>> Thanks in Advance!
>>
>> JP.
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>



-- 
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date to be formatted in to Customised Format

[NOORAIN ANSARI]

Dear JP,

Please use below formula for desired output.

*=CONCATENATE(TEXT(A3,"mm.dd.yy")," ",TEXT(B3,"hh:mm:ss AM/PM"))*

or

*=TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM")

*See attached sheet for reference.*
*
-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Tue, Jul 17, 2012 at 10:32 AM, Jayaprakash S
wrote:

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Copy of Date Formated in to Customised Format - Help Reqd(JP).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Date to be formatted in to Customised Format

[Jayaprakash S]

Dear Experts,

Good Morning...

Need your Help in formatting the Given Date  in to customised format
per attachment...

Thanks in Advance!

JP.

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Date Formated in to Customised Format - Help Reqd.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Anil Gawli]

goto calculations field, then click on field items and set then click on
calculation field then click the dropdown button of Name field and click on
delete.


Regards,
Gawli Anil

On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay <> wrote:

> Please help me on below problem.
> Thanks
>
>
> On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay wrote:
>
>> Hi Noorain,
>>
>> If I have to delete some fields as below then How could I do this? Like
>> Salary in Dollar, Field1, Avg Sal in $
>> Please help.
>> [image: Inline image 1]
>>
>>
>> On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay 
>> wrote:
>>
>>> Thanks a ton !!!
>>>
>>>
>>> On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Manesh,

 As desired, Please find step by step screen shot with complete
 explanation as attachment.


 --
 Thanks & regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com

  On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay <
 mangesh.da...@gmail.com> wrote:

> Hi Noorain.
> Thanks but I do not understand how did you calculated the Average
> Salary ($) by using *calculated field*. Please provide me
> documentation so that I could understand. I know it is time consuming job
> for you and really sorry for that. But I dont have alternative. So please
> help me dear. Sorry to trouble u again and again.
>
>
>
>  On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Mangesh,
>>
>> Please find attached sheet..
>>
>> little correction of Anil's Formula in green part
>>
>> =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55
>>
>> Calculated Field solution is also attached here with screen shot.
>>
>>
>>   On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli <
>> gawlianil8...@gmail.com> wrote:
>>
>>> Pls find Attached sheet ...Like this u want?
>>>
>>>
>>> Regards,
>>> Gawli Anil
>>>
>>>  On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay <
>>> mangesh.da...@gmail.com> wrote:
>>>
 Hi Friends,

 I need your help to solve my PT Problem.
 The description is given in sheet itself. Please FA.

 Thanks.

 --
 With regards,

 MaNgEsH

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

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

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

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

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

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

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


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for viol

Re: $$Excel-Macros$$ Please help me.

[Deba Ranjan]

Dear Mangesh,

To create this calendar in the range B2:H9, follow these steps:


1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
Center.

2. Enter a date into the merged range. The day of the month isn’t important.

3. Enter the abbreviated day names in the range B3:H3.

Performing Magic with Array Formulas

4. Select B4:H9 and enter this array formula. Remember: To enter an array
formula, press
Ctrl+Shift+Enter (not just Enter).

{=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
H(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}


5. Format the range B4:H9 to use this custom number format: d. This step
formats the
dates to show only the day. Use the Custom category in the Number tab of
the Format
Cells dialog box to specify this custom number format.

6. Adjust the column widths and format the cells as you like.


7. Change the month and year in cell B2. The calendar updates
automatically.
After creating this calendar, you can copy the range to any other worksheet
or workbook.




Thanks & Regards,
*Deba Ranjan P*





On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:

> Please tell us so that we can edit and learn it. How to make ?
> calender_Simple.xls file
>
>
> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Manoj,
>>
>> Please find attached simple Calender.
>>
>> You can create it simply.
>>
>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > > wrote:
>>
>>> Dear Expert,
>>>
>>>
>>> I want to make Calender on excel
>>>
>>> when i enter year & month in a coll it show me date wise calender...
>>>
>>>
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
-- 
FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Sherry's HotList

[bworth]

STOP!!


 "sherry .."  wrote: 
> *Hi,*
> 
> *Hope you are doing great today..*
> 
> *Please find the updated hotlist of my consultants..*
> 
> *Please send the requirements to she...@nityainc.com or feel free to call
> me at 801-833-0416*
> 
> * *
> 
> *Consultant*
> 
> *Technology*
> 
> *Location*
> 
> *Relocation*
> 
> *Karthik*
> 
> *Oracle apps Finance functional consultant*
> 
> *Moore, OK*
> 
> *Anywhere*
> 
> *Konda*
> 
> *Oracle Apps SCM Consultant*
> 
> *Chicago,IL
>*
> 
> *Chicago, IL*
> 
> *Arun*
> 
> *Oracle Apps Techno- functional*
> 
> *Texas*
> 
> *CA and UT*
> 
> *Chanikya*
> 
> *Oracle Apps technical Consultant*
> 
> *Indianapolis, IN*
> 
> *Anywhere *
> 
> *Padma*
> 
> *.Net Developer*
> 
> *Salt Lake City, UT*
> 
> *Salt Lake City, UT*
> 
> *Shilpa*
> 
> *Informatica Developer*
> 
> *Hopkins, MN*
> 
> *Salt Lake City, UT*
> 
> *Sneha*
> 
> *Java Developer*
> 
> *Kansas City, MO*
> 
> *Only TX*
> 
> 
> 
> *Thanks & Regards**...**?*
> 
> * *
> 
> *Sherry*
> 
> *NITYA** **Software Solutions, Inc***
> 
> *Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***
> 
> *Email: **she...@nityainc.com* *; Web: **
> www.nityainc.com* **
> 
> *[image: Description: Description: Description:
> http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
> Description: Description: http://images.wisestamp.com/gtalk.png]**: **
> sherry.nityainc***
> 
> *9690 South 300 West, #319 Salt Lake City, UT 84070***
> 
> -- 
> FORUM RULES (986+ members already BANNED for violation)
> 
> 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
> get quick attention or may not be answered.
> 
> 2) Don't post a question in the thread of another member.
> 
> 3) Don't post questions regarding breaking or bypassing any security measure.
> 
> 4) Acknowledge the responses you receive, good or bad.
> 
> 5)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
> 
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> 
> --
> To post to this group, send email to excel-macros@googlegroups.com
> 
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[Bé Trần Văn]

Do as you like.



2012/7/17 Venkatesh Narla 

> Hi,
> Please find the attachment and let me know.. any thing els need..
>
>
> Thanks,
> Venkatesh.
>
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
> wrote:
>  > Hi Friends,
> >
> > Please solve my VLookup Query.
> > Description is given in attached file.
> > Thanks.
> >
> > --
> > With regards,
> >
> > MaNgEsH
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Vlookup Problem..xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to Convert words in digits.

[Sam Mathai Chacko]

Your question and title are contradicting.

Do you want to convert words to numbers, or vice versa?

Regards,
Sam Mathai Chacko

On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861  wrote:

> Dear All,
>
> Kindly help me to convert numbers in digits. I'll apply the formula
> "spellnums" but, I think this formula is working only in Office 2003.
> please help me to convert this, & is this possible to convert it with
> formula not with the help of VB codeing.
>
> EXAMPLE:-
>
> Two lacs Two thousand twenty five only. = 220025/-
>
>
> Thanks
> Ashish Kumar
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Sherry's HotList

[sherry ..]

*Hi,*

*Hope you are doing great today..*

*Please find the updated hotlist of my consultants..*

*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*

* *

*Consultant*

*Technology*

*Location*

*Relocation*

*Karthik*

*Oracle apps Finance functional consultant*

*Moore, OK*

*Anywhere*

*Konda*

*Oracle Apps SCM Consultant*

*Chicago,IL
   *

*Chicago, IL*

*Arun*

*Oracle Apps Techno- functional*

*Texas*

*CA and UT*

*Chanikya*

*Oracle Apps technical Consultant*

*Indianapolis, IN*

*Anywhere *

*Padma*

*.Net Developer*

*Salt Lake City, UT*

*Salt Lake City, UT*

*Shilpa*

*Informatica Developer*

*Hopkins, MN*

*Salt Lake City, UT*

*Sneha*

*Java Developer*

*Kansas City, MO*

*Only TX*



*Thanks & Regards**...**?*

* *

*Sherry*

*NITYA** **Software Solutions, Inc***

*Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***

*Email: **she...@nityainc.com* *; Web: **
www.nityainc.com* **

*[image: Description: Description: Description:
http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
Description: Description: http://images.wisestamp.com/gtalk.png]**: **
sherry.nityainc***

*9690 South 300 West, #319 Salt Lake City, UT 84070***

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$

[sherry ..]

*Hi,*

*Hope you are doing great today..*

*Please find the updated hotlist of my consultants..*

*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*

* *

*Consultant*

*Technology*

*Location*

*Relocation*

*Karthik*

*Oracle apps Finance functional consultant*

*Moore, OK*

*Anywhere*

*Konda*

*Oracle Apps SCM Consultant*

*Chicago,IL
   *

*Chicago, IL*

*Arun*

*Oracle Apps Techno- functional*

*Texas*

*CA and UT*

*Chanikya*

*Oracle Apps technical Consultant*

*Indianapolis, IN*

*Anywhere *

*Padma*

*.Net Developer*

*Salt Lake City, UT*

*Salt Lake City, UT*

*Shilpa*

*Informatica Developer*

*Hopkins, MN*

*Salt Lake City, UT*

*Sneha*

*Java Developer*

*Kansas City, MO*

*Only TX*



*Thanks & Regards**...**?*

* *

*Sherry*

*NITYA** **Software Solutions, Inc***

*Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***

*Email: **she...@nityainc.com* *; Web: **
www.nityainc.com* **

*[image: Description: Description: Description:
http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
Description: Description: http://images.wisestamp.com/gtalk.png]**: **
sherry.nityainc***

*9690 South 300 West, #319 Salt Lake City, UT 84070***

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[Venkatesh Narla]

Hi,
Please find the attachment and let me know.. any thing els need..


Thanks,
Venkatesh.


On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay  wrote:
> Hi Friends,
>
> Please solve my VLookup Query.
> Description is given in attached file.
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

[Venkatesh Narla]

Hi All,
This is Venkatesh Narla i am 26 years old and worked as Release
manager in Accenture(Bangalore Location). Currently looking out for
new job. 5+ years in MIS. I am from Andhra Pradesh.


Thanks,
Venkatesh Narla.



On Mon, Jun 11, 2012 at 9:04 AM, Anand Kumar  wrote:
> Hi,
>
> I am Anand Kumar. Aged 31 years and working in fields of data analysis for
> past aprrox 5 years. I have my PGDM in Marketing and hold a ISO 9000 lead
> auditor qualifications.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

[Bé Trần Văn]

Hi Ashish.
My name: Trần Văn Bé, of birth 1957, as state employees.
Form: Việt Nam
I love Excel and a member of the forum, when the new free visit, to exchange
knowledge and help other members on the board, I have participated
less frequently
for free time.

2012/7/16 kumar.ashish861 

> Hi All,
>
> Iam Ashish from Delhi,  I love excel and loves to learn new tweeks and
> tricks. Thish Forum is ROCKS..!
>
>
>
> On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>>
>> Hey all new and current posters,
>>
>> Welcome to excel group,one of the largest online community of excel Fans!
>>
>> I hope you enjoy your time here & find this forum to be a friendly and
>> knowledgeable community. Please feel free to post a small introduction, a
>> friendly hello or tell us a bit about yourself. Why not tell us where are
>> you from, what you do, what your interests are, how old you are, which is
>> your favourite excel site or blog is or anything else that comes to mind!
>>
>> Thanks for your time
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: copy color from cell base on condition formating

[pawel lupinski]

Hi Prince,
 
Unfortunatelly I think as well that the macro is the only one solution for 
this, but is outside of my confort zone.
 
Thanks anyway
 
Pawel
 


 From: Prince Dubey 
To: excel-macros@googlegroups.com 
Cc: pawel lupinski  
Sent: Monday, July 16, 2012 5:21 PM
Subject: $$Excel-Macros$$ Re: copy color from cell base on condition formating
  

Hi Pawel,

In case of conditional formatting we can not refer other sheet. So for this 
problem you can use macro.

regards
prince dubey.

On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip  wrote:
Hi All,
>I'd like to ask you for favour. I have an issue with copy of the colour from 
>condition formating to new place. 
>What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way 
>that I will have the value and the same colour.But the issue is colour can not 
>be base on condition formating? Does anyone know how to do it?
>Regards
>Pawel
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: All the sheet names in one sheet

[Prince Dubey]

Hi Santosh,

Please refer attach sheet it may help you.

Regards
Prince dubey

On Monday, 16 July 2012 14:52:01 UTC+5:30, santosh wrote:
>
> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1 
> automatically via formula of a workbook *without a macro.*
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ copy color from cell base on condition formating

[pawel lupinski]

Joseph,
 
paste special is not workig as its refering to different sheet
 
Regards,
 
Pawel
 


 From: "joseph.cam...@gmail.com" 
To: excel-macros@googlegroups.com 
Sent: Monday, July 16, 2012 3:41 PM
Subject: Re: $$Excel-Macros$$ copy color from cell base on condition formating
  

Please try paste special format

Sent on my BlackBerry® from Vodafone



From:  pawel lupinski  
Sender:  excel-macros@googlegroups.com 
Date: Mon, 16 Jul 2012 07:38:57 -0700 (PDT)
To: excel-macros@googlegroups.com
ReplyTo:  excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ copy color from cell base on condition formating

Hi All,
I'd like to ask you for favour. I have an issue with copy of the colour from 
condition formating to new place. 
What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way 
that I will have the value and the same colour.But the issue is colour can not 
be base on condition formating? Does anyone know how to do it?
Regards
Pawel
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@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
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Please help me on below problem.
Thanks

On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay wrote:

> Hi Noorain,
>
> If I have to delete some fields as below then How could I do this? Like
> Salary in Dollar, Field1, Avg Sal in $
> Please help.
> [image: Inline image 1]
>
>
> On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay wrote:
>
>> Thanks a ton !!!
>>
>>
>> On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Manesh,
>>>
>>> As desired, Please find step by step screen shot with complete
>>> explanation as attachment.
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>> On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay 
>>> wrote:
>>>
 Hi Noorain.
 Thanks but I do not understand how did you calculated the Average
 Salary ($) by using *calculated field*. Please provide me
 documentation so that I could understand. I know it is time consuming job
 for you and really sorry for that. But I dont have alternative. So please
 help me dear. Sorry to trouble u again and again.



 On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Mangesh,
>
> Please find attached sheet..
>
> little correction of Anil's Formula in green part
>
> =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55
>
> Calculated Field solution is also attached here with screen shot.
>
>
> On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli 
> wrote:
>
>> Pls find Attached sheet ...Like this u want?
>>
>>
>> Regards,
>> Gawli Anil
>>
>> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay <
>> mangesh.da...@gmail.com> wrote:
>>
>>> Hi Friends,
>>>
>>> I need your help to solve my PT Problem.
>>> The description is given in sheet itself. Please FA.
>>>
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>> in signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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-p

$$Excel-Macros$$ Re: copy color from cell base on condition formating

[Prince Dubey]

Hi Pawel,

In case of conditional formatting we can not refer other sheet. So for this 
problem you can use macro.

regards
prince dubey.

On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote:
>
> Hi All,
> I'd like to ask you for favour. I have an issue with copy of the colour 
> from condition formating to new place. 
> What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the 
> way that I will have the value and the same colour.But the issue is colour 
> can not be base on condition formating? Does anyone know how to do it?
> Regards
> Pawel
>

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sherry's HotList

[joseph . camill]

Hi moderators,

Per rule please ban this user.

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

-Original Message-
From: "sherry .." 
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 21:24:44 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sherry's HotList

*Hi,*

*Hope you are doing great today..*

*Please find the updated hotlist of my consultants..*

*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*

* *

*Consultant*

*Technology*

*Location*

*Relocation*

*Karthik*

*Oracle apps Finance functional consultant*

*Moore, OK*

*Anywhere*

*Konda*

*Oracle Apps SCM Consultant*

*Chicago,IL
   *

*Chicago, IL*

*Arun*

*Oracle Apps Techno- functional*

*Texas*

*CA and UT*

*Chanikya*

*Oracle Apps technical Consultant*

*Indianapolis, IN*

*Anywhere *

*Padma*

*.Net Developer*

*Salt Lake City, UT*

*Salt Lake City, UT*

*Shilpa*

*Informatica Developer*

*Hopkins, MN*

*Salt Lake City, UT*

*Sneha*

*Java Developer*

*Kansas City, MO*

*Only TX*



*Thanks & Regards**...**?*

* *

*Sherry*

*NITYA** **Software Solutions, Inc***

*Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***

*Email: **she...@nityainc.com* *; Web: **
www.nityainc.com* **

*[image: Description: Description: Description:
http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
Description: Description: http://images.wisestamp.com/gtalk.png]**: **
sherry.nityainc***

*9690 South 300 West, #319 Salt Lake City, UT 84070***

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Sherry's HotList

[sherry ..]

*Hi,*

*Hope you are doing great today..*

*Please find the updated hotlist of my consultants..*

*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*

* *

*Consultant*

*Technology*

*Location*

*Relocation*

*Karthik*

*Oracle apps Finance functional consultant*

*Moore, OK*

*Anywhere*

*Konda*

*Oracle Apps SCM Consultant*

*Chicago,IL
   *

*Chicago, IL*

*Arun*

*Oracle Apps Techno- functional*

*Texas*

*CA and UT*

*Chanikya*

*Oracle Apps technical Consultant*

*Indianapolis, IN*

*Anywhere *

*Padma*

*.Net Developer*

*Salt Lake City, UT*

*Salt Lake City, UT*

*Shilpa*

*Informatica Developer*

*Hopkins, MN*

*Salt Lake City, UT*

*Sneha*

*Java Developer*

*Kansas City, MO*

*Only TX*



*Thanks & Regards**...**?*

* *

*Sherry*

*NITYA** **Software Solutions, Inc***

*Direct:801-833-0416;  Office : 801-983-2771;  Fax:801-606-7919***

*Email: **she...@nityainc.com* *; Web: **
www.nityainc.com* **

*[image: Description: Description: Description:
http://images.wisestamp.com/yahoo.png]**&** **[image: Description:
Description: Description: http://images.wisestamp.com/gtalk.png]**: **
sherry.nityainc***

*9690 South 300 West, #319 Salt Lake City, UT 84070***

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Error Cleaning

[dguillett1]

You might try expanding column C to find out that that is NOT 
true

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 10:26 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

Yes, if you see..from row 12 to row 40, the data is blank..can it be possible 
after running the macro...it would consolidated without such blanks in the 
data??
On Monday, July 16, 2012 8:31:55 PM UTC+5:30, Don Guillett wrote: 


  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: SG 
  Sent: Monday, July 16, 2012 9:30 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

  Hi Don,

  It's working perfectly.but one more problem is this i have shown only 3 
columns in my sample file but in real ...i have atleast 23 columns & last 
column is the Error column on which this macro will work...now this macro is 
consolidating the data at the end.Please have a look.For instance, i have 
increased the column no to 5.

  On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote:
I wrote it to continue what you had already done. The TTC could be 
incorporated. 
Option explicit forces use of dim
Look in vba help index for resize

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 8:49 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

Hi Don,

Thanks for the help. I haven't run the macro.I'm a begineer to the 
macro.Can you please explain the "option Explicit" & use of "resize" & would i 
run this macro after text to column splitting?

uillett wrote:
  Should do it

  Option Explicit
  Sub getlists()
  Dim lr As Long
  Dim i As Long
  Dim dr As Long
  Dim btc As Range
  lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
  Set btc = Cells(2, 1).Resize(lr, 2)
  For i = 2 To lr + 1
  dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
  btc.Copy Cells(dr, 1)
  Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
  'MsgBox i
  Next i
  Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  End Sub
  ‘’
  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: SG 
  Sent: Monday, July 16, 2012 3:42 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Re: Error Cleaning

  Sorry for Replying late.Yes, i choose delimit & choose comma for 
it.Problem is this that the data is in thousandsr rows & manually it takes so 
much time.i have attached a file & i hope it clears the doubts brfore cleaning 
the data & after cleaning the data.

  On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
Hi Experts,

I need your help again.We extract the data from database & each user 
got some errors on different projects.I need to clean the error data to get the 
count of errors.For this,i do text to column on error column.Then, in each 
column after error column, i take the value one by one & copy paste the data 
below the original data.It's too time consuming as data may expand up to many 
columns & each column has irregular no. of errors description.I have tried to 
explain best & need a macro to make unique row of erros of all users.I have 
attached the excel file & a document in which i have tried to explain.Looking 
forward for your help.

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

Re: $$Excel-Macros$$ Re: Error Cleaning

[SG]

Yes, if you see..from row 12 to row 40, the data is blank..can it be 
possible after running the macro...it would consolidated without such 
blanks in the data??
On Monday, July 16, 2012 8:31:55 PM UTC+5:30, Don Guillett wrote: 
>
>
>  
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* SG  
> *Sent:* Monday, July 16, 2012 9:30 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
>  
>  Hi Don,
>  
> It's working perfectly.but one more problem is this i have shown only 3 
> columns in my sample file but in real ...i have atleast 23 columns & last 
> column is the Error column on which this macro will work...now this macro 
> is consolidating the data at the end.Please have a look.For instance, i 
> have increased the column no to 5.
>
> On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote:
>
>>   I wrote it to continue what you had already done. The TTC could be 
>> incorporated. 
>> Option explicit forces use of dim
>> Look in vba help index for resize
>>  
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>   
>>  *From:* SG  
>> *Sent:* Monday, July 16, 2012 8:49 AM
>> *To:* excel-macros@googlegroups.com 
>> *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
>>  
>>  Hi Don,
>>  
>> Thanks for the help. I haven't run the macro.I'm a begineer to the 
>> macro.Can you please explain the "option Explicit" & use of "resize" & 
>> would i run this macro after text to column splitting?
>>
>> uillett wrote:
>>
>>>   Should do it
>>>  
>>> Option Explicit
>>> Sub getlists()
>>> Dim lr As Long
>>> Dim i As Long
>>> Dim dr As Long
>>> Dim btc As Range
>>> lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
>>> Set btc = Cells(2, 1).Resize(lr, 2)
>>> For i = 2 To lr + 1
>>> dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
>>> btc.Copy Cells(dr, 1)
>>> Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
>>> 'MsgBox i
>>> Next i
>>> Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
>>> End Sub
>>> ‘’
>>> Don Guillett
>>> Microsoft Excel Developer
>>> SalesAid Software
>>> dguille...@gmail.com
>>>   
>>>  *From:* SG  
>>> *Sent:* Monday, July 16, 2012 3:42 AM
>>> *To:* excel-macros@googlegroups.com 
>>> *Subject:* $$Excel-Macros$$ Re: Error Cleaning
>>>  
>>>  Sorry for Replying late.Yes, i choose delimit & choose comma for 
>>> it.Problem is this that the data is in thousandsr rows & manually it takes 
>>> so much time.i have attached a file & i hope it clears the doubts brfore 
>>> cleaning the data & after cleaning the data.
>>>
>>> On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
>>>
 Hi Experts,
  
 I need your help again.We extract the data from database & each user 
 got some errors on different projects.I need to clean the error data to 
 get 
 the count of errors.For this,i do text to column on error column.Then, in 
 each column after error column, i take the value one by one & copy paste 
 the data below the original data.It's too time consuming as data may 
 expand 
 up to many columns & each column has irregular no. of errors description.I 
 have tried to explain best & need a macro to make unique row of erros of 
 all users.I have attached the excel file & a document in which i have 
 tried 
 to explain.Looking forward for your help.
  
 Thanks in advance.

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

Re: $$Excel-Macros$$ Re: Error Cleaning

[dguillett1]

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 9:30 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

Hi Don,

It's working perfectly.but one more problem is this i have shown only 3 columns 
in my sample file but in real ...i have atleast 23 columns & last column is the 
Error column on which this macro will work...now this macro is consolidating 
the data at the end.Please have a look.For instance, i have increased the 
column no to 5.

On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote:
  I wrote it to continue what you had already done. The TTC could be 
incorporated. 
  Option explicit forces use of dim
  Look in vba help index for resize

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: SG 
  Sent: Monday, July 16, 2012 8:49 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

  Hi Don,

  Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can 
you please explain the "option Explicit" & use of "resize" & would i run this 
macro after text to column splitting?

  uillett wrote:
Should do it

Option Explicit
Sub getlists()
Dim lr As Long
Dim i As Long
Dim dr As Long
Dim btc As Range
lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
Set btc = Cells(2, 1).Resize(lr, 2)
For i = 2 To lr + 1
dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
btc.Copy Cells(dr, 1)
Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
'MsgBox i
Next i
Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
‘’
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 3:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Error Cleaning

Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem 
is this that the data is in thousandsr rows & manually it takes so much time.i 
have attached a file & i hope it clears the doubts brfore cleaning the data & 
after cleaning the data.

On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
  Hi Experts,

  I need your help again.We extract the data from database & each user got 
some errors on different projects.I need to clean the error data to get the 
count of errors.For this,i do text to column on error column.Then, in each 
column after error column, i take the value one by one & copy paste the data 
below the original data.It's too time consuming as data may expand up to many 
columns & each column has irregular no. of errors description.I have tried to 
explain best & need a macro to make unique row of erros of all users.I have 
attached the excel file & a document in which i have tried to explain.Looking 
forward for your help.

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to 
excel-macros+unsubscr...@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
   
  To unsubscribe, send a blank email to 
excel-macros+unsubscr...@googlegroups.com
-- 
FORUM RULE

Re: $$Excel-Macros$$ Re: Error Cleaning

[dguillett1]

I don’t understand. Look at before/after sheets to see what macro is doing.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 9:30 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

Hi Don,

It's working perfectly.but one more problem is this i have shown only 3 columns 
in my sample file but in real ...i have atleast 23 columns & last column is the 
Error column on which this macro will work...now this macro is consolidating 
the data at the end.Please have a look.For instance, i have increased the 
column no to 5.

On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote:
  I wrote it to continue what you had already done. The TTC could be 
incorporated. 
  Option explicit forces use of dim
  Look in vba help index for resize

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: SG 
  Sent: Monday, July 16, 2012 8:49 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

  Hi Don,

  Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can 
you please explain the "option Explicit" & use of "resize" & would i run this 
macro after text to column splitting?

  uillett wrote:
Should do it

Option Explicit
Sub getlists()
Dim lr As Long
Dim i As Long
Dim dr As Long
Dim btc As Range
lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
Set btc = Cells(2, 1).Resize(lr, 2)
For i = 2 To lr + 1
dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
btc.Copy Cells(dr, 1)
Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
'MsgBox i
Next i
Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
‘’
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 3:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Error Cleaning

Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem 
is this that the data is in thousandsr rows & manually it takes so much time.i 
have attached a file & i hope it clears the doubts brfore cleaning the data & 
after cleaning the data.

On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
  Hi Experts,

  I need your help again.We extract the data from database & each user got 
some errors on different projects.I need to clean the error data to get the 
count of errors.For this,i do text to column on error column.Then, in each 
column after error column, i take the value one by one & copy paste the data 
below the original data.It's too time consuming as data may expand up to many 
columns & each column has irregular no. of errors description.I have tried to 
explain best & need a macro to make unique row of erros of all users.I have 
attached the excel file & a document in which i have tried to explain.Looking 
forward for your help.

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to 
excel-macros+unsubscr...@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
   
  To unsubscribe, send

Re: $$Excel-Macros$$ copy color from cell base on condition formating

[joseph . camill]

Please try paste special format

Sent on my BlackBerry® from Vodafone

-Original Message-
From: pawel lupinski 
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 07:38:57 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ copy color from cell base on condition formating

Hi All,
I'd like to ask you for favour. I have an issue with copy of the colour from 
condition formating to new place. 
What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way 
that I will have the value and the same colour.But the issue is colour can not 
be base on condition formating? Does anyone know how to do it?
Regards
Pawel

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ copy color from cell base on condition formating

[pawel lupinski]

Hi All,
I'd like to ask you for favour. I have an issue with copy of the colour from 
condition formating to new place. 
What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way 
that I will have the value and the same colour.But the issue is colour can not 
be base on condition formating? Does anyone know how to do it?
Regards
Pawel

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

colour_for_condition_formating.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Error Cleaning

[SG]

Hi Don,
 
It's working perfectly.but one more problem is this i have shown only 3 
columns in my sample file but in real ...i have atleast 23 columns & last 
column is the Error column on which this macro will work...now this macro 
is consolidating the data at the end.Please have a look.For instance, i 
have increased the column no to 5.

On Monday, July 16, 2012 7:32:46 PM UTC+5:30, Don Guillett wrote:

>   I wrote it to continue what you had already done. The TTC could be 
> incorporated. 
> Option explicit forces use of dim
> Look in vba help index for resize
>  
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* SG  
> *Sent:* Monday, July 16, 2012 8:49 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
>  
>  Hi Don,
>  
> Thanks for the help. I haven't run the macro.I'm a begineer to the 
> macro.Can you please explain the "option Explicit" & use of "resize" & 
> would i run this macro after text to column splitting?
>
> uillett wrote:
>
>>   Should do it
>>  
>> Option Explicit
>> Sub getlists()
>> Dim lr As Long
>> Dim i As Long
>> Dim dr As Long
>> Dim btc As Range
>> lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
>> Set btc = Cells(2, 1).Resize(lr, 2)
>> For i = 2 To lr + 1
>> dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
>> btc.Copy Cells(dr, 1)
>> Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
>> 'MsgBox i
>> Next i
>> Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
>> End Sub
>> ‘’
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>   
>>  *From:* SG  
>> *Sent:* Monday, July 16, 2012 3:42 AM
>> *To:* excel-macros@googlegroups.com 
>> *Subject:* $$Excel-Macros$$ Re: Error Cleaning
>>  
>>  Sorry for Replying late.Yes, i choose delimit & choose comma for 
>> it.Problem is this that the data is in thousandsr rows & manually it takes 
>> so much time.i have attached a file & i hope it clears the doubts brfore 
>> cleaning the data & after cleaning the data.
>>
>> On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
>>
>>> Hi Experts,
>>>  
>>> I need your help again.We extract the data from database & each user got 
>>> some errors on different projects.I need to clean the error data to get the 
>>> count of errors.For this,i do text to column on error column.Then, in each 
>>> column after error column, i take the value one by one & copy paste the 
>>> data below the original data.It's too time consuming as data may expand up 
>>> to many columns & each column has irregular no. of errors description.I 
>>> have tried to explain best & need a macro to make unique row of erros of 
>>> all users.I have attached the excel file & a document in which i have tried 
>>> to explain.Looking forward for your help.
>>>  
>>> Thanks in advance.
>>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@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
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>

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

1) Use concise, accurate thread titles. Poor thread tit

Re: $$Excel-Macros$$ Re: Error Cleaning

[dguillett1]

I wrote it to continue what you had already done. The TTC could be 
incorporated. 
Option explicit forces use of dim
Look in vba help index for resize

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 8:49 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning

Hi Don,

Thanks for the help. I haven't run the macro.I'm a begineer to the macro.Can 
you please explain the "option Explicit" & use of "resize" & would i run this 
macro after text to column splitting?

uillett wrote:
  Should do it

  Option Explicit
  Sub getlists()
  Dim lr As Long
  Dim i As Long
  Dim dr As Long
  Dim btc As Range
  lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
  Set btc = Cells(2, 1).Resize(lr, 2)
  For i = 2 To lr + 1
  dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
  btc.Copy Cells(dr, 1)
  Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
  'MsgBox i
  Next i
  Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  End Sub
  ‘’
  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: SG 
  Sent: Monday, July 16, 2012 3:42 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Re: Error Cleaning

  Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem 
is this that the data is in thousandsr rows & manually it takes so much time.i 
have attached a file & i hope it clears the doubts brfore cleaning the data & 
after cleaning the data.

  On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
Hi Experts,

I need your help again.We extract the data from database & each user got 
some errors on different projects.I need to clean the error data to get the 
count of errors.For this,i do text to column on error column.Then, in each 
column after error column, i take the value one by one & copy paste the data 
below the original data.It's too time consuming as data may expand up to many 
columns & each column has irregular no. of errors description.I have tried to 
explain best & need a macro to make unique row of erros of all users.I have 
attached the excel file & a document in which i have tried to explain.Looking 
forward for your help.

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

Re: $$Excel-Macros$$ All the sheet names in one sheet

[╰» ℓαℓιт мσαнη]

Dear Santosh,

I think it is not possible to get all the sheets name by using only formula.

Regards,
Lalit Mohan


On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI
 wrote:
> Dear Santosh,
>
> Please create a name range with below formula..
>
> =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
>
> and use below formula to extract sheet name in column A.
>
> =IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
>
> See attached sheet for more information.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi
>  wrote:
>>
>> Hi Group,
>>
>> I want the list of all the sheet names available or to created in sheet1
>> automatically via formula of a workbook without a macro.
>>
>> Thanks & Regards
>> Santosh
>> santoshkumar.subu...@gmail.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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[╰» ℓαℓιт мσαнη]

Hi Mangesh,

If you want to learn how vlookup works may be below links helps you..

http://www.free-training-tutorial.com/function-vlookup.html
http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm


Regards,
Lalit Mohan


On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay  wrote:
> Its really helpful.
> U have done full R & D here.
> Thanks lot.
>
>
> On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI 
> wrote:
>>
>> Dear Mangesh,
>>
>> You can also use..
>>
>> =LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)
>>
>> or
>>
>> =INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))
>>
>> or
>>
>> =OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)
>>
>> with ctrl+shift+Enter
>>
>> See attached sheet.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>>
>>> Hi Friends,
>>>
>>> Please solve my VLookup Query.
>>> Description is given in attached file.
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>>> not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

Re: $$Excel-Macros$$ Re: Error Cleaning

[SG]

Hi Don,
 
Thanks for the help. I haven't run the macro.I'm a begineer to the 
macro.Can you please explain the "option Explicit" & use of "resize" & 
would i run this macro after text to column splitting?

uillett wrote:

>   Should do it
>  
> Option Explicit
> Sub getlists()
> Dim lr As Long
> Dim i As Long
> Dim dr As Long
> Dim btc As Range
> lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
> Set btc = Cells(2, 1).Resize(lr, 2)
> For i = 2 To lr + 1
> dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
> btc.Copy Cells(dr, 1)
> Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
> 'MsgBox i
> Next i
> Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
> End Sub
> ‘’
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* SG  
> *Sent:* Monday, July 16, 2012 3:42 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Re: Error Cleaning
>  
>  Sorry for Replying late.Yes, i choose delimit & choose comma for 
> it.Problem is this that the data is in thousandsr rows & manually it takes 
> so much time.i have attached a file & i hope it clears the doubts brfore 
> cleaning the data & after cleaning the data.
>
> On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
>
>> Hi Experts,
>>  
>> I need your help again.We extract the data from database & each user got 
>> some errors on different projects.I need to clean the error data to get the 
>> count of errors.For this,i do text to column on error column.Then, in each 
>> column after error column, i take the value one by one & copy paste the 
>> data below the original data.It's too time consuming as data may expand up 
>> to many columns & each column has irregular no. of errors description.I 
>> have tried to explain best & need a macro to make unique row of erros of 
>> all users.I have attached the excel file & a document in which i have tried 
>> to explain.Looking forward for your help.
>>  
>> Thanks in advance.
>>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Error Cleaning

[dguillett1]

Should do it

Option Explicit
Sub getlists()
Dim lr As Long
Dim i As Long
Dim dr As Long
Dim btc As Range
lr = Cells(Rows.Count, 1).End(xlUp).Row - 1
Set btc = Cells(2, 1).Resize(lr, 2)
For i = 2 To lr + 1
dr = Cells(Rows.Count, 1).End(xlUp).Row + 1
btc.Copy Cells(dr, 1)
Cells(2, i + 1).Resize(lr).Copy Cells(dr, "c")
'MsgBox i
Next i
Columns(3).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
‘’
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: SG 
Sent: Monday, July 16, 2012 3:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Error Cleaning

Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem is 
this that the data is in thousandsr rows & manually it takes so much time.i 
have attached a file & i hope it clears the doubts brfore cleaning the data & 
after cleaning the data.

On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:
  Hi Experts,

  I need your help again.We extract the data from database & each user got some 
errors on different projects.I need to clean the error data to get the count of 
errors.For this,i do text to column on error column.Then, in each column after 
error column, i take the value one by one & copy paste the data below the 
original data.It's too time consuming as data may expand up to many columns & 
each column has irregular no. of errors description.I have tried to explain 
best & need a macro to make unique row of erros of all users.I have attached 
the excel file & a document in which i have tried to explain.Looking forward 
for your help.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Hi Noorain,

If I have to delete some fields as below then How could I do this? Like
Salary in Dollar, Field1, Avg Sal in $
Please help.
[image: Inline image 1]

On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay wrote:

> Thanks a ton !!!
>
>
> On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Manesh,
>>
>> As desired, Please find step by step screen shot with complete
>> explanation as attachment.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay 
>> wrote:
>>
>>> Hi Noorain.
>>> Thanks but I do not understand how did you calculated the Average Salary
>>> ($) by using *calculated field*. Please provide me documentation so
>>> that I could understand. I know it is time consuming job for you and really
>>> sorry for that. But I dont have alternative. So please help me dear. Sorry
>>> to trouble u again and again.
>>>
>>>
>>>
>>> On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Mangesh,

 Please find attached sheet..

 little correction of Anil's Formula in green part

 =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55

 Calculated Field solution is also attached here with screen shot.


 On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli wrote:

> Pls find Attached sheet ...Like this u want?
>
>
> Regards,
> Gawli Anil
>
> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay <
> mangesh.da...@gmail.com> wrote:
>
>> Hi Friends,
>>
>> I need your help to solve my PT Problem.
>> The description is given in sheet itself. Please FA.
>>
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Thanks a ton !!!

On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI wrote:

> Dear Manesh,
>
> As desired, Please find step by step screen shot with complete explanation
> as attachment.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay wrote:
>
>> Hi Noorain.
>> Thanks but I do not understand how did you calculated the Average Salary
>> ($) by using *calculated field*. Please provide me documentation so that
>> I could understand. I know it is time consuming job for you and really
>> sorry for that. But I dont have alternative. So please help me dear. Sorry
>> to trouble u again and again.
>>
>>
>>
>> On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Mangesh,
>>>
>>> Please find attached sheet..
>>>
>>> little correction of Anil's Formula in green part
>>>
>>> =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55
>>>
>>> Calculated Field solution is also attached here with screen shot.
>>>
>>>
>>> On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli wrote:
>>>
 Pls find Attached sheet ...Like this u want?


 Regards,
 Gawli Anil

 On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay >>> > wrote:

> Hi Friends,
>
> I need your help to solve my PT Problem.
> The description is given in sheet itself. Please FA.
>
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like 

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Hi Noorain.
Thanks but I do not understand how did you calculated the Average Salary
($) by using *calculated field*. Please provide me documentation so that I
could understand. I know it is time consuming job for you and really sorry
for that. But I dont have alternative. So please help me dear. Sorry to
trouble u again and again.



On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI wrote:

> Dear Mangesh,
>
> Please find attached sheet..
>
> little correction of Anil's Formula in green part
>
> =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55
>
> Calculated Field solution is also attached here with screen shot.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli wrote:
>
>> Pls find Attached sheet ...Like this u want?
>>
>>
>> Regards,
>> Gawli Anil
>>
>> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> I need your help to solve my PT Problem.
>>> The description is given in sheet itself. Please FA.
>>>
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures 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$$ Vlookup Problem

[Mangesh Vimay]

Its really helpful.
U have done full R & D here.
Thanks lot.

On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI wrote:

> Dear Mangesh,
>
> You can also use..
>
> *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*
>
> or
>
> *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*
>
> or
>
> *=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*
>
> with ctrl+shift+Enter
>
> See attached sheet.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please solve my VLookup Query.
>> Description is given in attached file.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Hi Anil,

Thanks lot.
But I need to calculate the average($) by using Calculated Field option
given in Options ---> Formulas ---> calculated field.
Is it possible by using above method. Please let me know.
Thanks again.

On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli  wrote:

> Pls find Attached sheet ...Like this u want?
>
>
> Regards,
> Gawli Anil
>
> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> I need your help to solve my PT Problem.
>> The description is given in sheet itself. Please FA.
>>
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

[Anil Gawli]

Pls find Attached sheet ...Like this u want?


Regards,
Gawli Anil

On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote:

> Hi Friends,
>
> I need your help to solve my PT Problem.
> The description is given in sheet itself. Please FA.
>
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Vlookup Problem

[NOORAIN ANSARI]

Dear Mangesh,

You can also use..

*=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*

or

*=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*

or

*=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*

with ctrl+shift+Enter

See attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of VLookUp Problem Solved(Mangesh)-16Jul12.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me.

[Mangesh Vimay]

Please tell us so that we can edit and learn it. How to make ?
calender_Simple.xls file

On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI
wrote:

> Dear Manoj,
>
> Please find attached simple Calender.
>
> You can create it simply.
>
> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar 
> wrote:
>
>> Dear Expert,
>>
>>
>> I want to make Calender on excel
>>
>> when i enter year & month in a coll it show me date wise calender...
>>
>>
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

so much

On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay wrote:

> Thank you much Suman
>
>
> On Mon, Jul 16, 2012 at 4:48 PM, Suman  wrote:
>
>> Dear Mangesh,
>> Please find the attached file as I have learnt this one form Noorain sir
>> in this group.
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> Please solve my VLookup Query.
>>> Description is given in attached file.
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *Suman Kumar*
>>
>> *Mob: +91-9810333884*
>>
>> *RIM-+91-9555629292*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>


-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Thank you much Suman

On Mon, Jul 16, 2012 at 4:48 PM, Suman  wrote:

> Dear Mangesh,
> Please find the attached file as I have learnt this one form Noorain sir
> in this group.
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please solve my VLookup Query.
>> Description is given in attached file.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> *Suman Kumar*
>
> *Mob: +91-9810333884*
>
> *RIM-+91-9555629292*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

$$Excel-Macros$$ Please solve my Pivot Table Problem

[Mangesh Vimay]

Hi Friends,

I need your help to solve my PT Problem.
The description is given in sheet itself. Please FA.

Thanks.

-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

[Dhartikumar Sahu]

Thanks Noorain it's working fine, thank for your valuable support.



On Mon, Jul 16, 2012 at 4:15 PM, Anil Gawli  wrote:

> dear noorian
> Thanks Bro...
>
>
> Regards,
> Gawli Anil
>
> On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Anil Bro,
>>
>> Please right click on Toolbox goto Additional Control and select
>> Microsoft Date and Time Picker.
>>
>> see attached screenshot
>>
>> or
>>
>> if your system doesn't support Date Time picker then install it through
>> below link
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>  http://danielcurran.com/instructions/how-to-install-microsoft-date-time-
>> picker-control-60-sp4/
>>
>>
>> On Mon, Jul 16, 2012 at 3:16 PM, Anil Gawli wrote:
>>
>>> dear noorian
>>>
>>> How u add the Dt picker in user form... pls let me know..
>>>
>>> Regards
>>> Gawli Anil
>>>
>>>  On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear DS,

 Please try it..

 *Private Sub CommandButton1_Click()
 Dim i As Integer
 Dim dt As Date
 i = Cells(Rows.Count, "A").End(xlUp).Row + 1
 dt = Me.DTPicker1
 With Application.WorksheetFunction
 If .WeekNum(dt) > (.WeekNum(Date) - 1) Then
 Cells(i, 1) = Me.DTPicker1.Value
 Else
 MsgBox "Restricted Last week Entery", vbCritical
 End If
 End With
 End Sub

 *see attached sheet, hope it will help to you.



 On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu <
 dhartiku...@gmail.com> wrote:

> Hi Experts
>
> Required VBA Code  for restrict Previous Week Data Entry to Users.
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383
> 63450
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




 --
 Thanks & regards,
 Noorain Ansari
 www.noorainansari.com
 www.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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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.
>>>
>>>

$$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Hi Friends,

Please solve my VLookup Query.
Description is given in attached file.
Thanks.

-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Help Me

[Kuldeep Singh]

[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █]

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar wrote:

> Dear Kuldeep,
>
> thanks..
>
>
> I need function witch I already provide by Noorain...
>
>
>
> On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh wrote:
>
>>
>> Hi,
>>
>> Use this
>>
>> Regards,
>> Kuldeep Singh
>> Info Edge India Limited (naukri.com)
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>>
>> On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar 
>> wrote:
>>
>>> Thanks Noorain Ji...
>>>
>>>
>>> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Manoj,

 Please try it.


 =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))


 --
 Thanks & regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com



 On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar <
 kumarmanoj.11...@gmail.com> wrote:

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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 questi

Re: $$Excel-Macros$$ Help Me

[Manoj Kumar]

Dear Kuldeep,

thanks..


I need function witch I already provide by Noorain...



On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh wrote:

>
> Hi,
>
> Use this
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar 
> wrote:
>
>> Thanks Noorain Ji...
>>
>>
>> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Manoj,
>>>
>>> Please try it.
>>>
>>>
>>> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>>
>>> On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar >> > wrote:
>>>
 Dear Expert,

 Please help me to make report
 I have data in 1 sheet I want make report in sheet 2.

 Regard
 Manoj

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

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

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

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

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

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

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


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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 exce

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

[Anil Gawli]

dear noorian
Thanks Bro...


Regards,
Gawli Anil

On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI wrote:

> Dear Anil Bro,
>
> Please right click on Toolbox goto Additional Control and select Microsoft
> Date and Time Picker.
>
> see attached screenshot
>
> or
>
> if your system doesn't support Date Time picker then install it through
> below link
>
>
>
>
>
>
>
>
>
>
>  http://danielcurran.com/instructions/how-to-install-microsoft-date-time-
> picker-control-60-sp4/
>
>
> On Mon, Jul 16, 2012 at 3:16 PM, Anil Gawli wrote:
>
>> dear noorian
>>
>> How u add the Dt picker in user form... pls let me know..
>>
>> Regards
>> Gawli Anil
>>
>>  On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear DS,
>>>
>>> Please try it..
>>>
>>> *Private Sub CommandButton1_Click()
>>> Dim i As Integer
>>> Dim dt As Date
>>> i = Cells(Rows.Count, "A").End(xlUp).Row + 1
>>> dt = Me.DTPicker1
>>> With Application.WorksheetFunction
>>> If .WeekNum(dt) > (.WeekNum(Date) - 1) Then
>>> Cells(i, 1) = Me.DTPicker1.Value
>>> Else
>>> MsgBox "Restricted Last week Entery", vbCritical
>>> End If
>>> End With
>>> End Sub
>>>
>>> *see attached sheet, hope it will help to you.
>>>
>>>
>>>
>>> On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu <
>>> dhartiku...@gmail.com> wrote:
>>>
 Hi Experts

 Required VBA Code  for restrict Previous Week Data Entry to Users.

 --

 *Regards,*

 *Dhartikumar Sahu*

 Sr.Database Manager - Institutional Equities

 * **IDBI Capital Markets Services Ltd*

 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

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

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

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

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

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

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

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


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubs

Re: $$Excel-Macros$$ Help Me

[NOORAIN ANSARI]

Happy to Help

On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar wrote:

> Thanks Noorain Ji...
>
>
> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Manoj,
>>
>> Please try it.
>>
>>
>> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>> On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear Expert,
>>>
>>> Please help me to make report
>>> I have data in 1 sheet I want make report in sheet 2.
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help Me

[Manoj Kumar]

Thanks Noorain Ji...

On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI wrote:

> Dear Manoj,
>
> Please try it.
>
>
> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
> On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert,
>>
>> Please help me to make report
>> I have data in 1 sheet I want make report in sheet 2.
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help Me

[NOORAIN ANSARI]

Dear Manoj,

Please try it.

=INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com



On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar wrote:

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of Book7(Manoj-Solve).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ My Self - Introduction

[Ganesh S]

Hi All,

My Name is Ganesh from India - Chennai, I am working with Inscribe - BPO 
for last 7 years as a Project Leader. In our office most the works 
processed by ms excel, so it is most important to our daily work. Mr Ashish 
referred to join this forum and it was more useful and reduced our routing 
works too Thanks a lot for everyone in this forum :)


Thanks & Regards,
Ganesh

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ All the sheet names in one sheet

[NOORAIN ANSARI]

Dear Santosh,

Please create a name range with below formula..

*=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")*

and use below formula to extract sheet name in column A.

*
=IF(ROWS($A$2:A2<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"")
*
See attached sheet for more information.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1
> automatically via formula of a workbook *without a macro.*
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

List SheetName With Formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ All the sheet names in one sheet

[Excel Vba]

hi santosh,

PFA below vbacode to findout the sheetsname.



Sub sheets_nm()

Dim sh As Worksheet

Dim i As Integer, k As Integer

Set sh = ThisWorkbook.Sheets("sheet1")

For i = 1 To Sheets.Count

k = Range("a5").End(xlUp).Row + 1
sh.Cells(k, 1) = Sheets(i).Name

Next
End Sub

Regards,
excelvba.lear...@gmail.com


On Mon, Jul 16, 2012 at 2:52 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1
> automatically via formula of a workbook *without a macro.*
>
> Thanks & Regards
> Santosh
> santoshkumar.subu...@gmail.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

[Anil Gawli]

dear noorian

How u add the Dt picker in user form... pls let me know..

Regards
Gawli Anil

On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI wrote:

> Dear DS,
>
> Please try it..
>
> *Private Sub CommandButton1_Click()
> Dim i As Integer
> Dim dt As Date
> i = Cells(Rows.Count, "A").End(xlUp).Row + 1
> dt = Me.DTPicker1
> With Application.WorksheetFunction
> If .WeekNum(dt) > (.WeekNum(Date) - 1) Then
> Cells(i, 1) = Me.DTPicker1.Value
> Else
> MsgBox "Restricted Last week Entery", vbCritical
> End If
> End With
> End Sub
>
> *see attached sheet, hope it will help to you.
>
>
>
> On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu 
> wrote:
>
>> Hi Experts
>>
>> Required VBA Code  for restrict Previous Week Data Entry to Users.
>>
>> --
>>
>> *Regards,*
>>
>> *Dhartikumar Sahu*
>>
>> Sr.Database Manager - Institutional Equities
>>
>> * **IDBI Capital Markets Services Ltd*
>>
>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>>
>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

[NOORAIN ANSARI]

Dear DS,

Please try it..

*Private Sub CommandButton1_Click()
Dim i As Integer
Dim dt As Date
i = Cells(Rows.Count, "A").End(xlUp).Row + 1
dt = Me.DTPicker1
With Application.WorksheetFunction
If .WeekNum(dt) > (.WeekNum(Date) - 1) Then
Cells(i, 1) = Me.DTPicker1.Value
Else
MsgBox "Restricted Last week Entery", vbCritical
End If
End With
End Sub

*see attached sheet, hope it will help to you.


On Mon, Jul 16, 2012 at 10:18 AM, Dhartikumar Sahu wrote:

> Hi Experts
>
> Required VBA Code  for restrict Previous Week Data Entry to Users.
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Dharti_Query.xlsm
Description: Binary data

$$Excel-Macros$$ All the sheet names in one sheet

[santosh subudhi]

Hi Group,

I want the list of all the sheet names available or to created in sheet1
automatically via formula of a workbook *without a macro.*

Thanks & Regards
Santosh
santoshkumar.subu...@gmail.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Error Cleaning

[SG]

Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem 
is this that the data is in thousandsr rows & manually it takes so much 
time.i have attached a file & i hope it clears the doubts brfore cleaning 
the data & after cleaning the data.

On Friday, July 13, 2012 5:33:35 PM UTC+5:30, SG wrote:

> Hi Experts,
>  
> I need your help again.We extract the data from database & each user got 
> some errors on different projects.I need to clean the error data to get the 
> count of errors.For this,i do text to column on error column.Then, in each 
> column after error column, i take the value one by one & copy paste the 
> data below the original data.It's too time consuming as data may expand up 
> to many columns & each column has irregular no. of errors description.I 
> have tried to explain best & need a macro to make unique row of erros of 
> all users.I have attached the excel file & a document in which i have tried 
> to explain.Looking forward for your help.
>  
> Thanks in advance.
>

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

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

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

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

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

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

[Anil Gawli]

Dear Dhartikumar

Pls share us with some data.


Regards,
Gawli Anil

On Mon, Jul 16, 2012 at 12:46 PM, Dhartikumar Sahu <> wrote:

> awaiting for reply..
>
>
> -- Forwarded message --
> From: Dhartikumar Sahu 
> Date: Mon, Jul 16, 2012 at 10:18 AM
> Subject: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous
> Week Data Entry..
> To: excel-macros@googlegroups.com
>
>
> Hi Experts
>
> Required VBA Code  for restrict Previous Week Data Entry to Users.
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Query- Global Variable

[NOORAIN ANSARI]

Dear Hemant,

Lalit solution is nice
You can also check..

http://www.ozgrid.com/forum/showthread.php?t=58969

On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba wrote:

> Hi Group,
>
>
> How can i declare a global variable for below mentioned.
>
>
>
> Private sub abc()
> dim sh as worksheet
> dim rng as range
>
> set sh = Thisworkbook.Sheets("Sheet1")
> set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
>
> End sub
>
>
> In my module i have 20 procedure and in future comes many more.
> So, my query how to declare a global variable and how to call in my
> procedure.
>
> Regards,
> excelvba.lear...@gmail.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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com