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

2012-07-16 Thread 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 excelvba.lear...@gmail.comwrote:

 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:csh.range(crows.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

$$Excel-Macros$$ Re: Error Cleaning

2012-07-16 Thread 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


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

2012-07-16 Thread 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

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

2012-07-16 Thread 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 dhartiku...@gmail.comwrote:

 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


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

2012-07-16 Thread 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 noorain.ans...@gmail.comwrote:

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

 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 Me

2012-07-16 Thread Manoj Kumar
Thanks Noorain Ji...

On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

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

 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

2012-07-16 Thread NOORAIN ANSARI
Happy to Help

On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:

 Thanks Noorain Ji...


 On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

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

 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:- Required VBA Code for Restrict Previous Week Data Entry......

2012-07-16 Thread Anil Gawli
dear noorian
Thanks Bro...


Regards,
Gawli Anil

On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 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 gawlianil8...@gmail.comwrote:

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

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread 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 naukrikuld...@gmail.comwrote:


 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 
 kumarmanoj.11...@gmail.comwrote:

 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 questions regarding breaking or bypassing any security
 measure.

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

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

 NOTE : Don't ever post personal or confidential data in 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, 

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread 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 kumarmanoj.11...@gmail.comwrote:

 Dear Kuldeep,

 thanks..


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



 On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 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 
 kumarmanoj.11...@gmail.comwrote:

 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 questions regarding breaking or bypassing any security
 measure.

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

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

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


 --
 To post to this 

$$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread 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:- Required VBA Code for Restrict Previous Week Data Entry......

2012-07-16 Thread Dhartikumar Sahu
Thanks Noorain it's working fine, thank for your valuable support.



On Mon, Jul 16, 2012 at 4:15 PM, Anil Gawli gawlianil8...@gmail.com wrote:

 dear noorian
 Thanks Bro...


 Regards,
 Gawli Anil

 On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 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 gawlianil8...@gmail.comwrote:

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

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

2012-07-16 Thread 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$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
Thank you much Suman

On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com 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 mangesh.da...@gmail.comwrote:

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

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
so much

On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Thank you much Suman


 On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com 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 
 mangesh.da...@gmail.comwrote:

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

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

2012-07-16 Thread 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
noorain.ans...@gmail.comwrote:

 Dear Manoj,

 Please find attached simple Calender.

 You can create it simply.

 On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar 
 kumarmanoj.11...@gmail.comwrote:

 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

2012-07-16 Thread 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 mangesh.da...@gmail.comwrote:

 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 solve my Pivot Table Problem

2012-07-16 Thread Anil Gawli
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.comwrote:

 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$$ Please solve my Pivot Table Problem

2012-07-16 Thread 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 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.comwrote:

 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$$ Vlookup Problem

2012-07-16 Thread ╰» ℓαℓιт мσαнη
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 mangesh.da...@gmail.com wrote:
 Its really helpful.
 U have done full R  D here.
 Thanks lot.


 On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI noorain.ans...@gmail.com
 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 mangesh.da...@gmail.com
 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.com

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


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

2012-07-16 Thread ╰» ℓαℓιт мσαнη
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
noorain.ans...@gmail.com 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
 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


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

2012-07-16 Thread 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 this group, 

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

2012-07-16 Thread 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 sonal...@gmail.com 
 *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 sonal...@gmail.com 
 *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 

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

2012-07-16 Thread 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$$ copy color from cell base on condition formating

2012-07-16 Thread joseph . camill
Please try paste special format

Sent on my BlackBerry® from Vodafone

-Original Message-
From: pawel lupinski lupins...@yahoo.com
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 07:38:57 
To: excel-macros@googlegroups.comexcel-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

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

2012-07-16 Thread 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 a blank email to 

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

2012-07-16 Thread 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 RULES (986+ members 

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

2012-07-16 Thread 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 sonal...@gmail.com 
 *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 sonal...@gmail.com 
 *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 sonal...@gmail.com 
 *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.
  

 

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

2012-07-16 Thread 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) Don't post a 

$$Excel-Macros$$ Sherry's HotList

2012-07-16 Thread 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* she...@nityainc.com*; Web: **
www.nityainc.com* http://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$$ Sherry's HotList

2012-07-16 Thread joseph . camill
Hi moderators,

Per rule please ban this user.

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

-Original Message-
From: sherry .. sherry.w...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 21:24:44 
To: us-recruitment-and-market...@googlegroups.com
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* she...@nityainc.com*; Web: **
www.nityainc.com* http://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$$ Re: copy color from cell base on condition formating

2012-07-16 Thread 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$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Please help me on below problem.
Thanks

On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 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 mangesh.da...@gmail.comwrote:

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

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

 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.


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

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

2012-07-16 Thread pawel lupinski
Joseph,
 
paste special is not workig as its refering to different sheet
 
Regards,
 
Pawel
 


 From: joseph.cam...@gmail.com 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 lupins...@yahoo.com 
Sender:  excel-macros@googlegroups.com 
Date: Mon, 16 Jul 2012 07:38:57 -0700 (PDT)
To: excel-macros@googlegroups.comexcel-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

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

2012-07-16 Thread 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$$ Re: copy color from cell base on condition formating

2012-07-16 Thread 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 prince141...@gmail.com
To: excel-macros@googlegroups.com 
Cc: pawel lupinski lupins...@yahoo.com 
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

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

2012-07-16 Thread 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 kumar.ashish...@gmail.com

 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: Introduce Yourself !!

2012-07-16 Thread 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 anand...@gmail.com 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$$ Vlookup Problem

2012-07-16 Thread 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 mangesh.da...@gmail.com 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


$$Excel-Macros$$

2012-07-16 Thread 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* she...@nityainc.com*; Web: **
www.nityainc.com* http://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's HotList

2012-07-16 Thread 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* she...@nityainc.com*; Web: **
www.nityainc.com* http://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$$ How to Convert words in digits.

2012-07-16 Thread 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 kumar.ashish...@gmail.com
 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

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Bé Trần Văn
Do as you like.



2012/7/17 Venkatesh Narla nvenki...@gmail.com

 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 mangesh.da...@gmail.com
 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$$ Sherry's HotList

2012-07-16 Thread bworth
STOP!!


 sherry .. sherry.w...@gmail.com 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* she...@nityainc.com*; Web: **
 www.nityainc.com* http://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$$ Please help me.

2012-07-16 Thread 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 mangesh.da...@gmail.comwrote:

 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 noorain.ans...@gmail.com
  wrote:

 Dear Manoj,

 Please find attached simple Calender.

 You can create it simply.

 On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar kumarmanoj.11...@gmail.com
  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 BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 

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

2012-07-16 Thread 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 mangesh.da...@gmail.comwrote:

 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 
 mangesh.da...@gmail.comwrote:

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

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

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

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

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

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

 NOTE : Don't ever post personal or confidential data in 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$$ Date to be formatted in to Customised Format

2012-07-16 Thread 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$$ Date to be formatted in to Customised Format

2012-07-16 Thread 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
bhat.jayaprak...@gmail.comwrote:

 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


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

2012-07-16 Thread Jayaprakash S
Thanks a Ton Master :-)

Working fine !!

have a gud day!

JP.

On Tue, Jul 17, 2012 at 11:03 AM, NOORAIN ANSARI
noorain.ans...@gmail.com 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 bhat.jayaprak...@gmail.com
 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