date:20121217

Hi rendils,

Please apply this: 

*
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) =  Thousand 
Place(3) =  Million 
Place(4) =  Billion 
Place(5) =  Trillion 
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, .)
' Convert cents and set MyNumber to dollar amount.
If DecimalPlace  0 Then
Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1)  _
  00, 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber  
Temp = GetHundreds(Right(MyNumber, 3))
If Temp   Then Dollars = Temp  Place(Count)  Dollars
If Len(MyNumber)  3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = 
End If
Count = Count + 1
Loop
SpellNumber = Dollars
End Function
  
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right(000  MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1)  0 Then
Result = GetDigit(Mid(MyNumber, 1, 1))   Hundred 
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1)  0 Then
Result = Result  GetTens(Mid(MyNumber, 2))
Else
Result = Result  GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
  
' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result =' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then   ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = Ten
Case 11: Result = Eleven
Case 12: Result = Twelve
Case 13: Result = Thirteen
Case 14: Result = Fourteen
Case 15: Result = Fifteen
Case 16: Result = Sixteen
Case 17: Result = Seventeen
Case 18: Result = Eighteen
Case 19: Result = Nineteen
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = Twenty 
Case 3: Result = Thirty 
Case 4: Result = Forty 
Case 5: Result = Fifty 
Case 6: Result = Sixty 
Case 7: Result = Seventy 
Case 8: Result = Eighty 
Case 9: Result = Ninety 
Case Else
End Select
Result = Result  GetDigit _
(Right(TensText, 1))  ' Retrieve ones place.
End If
GetTens = Result
End Function
 
' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = One
Case 2: GetDigit = Two
Case 3: GetDigit = Three
Case 4: GetDigit = Four
Case 5: GetDigit = Five
Case 6: GetDigit = Six
Case 7: GetDigit = Seven
Case 8: GetDigit = Eight
Case 9: GetDigit = Nine
Case Else: GetDigit = 
End Select
End Function


Regards
Prince
*
On Monday, December 17, 2012 12:55:18 PM UTC+5:30, Rendils wrote:


   HI friends...

 A small query in excel is there any way to convert numbers in to words
 eg :- 
 1202  = One Thousand two hundred and Two 

 for more details find the attached file

 thanking you all in advance

 regards

  
 *Delin.F* 



-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$

2012-12-17 Thread NOORAIN ANSARI

Dear Karan,

Please try

=INDEX($B$2:$B$6,SMALL(IF($B$2:$B$60,ROW($B$2:$B$6),),ROW(A3))-1)

with ctrl+shift+Enter

see attached sheet for more clarity.


-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Mon, Dec 17, 2012 at 1:58 PM, Karan Singh karan1...@gmail.com wrote:

 Dear All,

 I need your assistant to get value from the list excluding 0. I'v
 attached a sample file.



 Karan Singh


  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Exclude 0(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Reposition the cursor in an Excel macro

2012-12-17 Thread ollyolly

I am looking to write a macro in excel.
I wish to position the cursor on worksheet 2 to automatically enter some 
data.  The row number of the new position is dependant on the value of a 
cell in worksheet 1.
Can anyone tell me how to do this?
Thank you.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Extract value excluding 0

Hi Karan,

Please paste this in C2 and Drag it down.

=LARGE($B$2:$B$12,COUNTIF($B$2:$B$12,0)+1-ROW(A1))

Regards
Prince

On Monday, December 17, 2012 2:00:22 PM UTC+5:30, Karan Singh wrote:

 Dear All,

 I need your assistant to get value from the list excluding 0. I'v 
 attached a sample file. 

 Thanks
 Karan Singh


  

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Reposition the cursor in an Excel macro

2012-12-17 Thread Swapnil Palande

Hi,

If you are inserting data automatically then no need to set cursor on sheet
2. Just define range object and assign value to it.

If you provide sample data, it is easier to give solution.

Regards
Swapnil
On Dec 17, 2012 2:32 PM, ollyolly andrew.cla...@tiscali.co.uk wrote:

 I am looking to write a macro in excel.
 I wish to position the cursor on worksheet 2 to automatically enter some
 data.  The row number of the new position is dependant on the value of a
 cell in worksheet 1.
 Can anyone tell me how to do this?
 Thank you.

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi Ollyolly,

can you please tell us when this function will be performed. On opening of 
the workbook or on any other event. And one more  thing  where i will get 
the cell adress of the sheet 2 to put the cursor into Sheet2.

Regards
Prince

On Monday, December 17, 2012 2:32:21 PM UTC+5:30, ollyolly wrote:

 I am looking to write a macro in excel.
 I wish to position the cursor on worksheet 2 to automatically enter some 
 data.  The row number of the new position is dependant on the value of a 
 cell in worksheet 1.
 Can anyone tell me how to do this?
 Thank you.


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Fwd: $$Excel-Macros$$

2012-12-17 Thread Pravin Gunjal

Here it's working. Thanks.

-- Forwarded message --
From: NOORAIN ANSARI noorain.ans...@gmail.com
Date: Mon, Dec 17, 2012 at 2:04 PM
Subject: Re: $$Excel-Macros$$
To: excel-macros@googlegroups.com

Dear Karan,

Please try

=INDEX($B$2:$B$6,SMALL(IF($B$2:$B$60,ROW($B$2:$B$6),),ROW(A3))-1)

with ctrl+shift+Enter

see attached sheet for more clarity.

-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
 On Mon, Dec 17, 2012 at 1:58 PM, Karan Singh karan1...@gmail.com wrote:

 Dear All,

 I need your assistant to get value from the list excluding 0. I'v
 attached a sample file.

 Karan Singh

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.

 --
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Exclude 0(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Extract value excluding 0

2012-12-17 Thread NOORAIN ANSARI

Dear Pravin,

Where are you facing problem with my formula.
pls explain...


On Mon, Dec 17, 2012 at 2:57 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Hi,
 Ms-Excel has given the correct answer whereas Noorain's formula is not
 working properly.

 Regards
 Pravin Gunjal.

 -- Forwarded message --
 From: Ms-Exl-Learner . ms.exl.lear...@gmail.com
 Date: Mon, Dec 17, 2012 at 2:05 PM
 Subject: Re: $$Excel-Macros$$ Extract value excluding 0
 To: excel-macros@googlegroups.com


 In C2 cell
 =IFERROR(SMALL($B$2:$B$6,COUNTIF($B$2:$B$6,0)+ROW(A1)),)


 On Mon, Dec 17, 2012 at 2:00 PM, Karan Singh karan1...@gmail.com wrote:

 Dear All,

 I need your assistant to get value from the list excluding 0. I'v
 attached a sample file.

 Thanks
 Karan Singh


  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
With Regards,
Noorain Ansari
http:// 
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http:// 
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS

$$Excel-Macros$$ Re: Plz help urgent

Hi Anil,

Please Paste this formula into C2 and drag upto C18

=REPLACE(A2,1,LEN(B2)+1,)

Regards
Prince

On Monday, December 17, 2012 11:58:24 AM UTC+5:30, Anil Saxena wrote:

 Hi All,
 plz help, I want correct email id and remove the bounce email from email 
 id column.

 -- 

 *Anil Saxena*

 MIS Executive - Response

 *Wizcraft International Entertainment Pvt. Ltd.*

 Plot No 8, Sector 32 | Urban Estate | Gurgaon - 122001

 Tel: + (91) (0124) 480 12 12

 Fax: + (91) (0124) 480 12 00

 Mobile: + (91) 9971870460**

 Email: anilsaxe...@gmail.com javascript:**

 Website: www.wizcraftworld.com






  

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Anoop K Sharma

Matt, Please share your workbook.

Regards,
Anoop
Sr. Developer


On Sat, Dec 15, 2012 at 9:58 PM, Matt moni...@gmail.com wrote:

 Hi, search the forum but couldn't find an example that fit. I'm trying to
 do a search off column A on the Lookup tab, and search for it in the
 yellow  column in the 2010Chase tab using the Instr function and return
 a value but can't seem to get the code to work unless the words are
 identical. Is there anyway I can get this code to work?

 The sheet is here:
 https://www.box.com/s/33z5kuabqbjn2b971ae6

 Tx in advance

 Matt

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Regards,
Anoop
Sr. Developer

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

2012-12-17 Thread ollyolly



 Swapnil  Prince,

Thanks for your swift replies, I'll try and respond to you both in one post.
The spreadsheet I am trying to write is to record the arrival time of event 
entrants at certain locations.
Sheet 1 cell A1 contains the time function =now().
Sheet 1 cell A2 is where the entrants number is typed in and recorded by 
hitting the enter key.
Sheet 2 cells A1 to A500 lists the numbers 1 to 500.
Sheet 2 cells B1 to B500 lists the entrants name.
Sheet 2 cells C1 to C500 is where I'm looking to locate the cursor to 
insert the arrival time.
 
For example:
Entrant 5 arrives at 11:50.  5 is entered into sheet 1 cell A2 and enter is 
hit.
I then invoke the macro most probably by a keystroke CTRL+something.
The macro would contain the following - 
The time in cell A1 is copied to the clipboard.
Sheet 2 becomes displayed, the cursor moves to cell C5.
11:50 is pasted into C5 using the paste special value command.
 
If entrant 350 arrived then the macro would go to sheet 2 cell C350 etc.
 
I hope this helps.
 
 
 

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi ollyolly,

That means the value in Cell A1 on Sheet1 is the arrival time, This time 
should be inserted into cell C1 on Sheet2  as you hit the enter Key on 
Sheet1 after typing entrants number in Cell A2 on Sheet1. Right ?

Regards
Prince



On Monday, December 17, 2012 3:04:33 PM UTC+5:30, ollyolly wrote:

 Swapnil  Prince,

 Thanks for your swift replies, I'll try and respond to you both in one 
 post.
 The spreadsheet I am trying to write is to record the arrival time of 
 event entrants at certain locations.
 Sheet 1 cell A1 contains the time function =now().
 Sheet 1 cell A2 is where the entrants number is typed in and recorded by 
 hitting the enter key.
 Sheet 2 cells A1 to A500 lists the numbers 1 to 500.
 Sheet 2 cells B1 to B500 lists the entrants name.
 Sheet 2 cells C1 to C500 is where I'm looking to locate the cursor to 
 insert the arrival time.
  
 For example:
 Entrant 5 arrives at 11:50.  5 is entered into sheet 1 cell A2 and enter 
 is hit.
 I then invoke the macro most probably by a keystroke CTRL+something.
 The macro would contain the following - 
 The time in cell A1 is copied to the clipboard.
 Sheet 2 becomes displayed, the cursor moves to cell C5.
 11:50 is pasted into C5 using the paste special value command.
  
 If entrant 350 arrived then the macro would go to sheet 2 cell C350 etc.
  
 I hope this helps.
  
  
  


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Extract value excluding 0

Hi karan Please Find one more way to do the same: 

=SMALL(($B$2:$B$6)*($B$2:$B$60),COUNTIF($B$2:$B$6,=0)+ROW(A1))  with 
Ctrl+shift+Enter

Regards
Prince

On Monday, 17 December 2012 14:00:22 UTC+5:30, Karan Singh wrote:

 Dear All,

 I need your assistant to get value from the list excluding 0. I'v 
 attached a sample file. 

 Thanks
 Karan Singh


  

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Plz help urgent

2012-12-17 Thread Lalit Mohan Pandey

Try this also,


=TRIM(REPLACE(A2, FIND(B2,A2),LEN(B2)+1,))

Regards,
Lalit Mohan

On Monday, 17 December 2012 11:58:24 UTC+5:30, Anil Saxena wrote:

 Hi All,
 plz help, I want correct email id and remove the bounce email from email 
 id column.

 -- 

 *Anil Saxena*

 MIS Executive - Response

 *Wizcraft International Entertainment Pvt. Ltd.*

 Plot No 8, Sector 32 | Urban Estate | Gurgaon - 122001

 Tel: + (91) (0124) 480 12 12

 Fax: + (91) (0124) 480 12 00

 Mobile: + (91) 9971870460**

 Email: anilsaxe...@gmail.com javascript:**

 Website: www.wizcraftworld.com






  

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

2012-12-17 Thread Swapnil Palande

Hi,

Please find attached file for solution.

In attached excel, macro is updating arrival time without copying it. And
there is no key assigned to macro. When you enter value in A2 cell in
Sheet1 and hit enter macro will update arrival time in Sheet2

Regards,

Swapnil.

On Mon, Dec 17, 2012 at 2:50 PM, Prince prince141...@gmail.com wrote:

 Hi Ollyolly,

 can you please tell us when this function will be performed. On opening of
 the workbook or on any other event. And one more  thing  where i will get
 the cell adress of the sheet 2 to put the cursor into Sheet2.

 Regards
 Prince

 On Monday, December 17, 2012 2:32:21 PM UTC+5:30, ollyolly wrote:

 I am looking to write a macro in excel.
 I wish to position the cursor on worksheet 2 to automatically enter some
 data.  The row number of the new position is dependant on the value of a
 cell in worksheet 1.
 Can anyone tell me how to do this?
 Thank you.

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Reposition the cursor in an Excel macro_Solution.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

2012-12-17 Thread Lalit Mohan Pandey

Dear Pravin,

Could you please explain it more when you want to protect or unprotect the 
sheet. so that we can provide you best solution.

Regards,
Lalit Mohan

On Monday, 17 December 2012 15:51:04 UTC+5:30, Pravin Gunjal wrote:

 Dear Prince

 Request for your co-operation on this issue.

 Regards
 Pravin Gunjal.

 -- Forwarded message --
 From: Pravin Gunjal isk...@gmail.com javascript:
 Date: Fri, Dec 14, 2012 at 3:55 PM
 Subject: Fwd: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with 
 manual protect / unprotect
 To: excel-...@googlegroups.com javascript:, Prince Kumar - Excel 
 prince...@gmail.com javascript:


 *Dear Prince*
 *
 *
  *Pl find attached file for the same.*
 *
 *
 *Regards*
  *Pravin Gunjal.*

 -- Forwarded message --
 From: Prince prince...@gmail.com javascript:
 Date: Thu, Dec 13, 2012 at 3:18 PM
 Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with 
 manual protect / unprotect
 To: excel-...@googlegroups.com javascript:


 Hi Pravin,

 Share your workbook.

 Regards
 Prince


 On Thursday, December 13, 2012 3:13:50 PM UTC+5:30, Pravin Gunjal wrote:

 Dear Prince,

 By doing the changes suggested by you, the macro is not working properly.
 Pl confirm.

 Regards
 Pravin.

 -- Forwarded message --
 From: Prince prince...@gmail.com
  Date: Thu, Dec 13, 2012 at 2:44 PM
 Subject: Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with 
 manual protect / unprotect
 To: excel-...@googlegroups.com


 Hi Pravin,

 You should palce this code on   Worksheet_Activate()  event and befor 
 udating the sheet protact it.For updating the sheet unprotact it from menu 
 bar.

 regards
 Prince 


 On Thursday, December 13, 2012 2:29:57 PM UTC+5:30, Pravin Gunjal wrote:

 Hi Prince
 Then please let me know , how can I do the changes.

 Regards
 Pravin.

 -- Forwarded message --
 From: Prince prince...@gmail.com
 Date: Thu, Dec 13, 2012 at 2:09 PM
 Subject: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with 
 manual protect / unprotect
 To: excel-...@googlegroups.com


 Hi Pravin,

 Whenever you move from one cell to other  Worksheet_SelectionChange event 
 is called thats why it is not allowing you to update the sheet.

 Regards
 Prince 


 On Thursday, December 13, 2012 1:24:00 PM UTC+5:30, Pravin Gunjal wrote:

 *Dear Friends,*

 * *

 *I am using the following macro in one of my excel files.  *

 * *

 *Private Sub Worksheet_SelectionChange(ByVal Target As Range)*

 *   *

 *With ThisWorkbook.Worksheets(Field Emails)*

 *.Unprotect*

 *[selRow] = Target.Row*

 *[selCol] = Target.Column*

 *.Protect*

 *End With*

 *End Sub*

 * *

 *I used to work in this file with protect sheet and sometimes I would 
 like to work with unprotect sheet to update the data.  *

 *But the below code is not allowing me to keep file unprotect as it’s 
 automatically protecting the sheet once I move to the another cell.*

 * *

 *Therefore, I request you to please inform me some 
 corrections/addition in to this code to enable me to work with or without 
 protection.  Protect / unprotect should be happened manually and not 
 automatically.*

 * *

 *Thank you,*

 * *

 *With regards,**
 **Pravin Gunjal*

  -- 
 Join official Facebook page of this forum @ https://www.facebook.com/**
 discu**ssexcel https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@**
 googlegroups.**com.

 Visit this group at http://groups.google.com/**group**
 /excel-macros?hl=en http://groups.google.com/group/excel-macros?hl=en.
  
  

  -- 
 Join official Facebook page of this forum @ https://www.facebook.com/**
 discussexcel https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive,

$$Excel-Macros$$ Re: Merge entry cell

2012-12-17 Thread Rajan_Verma

In K7

=INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0))

With CSE 

On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it is 
 duplicate then over right on it

 Regards
 Amar 



-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Help Please

2012-12-17 Thread Lalit Mohan Pandey

No Possible with the same name

On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote:

 Dear All,

 I'm inserting new sheet in a workbook but all sheet have a different name 
 like sheet1, sheet2.

 but i want,

 if I'm inserting new sheet then every time they have same name!

 how it is possible plz reply it urgent.


 -- 
 ***Thanks
 Sanjay Kumar Maurya*



-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Merge entry cell

Good one Rajan

Regards
Prince

On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote:

 In K7

 =INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0))

 With CSE 

 On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it is 
 duplicate then over right on it

 Regards
 Amar 



-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread Ms-Exl-Learner


*In K7*

=LOOKUP(10^10,E7:H7,E7:H7)

*Non *Array Solution.



On 14-12-2012 5:50 PM, amar takale wrote:

Dear Experts

Pls can anybody help me on this matter.

As always, Thank you very much for all the help


Regards
Amar



On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.com 
mailto:amartak...@gmail.com wrote:


Dear all
Can Anybody tell me formula to merge cell entry in one column if
it is duplicate then over right on it

Regards
Amar

-- 
Join official Facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros%2bunsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.



--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups MS EXCEL AND VBA MACROS group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros?hl=en.




--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: Help Please

2012-12-17 Thread Rajan_Verma

Why you want to have same name?

On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote:

 Dear All,

 I'm inserting new sheet in a workbook but all sheet have a different name 
 like sheet1, sheet2.

 but i want,

 if I'm inserting new sheet then every time they have same name!

 how it is possible plz reply it urgent.


 -- 
 ***Thanks
 Sanjay Kumar Maurya*



-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Matt

Hi, i put the link at the bottom of my question.
tx
matt

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ how to create formula in vba through cell references

2012-12-17 Thread Amit Gandhi

Hi Experts

I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
sheet backup and get the desired results.

activesheet.range(c2)= =LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN*
_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)

i need macro to get above red highlighted values from cell B3, B4 etc.

Hope you can understand what I want.

Regards

Amit

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




lookup values.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-17 Thread SG

experts please help me with this.i have also attached the file .

On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote:

 hi Paul,
  
 Sorry for the inconvenience.PFA file  names of excel file are 1,2,3.
 Please suggest.

 On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner wrote:

   I don't think we can work that way...
  
 You're using someone ELSE's macro with YOUR files and folders
 and you've admitted that you've edited the macro a little bit...
  
 and you want us to suggest how to fix it without seeing 
 the macro, your files and folders, and what edit's you've done?
  
 Well.. I GUESS I could suggest one thing:
  
 please give us more information.
 Perhaps attach a file.
  
 At the LEAST, attach the macro and tell us what your file names and 
 folder names are...
  

 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* SG sona...@gmail.com
 *To:* excel-...@googlegroups.com
 *Sent:* Fri, December 14, 2012 10:11:52 AM
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files

 thanks but the macro is not entering in to the loop.
 I have edited the macro lil bit at my end.I have removed the part which 
 is for saving the complied file  i think it's not going to effect anyway.
 please suggest..

 On Friday, December 14, 2012 8:31:22 PM UTC+5:30, Rajan_Verma wrote:

  *Ok,*

 * *

 *Open Visula Basic Editor*

 *Goto the Tool- Reference –Select **Microsoft scripting runtime***

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] 
 *On Behalf Of *SG
 *Sent:* 14 December 2012 8:26
 *To:* excel-...@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files

  
  
 may be i'm silly with the question, but really not getting it that you 
 have replied.
  

 On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote:

  *Ah..*

 * *

 *You can add reference “Microsoft scripting runtime”*

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] 
 *On Behalf Of *SG
 *Sent:* 14 December 2012 7:54
 *To:* excel-...@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files

  
  
 hi Rajan,
  
  
  
 Thanks for the reply.I have taken the macro from 2nd link.
  
 However on running the macro, the code in 4th line
  
 'Dim Fso As New Scripting.FileSystemObject' 
  
 gives an complie error 'user-defined type not defined'.
  
  
  
 please help on this.
 On Friday, December 14, 2012 7:28:17 PM UTC+5:30, Rajan_Verma wrote:

  *See if it helps*

 * *

 *1)**  **http://excelpoweruser. wordpress.com/2012/06/07/ 
 compile-worksheets/http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
 *

 *2)**  **http://excelpoweruser. wordpress.com/2011/08/12/ 
 compiling-workbooks-2/http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
 *

 *3)**  **http://excelpoweruser. wordpress.com/2011/07/06/ 
 compiling-workbooks/http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/
 *

 * *

 * *

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] 
 *On Behalf Of *SG
 *Sent:* 14 December 2012 7:19
 *To:* excel-...@googlegroups.com
 *Subject:* $$Excel-Macros$$ Consolidating Multiple files

  
  
 Hi Experts,
  
  
  
 I need your help in one of my problem.I want to consolidate the 
 multiple excel files of a folder with same name  numbered as 1,2,3 in to a 
 one excel file.I have tried but unable to create a macro on it.There is 
 only one criteria in this consolidation is that on column D of every sheet 
 is a date.What i want is to extract the data on basis of a particular week 
 number let's say we are in week 50  i want the data of week-49.Currently 
 i'm doing this manually.I apply the weeknum formula in column where data 
 gets end let's say that's column M  then extract the data.
  
  
  
 Please help me on this with a macro  thanks in advance.

 -- 
 Join official Facebook page of this forum @ https://www.facebook.com/ 
 discussexcel https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and

Re: $$Excel-Macros$$ Merge entry cell

Hi All Experts,
Pls give any solution.I will try it bu not sucess

On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal isk1...@gmail.com wrote:

 *Dear Amar,*
 *
 *
 *Pl share the test file.*
 *
 *
 *Regards*
 *Pravin Gunjal.*
 *
 *
 On Fri, Dec 14, 2012 at 5:50 PM, amar takale amartak...@gmail.com wrote:

 Dear Experts

 Pls can anybody help me on this matter.

 As always, Thank you very much for all the help

 Regards
 Amar



 On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.comwrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it is
 duplicate then over right on it

 Regards
 Amar

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

Hi Dear,

Solution is Perfect but waht is 10^10,I confused.I got Output but little
confusing.

Thank Very much


On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner ms.exl.lear...@gmail.comwrote:

 =LOOKUP(10^10,E7:H7,E7:H7)

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread NOORAIN ANSARI

Dear Amar,

Please explain your query and what is your exact requirment.

On Mon, Dec 17, 2012 at 6:06 PM, amar takale amartak...@gmail.com wrote:

 Hi All Experts,
 Pls give any solution.I will try it bu not sucess


 On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal isk1...@gmail.com wrote:

 *Dear Amar,*
 *
 *
 *Pl share the test file.*
 *
 *
 *Regards*
 *Pravin Gunjal.*
 *
 *
 On Fri, Dec 14, 2012 at 5:50 PM, amar takale amartak...@gmail.comwrote:

 Dear Experts

 Pls can anybody help me on this matter.

 As always, Thank you very much for all the help

 Regards
 Amar



 On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.comwrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it is
 duplicate then over right on it

 Regards
 Amar

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at

Re: $$Excel-Macros$$ how to create formula in vba through cell references

2012-12-17 Thread Amit Gandhi

Hi Swapnil

I am not very good in VBA, can you please send me macro code for this.

Regards

Amit


On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande 
palande.swapni...@gmail.com wrote:

 Hi,

 Try formula function of class Range

 Regards
 Swapnil
 On Dec 17, 2012 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote:

 Hi Experts

 I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
 sheet backup and get the desired results.

 activesheet.range(c2)= =LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*
 ^BSESN*_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)

 i need macro to get above red highlighted values from cell B3, B4 etc.

 Hope you can understand what I want.

 Regards

 Amit




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ How to develop Addins

2012-12-17 Thread Amit Desai (MERU)

Dear Friends,

Could you please help me understand how to write or develop Addin in Excel 
2007? Do we have a training material or some write ups for hint?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ To Add Comments based on Cell Value

2012-12-17 Thread Excel_Lover

Hi All,

Good Afternoon!!!

Can Somebody help me by giving a macro which can add comments based on a
cell value like,
In the attached workbook, sheet named 'Clients' I have a list of client
codes against which 'Details' sheet they have some requirements
in columns named 'Req.1' , 'Req.2', 'Req.3'  'Req.4'.
What I need is When I selected a client code in the 'Clients' Sheet the
list of their requirements should be listed in a comment box like I
inserted on Range A2.

Appreciate your solutions on this.

Best Regards
Excel_Lover

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




To Add Comments.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Regarding Result of Calendar Quiz.

2012-12-17 Thread SHREYAS GUPTA

Sir,
I saw the calendar made by Mr. Debaranjan. The calendar is not made by
Mr Debarajan himself it is downloaded from
http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx
and only modified by him. You can easily see the properties of the
excel calendar made by Mr. Debaranjan. Also the date of creation
exactly matches of the submitted calendar and the calendar given on
the above link (12/12/2008). I wonder how he got the first prize by
doing some mere changes in a downloaded calendar without even
mentioning the creator of the calender.


Regards
-- 
SHREYAS

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-17 Thread Timothy Kluck

That must be it! I think it's because your weekday formula return_type 
number (16) doesn't work in Excel 2007. I have the option of doing: 

 1  Returns a number from 1 (Sunday) to 7 (Saturday). 
 2  Returns a number from 1 (Monday) to 7 (Sunday).  3  Returns a number 
from 0 (Monday) to 6 (Sunday).


When I replace the formula with either 1, 2, or 3 - I receive a value - 
albeit an incorrect value. Do you know which return_type I should use and 
which corresponding formula (i.e. = 3, or =5, etc.) I should enter?

Thanks again for your help!

V/R,
Tim

On Sunday, December 16, 2012 11:45:11 AM UTC-5, Paul Schreiner wrote:

 Are you using Excel 2007 or Excel 2010?
  
 I'm using Excel2010.
 When I first open your files, I see the #NUM! values.
  
 But when I click the edit button, the errors go away and the values 
 appear.
  
  

 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Timothy Kluck timk...@gmail.com javascript:
 *To:* excel-...@googlegroups.com javascript:
 *Sent:* Fri, December 14, 2012 4:19:45 PM
 *Subject:* Re: $$Excel-Macros$$ Calculate Business Hours exluding 
 weekends and holidays with a caveat

 Paul,

 I can't thank you enough for working so hard on this. I definitely 
 understand your logic but unfortunately when I try to create the Start 
 (adj) column, it returns the error #NUM!. What is weird is that the 
 End(adj) column works fine. Do you have any idea why this would happen? I 
 have attached my spreadsheet.

 Thanks again for being so on top of this.

 V/R,
 Tim



 On Friday, December 14, 2012 3:36:07 PM UTC-5, Paul Schreiner wrote: 

   Timothy,
  
 OK, I played with it a while, using formulas.
 I'm not sure it you'll be able to manage it, or even follow along (I have 
 trouble, and I WROTE IT)
  Most of the columns you don't need.
 Just the original start/end times
 the adjusted start/end times
 and the Hours.
  
 The rest is for trying to develop the logic and visually SEE the data 
 represented.
  
 Here's the logic:
  
 First, I checked the time of day for the entries.
 For the start time:
 If it was before 6:00am, I adjusted it to 6:00am of the same day.
 If it was after 9:00pm, I adjusted it to 6:00am of the FOLLOWING day.
  
 Next, I checked to see if the resulting day was on a Saturday or Sunday.
 If it was, I adjusted it to the following Monday.
  
 One issue here that I haven't been able to account for is if the start 
 day was actually on a Holiday.
 I haven't figured out how to adjust for that one...
  
 For the End time, the adjustments were similar except that:
 If the End time was after 9:00pm, I adjusted it to 9:00pm of the same day.
 If the End time was before 6:00am, I adjusted it to 9:00pm of the 
 previous day.
  
 These new date/times I then used Networkdays to determine the number of 
 working days between the adjusted dates.
 then, I removed any partial days (hours after 6:00am and before 9:00pm)
  
 I left several sample data records in place for testing purposes...
  
 So far, it LOOKS ok, but you'll have to be the judge.
  
 I think if we need to do anything further with the logic, I'll go ahead 
 and develop a UDF.
  

 *Paul*

 -- ---
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-- ---


  --
 *From:* Timothy Kluck timk...@gmail.com
 *To:* excel-...@googlegroups.com
 *Sent:* Fri, December 14, 2012 11:08:13 AM
 *Subject:* Re: $$Excel-Macros$$ Calculate Business Hours exluding 
 weekends and holidays with a caveat

 Paul,

 Thanks for getting back so quickly. For Row 11, that was my error, it was 
 suppose to end the following day at 11:00 AM (giving us a total of 5 
 Business Hours). I have attached the revised spreadsheet. 

 Perhaps a little more explanation on my part can help. I am trying to 
 measure a Help Desk Service Provider and their Resolution Time for a call 
 request.

 The Start Time (in the attached file) is when a Help Desk call is 
 answered and the End Time (in the attached file) is when the Help Desk call 
 request is resolved. Unfortunately, the contract for the service provider 
 is measured in Business Hours (from 6:00 AM - 9:00 PM, excluding weekends 
 and holidays). So that means if a call didn't take place during any type of 
 business hour (between the Start Time and End Time), we have to disregard 
 that call completely from any performance calculation. 

 So, if a call came in on Saturday 11/17 at 8:30 AM and was completed on 
 Saturday 11/17 at 11:30 PM, we would have to

$$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

2012-12-17 Thread Paul Schreiner

As noted by Shreyas Gupta, it seems that Debaranan has submitted someone 
else's work as  his own.
I will speak with Ayush to determine how best to handle this situation.
 
Paul

On Thursday, December 13, 2012 2:11:20 PM UTC-5, Paul Schreiner wrote:

 Results of the recent Calendar Challenge are IN !
 The competition was furious, and the judging, difficult.
  
 The goal was to create a calendar in excel using Functions ONLY (no user 
 defined macros).
 The calendar should be displayed on a single sheet, and update dynamically 
 for any given year.
 And above all, ACCURATE (February 29th included where appropriate)
  
 I was honored to be asked to guest-judge the submissions.
  
 Developing criteria for selecting a calendar OBJECTIVELY was difficult.
 After all, the calendars weren't designed for ME specifically.  
 So I had to avoid placing value on my own personal preferences.
 For instance, I personally would have put the holiday list on a 
 different sheet 
 so that the holidays for the next 20 years could be determined and 
 recorded.
 Along with birthdays, anniversaries, etc.
 But another user would prefer to see the specific holidays for the 
 displayed calendar year.
 so, which is better? depends on who's buying the coffee ;o)
  
 After many hours of testing and review, I've come up with the following 
 Recommendations:
  
 First Prize:
 *Debaranjan*
 All functions seem to operate as designed.
 The Event/Holiday list is easy to manage.
 The main problems I observed were:

- that the background obscures some of the dates (primarily in June) 
- It does not highlight the current date 
- It doesn't print properly (in case you wanted to hang it on your 
wall to mark off the days until your next vacation!)

 Runner up:

 *Vinay Gupta*
 This calendar is visually pleasing, and easy to read.
 All functions seem to operate as designed.

 The main problems with it that I observed were:

- The many of the dates in the Holiday list and today did not 
display properly.  Because the sheet is protected, I could not correct the 
formatting.  
- The Holiday list is limited to 20 dates.  If the user wishes to 
include birthdays and anniversaries, it could easily to exceed this limit.

 Congratulations to the winners! 

 and Thank You to all contributors!

 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-17 Thread Paul Schreiner

I'll have to look at it and figure out how to calculate it differently.
I'll get back to you soon.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Timothy Kluck timkl...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, December 17, 2012 10:02:59 AM
Subject: Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and 
holidays with a caveat

That must be it! I think it's because your weekday formula return_type number 
(16) doesn't work in Excel 2007. I have the option of doing: 




1  Returns a number from 1 (Sunday) to 7 (Saturday). 
 
2  Returns a number from 1 (Monday) to 7 (Sunday). 
3  Returns a number from 0 (Monday) to 6 (Sunday).


 When I replace the formula with either 1, 2, or 3 - I receive a value - albeit 
an incorrect value. Do you know which return_type I should use and which 
corresponding formula (i.e. = 3, or =5, etc.) I should enter?

Thanks again for your help!

V/R,
Tim

On Sunday, December 16, 2012 11:45:11 AM UTC-5, Paul Schreiner wrote: 
Are you using Excel 2007 or Excel 2010?

I'm using Excel2010.
When I first open your files, I see the #NUM! values.

But when I click the edit button, the errors go away and the values appear.
 

Paul
-- ---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-- ---






From: Timothy Kluck timk...@gmail.com
To: excel-...@googlegroups.com
Sent: Fri, December 14, 2012 4:19:45 PM
Subject: Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and 
holidays with a caveat

Paul,

I can't thank you enough for working so hard on this. I definitely understand 
your logic but unfortunately when I try to create the Start (adj) column, it 
returns the error #NUM!. What is weird is that the End(adj) column works fine. 
Do you have any idea why this would happen? I have attached my spreadsheet.

Thanks again for being so on top of this.

V/R,
Tim



On Friday, December 14, 2012 3:36:07 PM UTC-5, Paul Schreiner wrote: 
Timothy,

OK, I played with it a while, using formulas.
I'm not sure it you'll be able to manage it, or even follow along (I have 
trouble, and I WROTE IT)
 Most of the columns you don't need.
Just the original start/end times
the adjusted start/end times
and the Hours.

The rest is for trying to develop the logic and visually SEE the data 
represented.

Here's the logic:

First, I checked the time of day for the entries.
For the start time:
If it was before 6:00am, I adjusted it to 6:00am of the same day.
If it was after 9:00pm, I adjusted it to 6:00am of the FOLLOWING day.

Next, I checked to see if the resulting day was on a Saturday or Sunday.
If it was, I adjusted it to the following Monday.

One issue here that I haven't been able to account for is if the start day 
was 
actually on a Holiday.
I haven't figured out how to adjust for that one...

For the End time, the adjustments were similar except that:
If the End time was after 9:00pm, I adjusted it to 9:00pm of the same day.
If the End time was before 6:00am, I adjusted it to 9:00pm of the previous 
day.

These new date/times I then used Networkdays to determine the number of 
working 
days between the adjusted dates.
then, I removed any partial days (hours after 6:00am and before 9:00pm)

I left several sample data records in place for testing purposes...

So far, it LOOKS ok, but you'll have to be the judge.

I think if we need to do anything further with the logic, I'll go ahead and 
develop a UDF.
 
Paul
-- ---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-- ---






From: Timothy Kluck timk...@gmail.com
To: excel-...@googlegroups.com
Sent: Fri, December 14, 2012 11:08:13 AM
Subject: Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and 
holidays with a caveat

Paul,

Thanks for getting back so quickly. For Row 11, that was my error, it was 
suppose to end the following day at 11:00 AM (giving us a total of 5 Business 
Hours). I have attached the revised spreadsheet. 


Perhaps a little more explanation on my part can help. I am trying to measure 
a 
Help Desk Service Provider and their Resolution Time for a call request.

The Start Time (in the attached file) is when a Help Desk call is answered 
and 
the End Time (in the attached file) is when the Help Desk call request

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

2012-12-17 Thread Hilary Lomotey

Hi Paul, when are we seeing the rest of the calenders,

is it possible to load it to say skydrive or any web hosting site and send
us a link to download.

thanks

On Mon, Dec 17, 2012 at 3:07 PM, Paul Schreiner schreiner_p...@att.netwrote:

[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup
rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DKHhYqc5H%252FVRPoAhdSr6b5v%252Funxp0JAGJyz%252BSf8NeN5c%252B96oNOiuRA%252BHi2NIpvQ418uVkYEeg042k13ZU%252FBOVnI54lB1sZCLHfaRsq4fOPwpdFwFJ9pgdBqjc5M7JCwg1nNDZ%252FJot8chJBdvN0O8%252BFg%253D%253D%26key%3DBjG7rkjSgOZ1BZNiL250DItx2n8y7dqIcHEU58g8cMc%253Dtc=13141251529_1497301372|
More
infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13141251529_1497301372

As noted by Shreyas Gupta, it seems that Debaranan has submitted someone
else's work as his own.
I will speak with Ayush to determine how best to handle this situation.

Paul

On Thursday, December 13, 2012 2:11:20 PM UTC-5, Paul Schreiner wrote:

Results of the recent Calendar Challenge are IN !
The competition was furious, and the judging, difficult.

The goal was to create a calendar in excel using Functions ONLY (no user
defined macros).
The calendar should be displayed on a single sheet, and update
dynamically for any given year.
And above all, ACCURATE (February 29th included where appropriate)

I was honored to be asked to guest-judge the submissions.

Developing criteria for selecting a calendar OBJECTIVELY was difficult.
After all, the calendars weren't designed for ME specifically.
So I had to avoid placing value on my own personal preferences.
For instance, I personally would have put the holiday list on a
different sheet
so that the holidays for the next 20 years could be determined and
recorded.
Along with birthdays, anniversaries, etc.
But another user would prefer to see the specific holidays for the
displayed calendar year.
so, which is better? depends on who's buying the coffee ;o)

After many hours of testing and review, I've come up with the following
Recommendations:

First Prize:
*Debaranjan*
All functions seem to operate as designed.
The Event/Holiday list is easy to manage.
The main problems I observed were:

- that the background obscures some of the dates (primarily in June)
- It does not highlight the current date
- It doesn't print properly (in case you wanted to hang it on your
wall to mark off the days until your next vacation!)

Runner up:

*Vinay Gupta*
This calendar is visually pleasing, and easy to read.
All functions seem to operate as designed.

The main problems with it that I observed were:

- The many of the dates in the Holiday list and today did not
display properly. Because the sheet is protected, I could not correct the
formatting.
- The Holiday list is limited to 20 dates. If the user wishes to
include birthdays and anniversaries, it could easily to exceed this limit.

Congratulations to the winners!

and Thank You to all contributors!

*Paul*

--**---
*“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*--**---

--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs

Re: $$Excel-Macros$$ Formula to Calculate Weeks

2012-12-17 Thread t vinay

Thanks Paul.

On 13 December 2012 18:30, Paul Schreiner schreiner_p...@att.net wrote:

 That is correct.
 # (days) / 7 (days/week) = # (weeks)


 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Sunnie sunni...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Wed, December 12, 2012 9:56:22 PM
 *Subject:* Re: $$Excel-Macros$$ Formula to Calculate Weeks

 Hi Paul,
 is the reason one would divide by 7 is because there is 7 days in a week?

 Susan

 On Thursday, December 6, 2012 7:58:00 AM UTC-8, Paul Schreiner wrote:

   WEEKS is easy.
 Keep in mind that Excel dates are simply numbers.
 The number of days since 1/1/1900.

 You can use =TODAY() to get today's date:
 So today (12/6/2013) is: 41249

 a future date, for say, 11/8/2014 is 41951
 The difference is: 41951 - 41249 = 702
 divide that by 7 to get the number of weeks: 100.285714285714
 Rouned off to even weeks is: 100

 If you have the future date in Cell A1,
 you could use: =ROUND((A1-TODAY())/7,0)


 *Paul*

 -- ---
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-- ---


  --
 *From:* t vinay vinay...@gmail.com
 *To:* excel-...@googlegroups.com
 *Sent:* Thu, December 6, 2012 10:19:25 AM
 *Subject:* $$Excel-Macros$$ Formula to Calculate Weeks

 Hi Team,

 can you please help me with a formula to calculate the number of weeks
 from today to a future date.



 --
 Regards,

 Vinay. T

 --
 Join official Facebook page of this forum @ https://www.facebook.com/
 discussexcel https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@
 googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group,

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Matt

Hi, i put the link at the bottom of. my question.
tx

here is the link with the spreadsheet

 https://www.box.com/s/33z5kuabqbjn2b971ae6
 
matt

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

Hi Amar,

But Amar what about if there is number like : 2 ,2,3,4 then what should be 
the output for this.

Regards
Prince

On Monday, December 17, 2012 6:32:12 PM UTC+5:30, amar takale wrote:

 Dear Noorain,
 Actually I want Each column filled by different person  after finish data 
 entry I consolidated all column in one sheet then some of data entry is 
 same in column but I want If same entry then show same one single unique 
 number in K column.If more than two person input same numbers then show 
 only that one same numbers in column K
 I hope you understand my Query 
 I have attached the excel sheet

 Regards Amar



 On Mon, Dec 17, 2012 at 6:10 PM, NOORAIN ANSARI 
 noorain...@gmail.comjavascript:
  wrote:

 Dear Amar,

 Please explain your query and what is your exact requirment.


 On Mon, Dec 17, 2012 at 6:06 PM, amar takale amart...@gmail.comjavascript:
  wrote:

 Hi All Experts,
 Pls give any solution.I will try it bu not sucess


 On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal 
 isk...@gmail.comjavascript:
  wrote:

 *Dear Amar,*
 *
 *
 *Pl share the test file.*
 *
 *
 *Regards*
 *Pravin Gunjal.*
 *
 *
 On Fri, Dec 14, 2012 at 5:50 PM, amar takale 
 amart...@gmail.comjavascript:
  wrote:

 Dear Experts

 Pls can anybody help me on this matter.

 As always, Thank you very much for all the help

 Regards
 Amar



 On Thu, Dec 13, 2012 at 1:00 PM, amar takale 
 amart...@gmail.comjavascript:
  wrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it 
 is duplicate then over right on it

 Regards
 Amar 

  -- 
 Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like 
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to 
 excel-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en
 .
  
  


  -- 
 Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like 
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to 
 excel-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  


  -- 
 Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to 
 excel-...@googlegroups.comjavascript:
 .
 To unsubscribe from this group, send email to 
 excel-macros...@googlegroups.com javascript:.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  


  -- 
 Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Sub add_comment()
Dim i As Long
Dim x As String, found As Range
Dim j As Long, k As Long

For i = 2 To Sheets(Clients).Range(a1).End(xlDown).Row
Set found =
Sheets(Details).Range(a:a).Find(Sheets(Clients).Cells(i, 1).Value,
LookIn:=xlValues)
If Not found Is Nothing Then
j = found.Row
x = 
For k = 2 To Sheets(Details).Range(a1).End(xlToRight).Column
If Sheets(Details).Cells(j, k).Value   Then
x = x  Sheets(Details).Cells(j, k).Value  vbCrLf
End If
Next k
On Error Resume Next
Sheets(Clients).Cells(i, 1).Comment.Delete
Sheets(Clients).Cells(i, 1).AddComment x
End If

Next i
End Sub




On Mon, Dec 17, 2012 at 6:44 PM, Excel_Lover idforex...@gmail.com wrote:

 Hi All,

 Good Afternoon!!!

 Can Somebody help me by giving a macro which can add comments based on a
 cell value like,
 In the attached workbook, sheet named 'Clients' I have a list of
 client codes against which 'Details' sheet they have some requirements
 in columns named 'Req.1' , 'Req.2', 'Req.3'  'Req.4'.
 What I need is When I selected a client code in the 'Clients' Sheet the
 list of their requirements should be listed in a comment box like I
 inserted on Range A2.

 Appreciate your solutions on this.

 Best Regards
 Excel_Lover

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

2012-12-17 Thread Excel_Lover

Hi Ashish,

Thank you very much.

Works fine, saved lot of time.

Thanks.



On Mon, Dec 17, 2012 at 7:11 PM, ashish koul koul.ash...@gmail.com wrote:

 Sub add_comment()
 Dim i As Long
 Dim x As String, found As Range
 Dim j As Long, k As Long

 For i = 2 To Sheets(Clients).Range(a1).End(xlDown).Row
 Set found =
 Sheets(Details).Range(a:a).Find(Sheets(Clients).Cells(i, 1).Value,
 LookIn:=xlValues)
 If Not found Is Nothing Then
 j = found.Row
 x = 
 For k = 2 To Sheets(Details).Range(a1).End(xlToRight).Column
 If Sheets(Details).Cells(j, k).Value   Then
 x = x  Sheets(Details).Cells(j, k).Value  vbCrLf
 End If
 Next k
 On Error Resume Next
 Sheets(Clients).Cells(i, 1).Comment.Delete
 Sheets(Clients).Cells(i, 1).AddComment x
 End If

 Next i
 End Sub




 On Mon, Dec 17, 2012 at 6:44 PM, Excel_Lover idforex...@gmail.com wrote:

 Hi All,

 Good Afternoon!!!

 Can Somebody help me by giving a macro which can add comments based on a
 cell value like,
 In the attached workbook, sheet named 'Clients' I have a list of
 client codes against which 'Details' sheet they have some requirements
 in columns named 'Req.1' , 'Req.2', 'Req.3'  'Req.4'.
 What I need is When I selected a client code in the 'Clients' Sheet the
 list of their requirements should be listed in a comment box like I
 inserted on Range A2.

 Appreciate your solutions on this.

 Best Regards
 Excel_Lover

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *http://www.excelvbamacros.com/*
 *http://www.accessvbamacros.com/*

 P Before printing, think about the environment.



  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Best Regards
Excel_Lover

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread Ms-Exl-Learner .

Even shorter than the previous one,
=LOOKUP(10^10,E7:H7)

Just type =10^10 in a cell for knowing the evaluated result.

On 12/17/12, amar takale amartak...@gmail.com wrote:
 Hi Dear,

 Solution is Perfect but waht is 10^10,I confused.I got Output but little
 confusing.

 Thank Very much


 On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner
 ms.exl.lear...@gmail.comwrote:

 =LOOKUP(10^10,E7:H7,E7:H7)

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.





-- 

*Ms.Exl.Learner*


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Excel macro help please

2012-12-17 Thread sw1085

Hi all,

I've been searching for hours looking for a generic macro to help with the 
following problem.

If cell value in column J of worksheet Sheet1 = Apple or Pear then 
copy that cell plus the previous 4 cells to a new worksheet called Sheet2.

Hope someone can help.

Best regards

sw1085

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Excel macro help please

can you share the sample file


On Mon, Dec 17, 2012 at 9:57 PM, sw1085 swilson2...@gmail.com wrote:

 Hi all,

 I've been searching for hours looking for a generic macro to help with the
 following problem.

 If cell value in column J of worksheet Sheet1 = Apple or Pear then
 copy that cell plus the previous 4 cells to a new worksheet called Sheet2.

 Hope someone can help.

 Best regards

 sw1085

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Consolidating Multiple files

hi

*can you share the input file and final output file too*

Regards
Ashish


On Mon, Dec 17, 2012 at 5:46 PM, SG sonal...@gmail.com wrote:

 experts please help me with this.i have also attached the file .

 On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote:

 hi Paul,

 Sorry for the inconvenience.PFA file  names of excel file are 1,2,3.
 Please suggest.

 On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner wrote:

   I don't think we can work that way...

 You're using someone ELSE's macro with YOUR files and folders
 and you've admitted that you've edited the macro a little bit...

 and you want us to suggest how to fix it without seeing
 the macro, your files and folders, and what edit's you've done?

 Well.. I GUESS I could suggest one thing:

 please give us more information.
 Perhaps attach a file.

 At the LEAST, attach the macro and tell us what your file names and
 folder names are...


 *Paul*

 --**---
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *--**---


  --
 *From:* SG sona...@gmail.com
 *To:* excel-...@googlegroups.com
 *Sent:* Fri, December 14, 2012 10:11:52 AM
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files

 thanks but the macro is not entering in to the loop.
 I have edited the macro lil bit at my end.I have removed the part which
 is for saving the complied file  i think it's not going to effect anyway.
 please suggest..

 On Friday, December 14, 2012 8:31:22 PM UTC+5:30, Rajan_Verma wrote:

  *Ok,*

 * *

 *Open Visula Basic Editor*

 *Goto the Tool- Reference –Select **Microsoft scripting runtime***

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com]
 *On Behalf Of *SG
 *Sent:* 14 December 2012 8:26
 *To:* excel-...@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files



 may be i'm silly with the question, but really not getting it that you
 have replied.


 On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote:

  *Ah..*

 * *

 *You can add reference “Microsoft scripting runtime”*

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com]
 *On Behalf Of *SG
 *Sent:* 14 December 2012 7:54
 *To:* excel-...@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files



 hi Rajan,



 Thanks for the reply.I have taken the macro from 2nd link.

 However on running the macro, the code in 4th line

 'Dim Fso As New Scripting.FileSystemObject'

 gives an complie error 'user-defined type not defined'.



 please help on this.
 On Friday, December 14, 2012 7:28:17 PM UTC+5:30, Rajan_Verma wrote:

  *See if it helps*

 * *

 *1)**  **http://excelpoweruser. wordpress.com/2012/06/07/
 compile-worksheets/http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
 *

 *2)**  **http://excelpoweruser. wordpress.com/2011/08/12/
 compiling-workbooks-2/http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
 *

 *3)**  **http://excelpoweruser. wordpress.com/2011/07/06/
 compiling-workbooks/http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/
 *

 * *

 * *

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com]
 *On Behalf Of *SG
 *Sent:* 14 December 2012 7:19
 *To:* excel-...@googlegroups.com
 *Subject:* $$Excel-Macros$$ Consolidating Multiple files



 Hi Experts,



 I need your help in one of my problem.I want to consolidate the
 multiple excel files of a folder with same name  numbered as 1,2,3 in to a
 one excel file.I have tried but unable to create a macro on it.There is
 only one criteria in this consolidation is that on column D of every sheet
 is a date.What i want is to extract the data on basis of a particular week
 number let's say we are in week 50  i want the data of week-49.Currently
 i'm doing this manually.I apply the weeknum formula in column where data
 gets end let's say that's column M  then extract the data.



 Please help me on this with a macro  thanks in advance.

 --
 Join official Facebook page of this forum @ https://www.facebook.com/
 discussexcel https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs

Re: $$Excel-Macros$$ small query

*With formula*  http://web.pdx.edu/~wde/Code/Excel_Files/No_VBA_Spellout.php
VBA  http://www.contextures.com/excelfilesRon.html#RF0001
 http://support.microsoft.com/kb/213360



On Mon, Dec 17, 2012 at 1:20 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Delin,

 Please see attached sheet with Excel and VBA solution both.

 On Mon, Dec 17, 2012 at 12:55 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote:


   HI friends...

 A small query in excel is there any way to convert numbers in to words
 eg :-
 1202  = One Thousand two hundred and Two

 for more details find the attached file

 thanking you all in advance

 regards


 *Delin.F*

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http:// 
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/


  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

RE: $$Excel-Macros$$ How to develop Addins

2012-12-17 Thread Amit Desai (MERU)

Dear Ashish,

Thanks will check..

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ashish koul
Sent: 17 December 2012 22:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to develop Addins

try these

http://www.ozgrid.com/VBA/excel-add-in-create.htm
http://www.rondebruin.nl/qat.htm
http://www.rondebruin.nl/contextmenu.htm
http://www.rondebruin.nl/qat2.htm




On Mon, Dec 17, 2012 at 6:27 PM, Amit Desai (MERU) 
amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote:
Dear Friends,

Could you please help me understand how to write or develop Addin in Excel 
2007? Do we have a training material or some write ups for hint?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.





--
Regards

Ashish Koul


Visit
http://www.excelvbamacros.com/
http://www.accessvbamacros.com/

P Before printing, think about the environment.


--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are

Re: $$Excel-Macros$$ Re: Find and the current data on Form

try this code for  *ComboBox1_Change()*

Private Sub ComboBox1_Change()
Dim rw As Long, cl As Range, found As Range

 Set found = Worksheets(ThamDinh).Range(A:A).Find(Me.ComboBox1.Value,
LookIn:=xlValues)
If Not found Is Nothing Then
rw = found.Row
tbxSoTT = Worksheets(ThamDinh).Range(a  rw).Offset(0, 0)
tbxTenDuAn = Worksheets(ThamDinh).Range(a  rw).Offset(0, 1)
tbxDot = Worksheets(ThamDinh).Range(a  rw).Offset(0, 2)
tbxHuyen = Worksheets(ThamDinh).Range(a  rw).Offset(0, 3)
tbxSoToTrinh = Worksheets(ThamDinh).Range(a  rw).Offset(0, 4)
tbxNgayKyTTr = Worksheets(ThamDinh).Range(a  rw).Offset(0, 5)
tbxNguoiXuLy = Worksheets(ThamDinh).Range(a  rw).Offset(0, 6)
End If
End Sub

check the attachment see if it helps



On Sun, Dec 16, 2012 at 2:41 PM, Prince prince141...@gmail.com wrote:

 hi be tran van
 share your file with me.

 regards
 prince

 On Saturday, December 15, 2012 9:58:14 PM UTC+5:30, bé trần văn wrote:

 Welcome Prince.

 File TIEN TIM 3 if I format the Number type, the error happened 1004
 (Unable to get the match property of the WorksheetFunction class), in
 column A, I need to be of type Number, you can help me to use the
 Number format (because I need the model number), like ComboBox2 (Find
 treatment) used for any format.
 Thank you.


 2012/12/15, Bé Trần Văn betnmtd...@gmail.com:
  Thanks Prince.
  Thanks for your quick reply, once again thank you.
 
  2012/12/15, Prince prince...@gmail.com:
  Hi bé trần văn
 
  your data in column A:A have spaces thats why it is not matching with
  current selection of the combo box. but for now i have trim the data
 in
  column  A and it is working.
  please see the attached.
 
  regards
  prince
 
  On Friday, December 14, 2012 9:35:43 PM UTC+5:30, bé trần văn wrote:
 
  In File TIEN TIM 3, in combo Find the handle has done well, but in
 the
  Find combo TT when click 1 in the combo, the data in row 5 is
  displayed on the form in error, I find no error.
  Hope you fix this for, thanks a lot.
 
 
  --
  Join official Facebook page of this forum @
  https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like
 Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice
  will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE  : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-...@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros...@**googlegroups.com.
  Visit this group at http://groups.google.com/**
 group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en.

 
 
 
 

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their

Re: $$Excel-Macros$$ Re: Find and the current data on Form

try this code for  *ComboBox1_Change()*

Private Sub ComboBox1_Change()
Dim rw As Long, cl As Range, found As Range

 Set found = Worksheets(ThamDinh).Range(A:A).Find(Me.ComboBox1.Value,
LookIn:=xlValues)
If Not found Is Nothing Then
rw = found.Row
tbxSoTT = Worksheets(ThamDinh).Range(a  rw).Offset(0, 0)
tbxTenDuAn = Worksheets(ThamDinh).Range(a  rw).Offset(0, 1)
tbxDot = Worksheets(ThamDinh).Range(a  rw).Offset(0, 2)
tbxHuyen = Worksheets(ThamDinh).Range(a  rw).Offset(0, 3)
tbxSoToTrinh = Worksheets(ThamDinh).Range(a  rw).Offset(0, 4)
tbxNgayKyTTr = Worksheets(ThamDinh).Range(a  rw).Offset(0, 5)
tbxNguoiXuLy = Worksheets(ThamDinh).Range(a  rw).Offset(0, 6)
End If
End Sub

check the attachment see if it helps


On Sun, Dec 16, 2012 at 2:41 PM, Prince prince141...@gmail.com wrote:

 hi be tran van
 share your file with me.

 regards
 prince

 On Saturday, December 15, 2012 9:58:14 PM UTC+5:30, bé trần văn wrote:

 Welcome Prince.

 File TIEN TIM 3 if I format the Number type, the error happened 1004
 (Unable to get the match property of the WorksheetFunction class), in
 column A, I need to be of type Number, you can help me to use the
 Number format (because I need the model number), like ComboBox2 (Find
 treatment) used for any format.
 Thank you.


 2012/12/15, Bé Trần Văn betnmtd...@gmail.com:
  Thanks Prince.
  Thanks for your quick reply, once again thank you.
 
  2012/12/15, Prince prince...@gmail.com:
  Hi bé trần văn
 
  your data in column A:A have spaces thats why it is not matching with
  current selection of the combo box. but for now i have trim the data
 in
  column  A and it is working.
  please see the attached.
 
  regards
  prince
 
  On Friday, December 14, 2012 9:35:43 PM UTC+5:30, bé trần văn wrote:
 
  In File TIEN TIM 3, in combo Find the handle has done well, but in
 the
  Find combo TT when click 1 in the combo, the data in row 5 is
  displayed on the form in error, I find no error.
  Hope you fix this for, thanks a lot.
 
 
  --
  Join official Facebook page of this forum @
  https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like
 Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice
  will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE  : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-...@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros...@**googlegroups.com.
  Visit this group at http://groups.google.com/**
 group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en.

 
 
 
 

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links

Re: $$Excel-Macros$$ Re: Find and the current data on Form

2012-12-17 Thread Bé Trần Văn

Thanks Ashish koul
You were quick to answer, your answer is very good, sincerely thanks.

2012/12/18, ashish koul koul.ash...@gmail.com:
 try this code for  *ComboBox1_Change()*

 Private Sub ComboBox1_Change()
 Dim rw As Long, cl As Range, found As Range

  Set found = Worksheets(ThamDinh).Range(A:A).Find(Me.ComboBox1.Value,
 LookIn:=xlValues)
 If Not found Is Nothing Then
 rw = found.Row
 tbxSoTT = Worksheets(ThamDinh).Range(a  rw).Offset(0, 0)
 tbxTenDuAn = Worksheets(ThamDinh).Range(a  rw).Offset(0, 1)
 tbxDot = Worksheets(ThamDinh).Range(a  rw).Offset(0, 2)
 tbxHuyen = Worksheets(ThamDinh).Range(a  rw).Offset(0, 3)
 tbxSoToTrinh = Worksheets(ThamDinh).Range(a  rw).Offset(0, 4)
 tbxNgayKyTTr = Worksheets(ThamDinh).Range(a  rw).Offset(0, 5)
 tbxNguoiXuLy = Worksheets(ThamDinh).Range(a  rw).Offset(0, 6)
 End If
 End Sub

 check the attachment see if it helps


 On Sun, Dec 16, 2012 at 2:41 PM, Prince prince141...@gmail.com wrote:

 hi be tran van
 share your file with me.

 regards
 prince

 On Saturday, December 15, 2012 9:58:14 PM UTC+5:30, bé trần văn wrote:

 Welcome Prince.

 File TIEN TIM 3 if I format the Number type, the error happened 1004
 (Unable to get the match property of the WorksheetFunction class), in
 column A, I need to be of type Number, you can help me to use the
 Number format (because I need the model number), like ComboBox2 (Find
 treatment) used for any format.
 Thank you.


 2012/12/15, Bé Trần Văn betnmtd...@gmail.com:
  Thanks Prince.
  Thanks for your quick reply, once again thank you.
 
  2012/12/15, Prince prince...@gmail.com:
  Hi bé trần văn
 
  your data in column A:A have spaces thats why it is not matching with
  current selection of the combo box. but for now i have trim the data
 in
  column  A and it is working.
  please see the attached.
 
  regards
  prince
 
  On Friday, December 14, 2012 9:35:43 PM UTC+5:30, bé trần văn wrote:
 
  In File TIEN TIM 3, in combo Find the handle has done well, but in
 the
  Find combo TT when click 1 in the combo, the data in row 5 is
  displayed on the form in error, I find no error.
  Hope you fix this for, thanks a lot.
 
 
  --
  Join official Facebook page of this forum @
  https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like
 Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice
  will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE  : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-...@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros...@**googlegroups.com.
  Visit this group at http://groups.google.com/**
 group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en.

 
 
 
 

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *http://www.excelvbamacros.com/*


 P Before printing, think about the environment.

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or

$$Excel-Macros$$ How to creat circle on cells

2012-12-17 Thread Secret Shot

Dear Group,

Kindly help me, i want to create Circles around the cells. means if i have
some Numbers in any excel sheet and i want circle to be created on cell who
have numbers less then 30.
please help me.

-- 
Pankaj Pandey
Bhopal

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ How to creat circle on cells

2012-12-17 Thread Paul Schreiner

How are you wanting this to happen?
Are you wanting to make it so that it adds the circles automatically when the 
cell value changes?
or are you wanting to run a macro (hit a button) and have it add the circles?

Keep in mind that circles would be DRAWING OBJECTS and have no actual 
association with the cell or cell value.

Now, some drawing objects have an attribute that gives a nearby cell.
But many times, this cell reference is the cell closest to the left-most 
portion 
of the drawing object.
Which, if the circle is around the entire cell, would most likely be the cell 
immediately to the left of the target cell.

also.. when the cell value changes, and number no longer dictates that the 
circle be displayed,
it may be difficult to tell if there is a circle currently present.

Since drawing objects are not an attribute of the cell,
in order to determine if there is a drawing object near the cell, you have to 
loop through the collection of drawing objects on the sheet and look for 
the top-left and/or bottom right cell for each drawing object.

Depending on your purpose for this, it might be too cumbersome to do.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Secret Shot secrets...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, December 17, 2012 2:16:05 PM
Subject: $$Excel-Macros$$ How to creat circle on cells

Dear Group, 

Kindly help me, i want to create Circles around the cells. means if i have some 
Numbers in any excel sheet and i want circle to be created on cell who have 
numbers less then 30.
please help me.

-- 
Pankaj Pandey
Bhopal
-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Excel Macro

2012-12-17 Thread Michael Cho

Hi 
c

Michael Cho

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

RE: $$Excel-Macros$$ How to creat circle on cells

2012-12-17 Thread Asa Rossoff

Hi Pankaj,

If you want circles around the cells with values less than 30, there are two
methods that come to mind.

(1)Use a data validation rule that specifies that values = 30 are the
only valid values (you can disable all warnings in the data validation rule
so it will allow entry of values less than 30 without warning).  Then,
select the option Data Validation - Circle Invalid Data.  The circles do
not update automatically, so you need to select that option each time you
want to check for values 30.  To clear the circles, use  Data
ValidationClear Validation Circles.

(2)   Use VBA either in conjunction with option (1) above to update the
validation circles anytie data changes, or else use VBA to draw circles on
the worksheet as appropriate using drawing object (complex and I hesitate to
reccomend it).

 

If you are willing to consider indicators OTHER than circles, you have
possibly even better options:

(1)Use Conditional formatting to highlight the cells with values  30.

(2)   In Excel 2007+ you have some sophisticated conditional formatting
options that may be of interest.  For example

a.  The rule type Format all cells based on their values allows you to
have Excel draw in-cell data bars, use 2 or 3-color scales for values in
different ranges, or use a set of in-cell colored icons.

b.  You could for example have a red down arrow appear in all cells
whose value is less than 30 using this rule type. You can find instructions
on using conditional formatting with icons at the following link:
http://msdn.microsoft.com/en-us/library/office/bb407306%28v=office.11%29.asp
x

 

If you need a more detailed walk-though, or you're sure none of the listed
options suffice, let me know and I'll see what I can come up with.

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Secret Shot
Sent: Monday, December 17, 2012 11:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to creat circle on cells

 

Dear Group,

 

Kindly help me, i want to create Circles around the cells. means if i have
some Numbers in any excel sheet and i want circle to be created on cell who
have numbers less then 30.

please help me.


 

-- 
Pankaj Pandey
Bhopal

-- 
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

Dear Parvin,
I want like
If same number all cell something cell also miss=one number which same
If single number=show single number

that it simple. I used Ms-Exl-Learner that perfect but if all cell same but
last cell different number then show that numbers,I want that time show
error then i will know something is problem.If there are no numbers in cell
then cell show blank not NA.

Regards
Amar

On Mon, Dec 17, 2012 at 9:54 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:

 Even shorter than the previous one,
 =LOOKUP(10^10,E7:H7)

 Just type =10^10 in a cell for knowing the evaluated result.

 On 12/17/12, amar takale amartak...@gmail.com wrote:
  Hi Dear,
 
  Solution is Perfect but waht is 10^10,I confused.I got Output but little
  confusing.
 
  Thank Very much
 
 
  On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner
  ms.exl.lear...@gmail.comwrote:
 
  =LOOKUP(10^10,E7:H7,E7:H7)
 
  --
  Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE  : Don't ever post confidential data in a workbook. Forum owners and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros+unsubscr...@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 
 


 --
 
 *Ms.Exl.Learner*
 

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread Ms-Exl-Learner


Not sure whether this...

For 2003 version of excel
=IF(ISNA(LOOKUP(10^10,E7:H7)),,LOOKUP(10^10,E7:H7))

For excel version which is higher than 2003
=IFERROR(LOOKUP(10^10,E7:H7),)



On 18-12-2012 10:16 AM, amar takale wrote:

Dear Parvin,
I want like
If same number all cell something cell also miss=one number which same
If single number=show single number

that it simple. I used Ms-Exl-Learner that perfect but if all cell 
same but last cell different number then show that numbers,I want that 
time show error then i will know something is problem.If there are no 
numbers in cell then cell show blank not NA.


Regards
Amar

On Mon, Dec 17, 2012 at 9:54 PM, Ms-Exl-Learner . 
ms.exl.lear...@gmail.com mailto:ms.exl.lear...@gmail.com wrote:


Even shorter than the previous one,
=LOOKUP(10^10,E7:H7)

Just type =10^10 in a cell for knowing the evaluated result.

On 12/17/12, amar takale amartak...@gmail.com
mailto:amartak...@gmail.com wrote:
 Hi Dear,

 Solution is Perfect but waht is 10^10,I confused.I got Output
but little
 confusing.

 Thank Very much


 On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner
 ms.exl.lear...@gmail.com mailto:ms.exl.lear...@gmail.comwrote:

 =LOOKUP(10^10,E7:H7,E7:H7)

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
Advice will
 not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum
owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the
Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to
excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros%2bunsubscr...@googlegroups.com.
 Visit this group at
http://groups.google.com/group/excel-macros?hl=en.





--

*Ms.Exl.Learner*


--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups MS EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros%2bunsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.



--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups MS EXCEL AND VBA MACROS group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros?hl=en.




--
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1)

$$Excel-Macros$$ Re: Consolidating Multiple files

Hi SG,

Please share your file with us.

Regards
Prince

On Friday, 14 December 2012 19:18:59 UTC+5:30, SG wrote:

 Hi Experts,
  
 I need your help in one of my problem.I want to consolidate the 
 multiple excel files of a folder with same name  numbered as 1,2,3 in to a 
 one excel file.I have tried but unable to create a macro on it.There is 
 only one criteria in this consolidation is that on column D of every sheet 
 is a date.What i want is to extract the data on basis of a particular week 
 number let's say we are in week 50  i want the data of week-49.Currently 
 i'm doing this manually.I apply the weeknum formula in column where data 
 gets end let's say that's column M  then extract the data.
  
 Please help me on this with a macro  thanks in advance.


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Merge entry cell

Hi Rajan

That Perfect one Solution

Thanks very much.

On Mon, Dec 17, 2012 at 4:43 PM, Prince prince141...@gmail.com wrote:

 Good one Rajan

 Regards
 Prince


 On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote:

 In K7

 =INDEX(E7:H7,,MATCH(MAX(**COUNTIF(E7:H7,E7:H7)),COUNTIF(**
 E7:H7,E7:H7),0))

 With CSE

 On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:

 Dear all
 Can Anybody tell me formula to merge cell entry in one column if it is
 duplicate then over right on it

 Regards
 Amar

  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Merge entry cell

Dear Ms-Exl-Learner,

As always,  Thank you very much for all the help

Regards
Amar

On Tue, Dec 18, 2012 at 10:42 AM, Ms-Exl-Learner
ms.exl.lear...@gmail.comwrote:

  Not sure whether this...

 For 2003 version of excel
 =IF(ISNA(LOOKUP(10^10,E7:H7)),,LOOKUP(10^10,E7:H7))

 For excel version which is higher than 2003
 =IFERROR(LOOKUP(10^10,E7:H7),)




 On 18-12-2012 10:16 AM, amar takale wrote:

 Dear Parvin,
 I want like
 If same number all cell something cell also miss=one number which same
 If single number=show single number

 that it simple. I used Ms-Exl-Learner that perfect but if all cell same
 but last cell different number then show that numbers,I want that time show
 error then i will know something is problem.If there are no numbers in cell
 then cell show blank not NA.

 Regards
 Amar

 On Mon, Dec 17, 2012 at 9:54 PM, Ms-Exl-Learner . 
 ms.exl.lear...@gmail.com wrote:

 Even shorter than the previous one,
 =LOOKUP(10^10,E7:H7)

 Just type =10^10 in a cell for knowing the evaluated result.

 On 12/17/12, amar takale amartak...@gmail.com wrote:
  Hi Dear,
 
  Solution is Perfect but waht is 10^10,I confused.I got Output but little
  confusing.
 
  Thank Very much
 
 
  On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner
  ms.exl.lear...@gmail.comwrote:
 
  =LOOKUP(10^10,E7:H7,E7:H7)
 
   --
  Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE  : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros+unsubscr...@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 
 
 


 --
 
  *Ms.Exl.Learner*
  

 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



 --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security

$$Excel-Macros$$ Re: How to develop Addins