$$Excel-Macros$$ Re: Query Question with Excel Stock File

[Mike C.]

*I forget to attach the file which I'm doing now.*
On Saturday, February 15, 2020 at 3:04:56 PM UTC-5, Mike C. wrote:
>
> I am working on creating an Excel file that will pull data from 
> barcharts.com for stocks listed in this Excel file and what I'm trying to 
> have it do is automatically show if it's a "sell", "strong sell", "buy", 
> "strong buy", "weak buy", etc. and then either say that like it already 
> does in column E on the second tab / sheet titled 
> "Portfolio_Position_Dec-01-2019-".  I can get data pulled from the website 
> and put on the first sheet but that is far rudimentary for what I'm trying 
> to end up with.  Can somebody tell me how I can tweak this Excel file to at 
> least get closer to what I'm trying to do?
>
> I have attached the Excel file.
>
> Thanks in advanced for any helpful response.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/44d8a8a6-d103-4ec6-b549-2e6c944403da%40googlegroups.com.


HYPOTHETICAL-TRADING2.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Query !!!

[सचिन शर्मा]

Thank You so Much, It's Working Perfect :) 


On Tuesday, August 16, 2016 at 2:10:13 PM UTC+5:30, सचिन शर्मा wrote:
>
> Dear All,
>
>
> Please help to resolve below query.
>
>
> Share the function to get the same result which in yellow cells
>
> ** without any supporting columns.
>
>
>
> 
>
>
> *Thanks and Regards*
> *Sachin Sharma.*
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query

[Rohit Jadhav]

Hi Soumyendu Paul
I'm not exactly sure what you want. So here's my understanding
If user makes any changes in the file he/she has to click the Send mail 
button before closing the file and you have code for sending the mail  
A simple way is to use activex control button instead of the shape you have 
used.

I have included both shape based  activex based code in the file. choose 
what you want. Hope this is useful 

On Tuesday, June 30, 2015 at 7:02:44 AM UTC+5:30, Soumyendu Paul wrote:

 In attachment; sheet1 we are sending a mail on clicking a shape. My query 
 is to give an alert(like popup message box) when shape is not cliked


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Copy of Test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Query to retreive data

[Vaibhav Joshi]

you dont need access, you can continue using excel  thru DAO you can
retrieve data from closed workbook too..

On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh nasirsa...@gmail.com wrote:

 r8 Pramod access is very easy and taking very less time than excel on huge
 data you can use it till 2 GB data.

 On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote:

 My mmaster file is large and i just want to do lookup on my sheet from
 master file without opening my master file as it is of huge mb around 250
 mb or more than that. any ideas

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Query to retreive data

[Pramod Singh]

Why not you are using MS Access. It's pretty cool and can we use easy..
this is best for if some one have to work in large data

Pramod
On 28 Apr 2015 15:41, Mandeep Baluja rockerna...@gmail.com wrote:

 Yes it works, Thanks for the same we can considered this issue is
 resolved. But one thing Excel is not useful for large files On Daily basis
  I got files of 350 mb having data of 2-3 lakh rows and I am unable to
 combine the same jjust because excel not responds.


 On Tuesday, April 28, 2015 at 3:10:42 PM UTC+5:30, Nasir Saikh wrote:

 Hi Mandeep

 As per my suggestion you can use table link vloopup as I am using and it
 is working fine. Example is given below.

 Sub LoopUp()
 Dim iRow As Integer
 Dim MaxRow As Long
 MaxRow = ActiveSheet.Range(A  Rows.Count).End(xlUp).Row
 Range(B2).FormulaR1C1 =
 =VLOOKUP(RC[-1],'C:\Users\n0258542\Documents\[Aakash -
 Copy.xlsx]Input_Consolidated'!R1C2:R44C5,4,0)
 For iRow = 3 To MaxRow
 Selection.Offset(1, 0).Select
 Selection.FillDown
 Next
 End Sub



  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query to retreive data

[Nasir Saikh]

r8 Pramod access is very easy and taking very less time than excel on huge 
data you can use it till 2 GB data.

On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote:

 My mmaster file is large and i just want to do lookup on my sheet from 
 master file without opening my master file as it is of huge mb around 250 
 mb or more than that. any ideas


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query to retreive data

[Mandeep Baluja]

Yes it works, Thanks for the same we can considered this issue is resolved. 
But one thing Excel is not useful for large files On Daily basis  I got 
files of 350 mb having data of 2-3 lakh rows and I am unable to combine the 
same jjust because excel not responds. 


On Tuesday, April 28, 2015 at 3:10:42 PM UTC+5:30, Nasir Saikh wrote:

 Hi Mandeep
  
 As per my suggestion you can use table link vloopup as I am using and it 
 is working fine. Example is given below.
  
 Sub LoopUp()
 Dim iRow As Integer
 Dim MaxRow As Long
 MaxRow = ActiveSheet.Range(A  Rows.Count).End(xlUp).Row
 Range(B2).FormulaR1C1 = 
 =VLOOKUP(RC[-1],'C:\Users\n0258542\Documents\[Aakash - 
 Copy.xlsx]Input_Consolidated'!R1C2:R44C5,4,0)
 For iRow = 3 To MaxRow
 Selection.Offset(1, 0).Select
 Selection.FillDown
 Next
 End Sub
  
  


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query to retreive data

[Nasir Saikh]

Hi Mandeep
 
As per my suggestion you can use table link vloopup as I am using and it is 
working fine. Example is given below.
 
Sub LoopUp()
Dim iRow As Integer
Dim MaxRow As Long
MaxRow = ActiveSheet.Range(A  Rows.Count).End(xlUp).Row
Range(B2).FormulaR1C1 = 
=VLOOKUP(RC[-1],'C:\Users\n0258542\Documents\[Aakash - 
Copy.xlsx]Input_Consolidated'!R1C2:R44C5,4,0)
For iRow = 3 To MaxRow
Selection.Offset(1, 0).Select
Selection.FillDown
Next
End Sub
 
 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

[saravanan R]

On Wed, Mar 18, 2015 at 5:31 PM, saravanan R sarva0...@gmail.com wrote:

 Hi Mandeep,

 Thanks a Million.

 I have one more query related to the same file, is it possible to split
 the file based on Status OK wrt to each Coleague.
 and file name should be QueryDup-FK  QueryDup-BD (colleague name will be
 dyanmic)

 thanks in advance.


 On Wed, Mar 18, 2015 at 5:25 PM, Mandeep baluja mandeepbal...@gmail.com
 wrote:

 Try this ..


 Regards,
 MandeepBaluja
 Learningzmypassion.
 https://www.facebook.com/VBAEXCELSQL?ref=hl
 https://www.linkedin.com/profile/view?id=312532939

 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:

 Hello Team,

 I have an Query regarding Duplicate check for certain Criteria in
 filter. I need this  to be in VBA Code . Please see the details below and
 find the sample attached file with expected result mentioned.

 I have to filter for FK (Column B), Then find duplicate DOC.no for
 this colleague only. If the DOC no. is Duplicating then Update Status as
 OK, if it is Unique then update as NOT OK

 thanks in advance,

 Saravanan R
 +91 8807708842
 +91 9449716334

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

[saravanan R]

Hi Mandeep,

Thanks a Million.

I have one more query related to the same file, is it possible to split the
file based on Status OK wrt to each Coleague.
and file name should be QueryDup-FK  QueryDup-BD (colleague name will be
dyanmic)

thanks in advance.


On Wed, Mar 18, 2015 at 5:25 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:

 Try this ..


 Regards,
 MandeepBaluja
 Learningzmypassion.
 https://www.facebook.com/VBAEXCELSQL?ref=hl
 https://www.linkedin.com/profile/view?id=312532939

 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:

 Hello Team,

 I have an Query regarding Duplicate check for certain Criteria in filter.
 I need this  to be in VBA Code . Please see the details below and find the
 sample attached file with expected result mentioned.

 I have to filter for FK (Column B), Then find duplicate DOC.no for this
 colleague only. If the DOC no. is Duplicating then Update Status as OK,
 if it is Unique then update as NOT OK

 thanks in advance,

 Saravanan R
 +91 8807708842
 +91 9449716334

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

[Mandeep baluja]

Try this ..


Regards, 
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939

On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:

 Hello Team,

 I have an Query regarding Duplicate check for certain Criteria in filter. 
 I need this  to be in VBA Code . Please see the details below and find the 
 sample attached file with expected result mentioned.

 I have to filter for FK (Column B), Then find duplicate DOC.no for this 
 colleague only. If the DOC no. is Duplicating then Update Status as OK, 
 if it is Unique then update as NOT OK

 thanks in advance,

 Saravanan R
 +91 8807708842
 +91 9449716334


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


QueryDup.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

[Ashish Bhalara]

Thanks Mr.Michael, it's work.

Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*


On Sun, Mar 1, 2015 at 11:08 PM, michael vinoth michaelvino...@gmail.com
wrote:

 Hi Ashish,

 Please find the attached macro file.

 Regards,
 MV

 On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara
 wrote:

 Dear expert,

 I need help in attached file in which if cheque amount is greater than
 zero and date  cheque number field Blank then msgbox should display, and
 when cheque amount is blank, no any msgbox should display.

 In my case and as per my formula the msgbox display even cheque amt.
 field is zero.

 Kindly see attached file to solve my query, I tried different way in
 codding but did't get result.

 Regards.
 Ashish Bhalara
 9624111822
 P*Please do not print this email unless it is absolutely necessary.
 Spread environmental üawareness.♣♣♣*

   --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

[michael vinoth]

Hi Ashish,

Please find the attached macro file.

Regards,
MV

On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara wrote:

 Dear expert,

 I need help in attached file in which if cheque amount is greater than 
 zero and date  cheque number field Blank then msgbox should display, and 
 when cheque amount is blank, no any msgbox should display.

 In my case and as per my formula the msgbox display even cheque amt. field 
 is zero.

 Kindly see attached file to solve my query, I tried different way in 
 codding but did't get result.

 Regards.
 Ashish Bhalara
 9624111822
 P*Please do not print this email unless it is absolutely necessary. 
 Spread environmental üawareness.♣♣♣*

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Query VBA If formula.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: Query on count

[Kal xcel]

Thank you all. It's really helped me a lot.

Thanks in once again

On Thu, Nov 13, 2014 at 6:24 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Hey Kalyan,

 check this array formula and the
 sheet. 
 =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0))

 Regards,
 Mandeep Baluja

 On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:

 Dear Experts,

 Please help me to solve my query.

 Thanks in advance

 --
 *Kalyan Chattopadhyay*


 *Executive Corporate MIS*

 *Joy Cosmetics*

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
*Kalyan Chattopadhyay*


*Executive Corporate MIS*

*Joy Cosmetics*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Query on count

[sanjaiy yadav]

Hi,

PFA Solution,

Regards
Sanjai Kumar

On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:

 Dear Experts,

 Please help me to solve my query.

 Thanks in advance

 -- 
 *Kalyan Chattopadhyay*
  

 *Executive Corporate MIS*

 *Joy Cosmetics*
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Count Query.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Query on count

[Mandeep Baluja]

Hey Kalyan, 

check this formula and the sheet 
. =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0))
Ctrl+shift+Enter

Regards 
Mandeep Baluja 

On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:

 Dear Experts,

 Please help me to solve my query.

 Thanks in advance

 -- 
 *Kalyan Chattopadhyay*
  

 *Executive Corporate MIS*

 *Joy Cosmetics*
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Count Query.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Query on count

[Mandeep Baluja]

Hey Kalyan, 

check this array formula and the 
sheet. 
=COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0))

Regards,
Mandeep Baluja

On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:

 Dear Experts,

 Please help me to solve my query.

 Thanks in advance

 -- 
 *Kalyan Chattopadhyay*
  

 *Executive Corporate MIS*

 *Joy Cosmetics*
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Count Query.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Query on Text to Columns function

[PoojaSharma]

Thanks Lalit for the solution, though the solution to my query is quite 
simpler..while using text to column on the very next step choose text for 
each column within text to column window.  
Regards  Pooja Sharma
Sent from my iPad

On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey mohan.pande...@gmail.com 
wrote:

 Try this
 
 Option Explicit
 
 Sub SplitValues()
 
 Dim lngLoop As Long
 Dim vararrRawData() As Variant
 Dim vararrSplitData As Variant
 
 'Const variable change accordingly as per your requirement
 Const strDataRangeToSplit   As String = C1:C65536
 Const strDataShtNameAs String = Sheet1
 Const strDataOutputShtName  As String = Sheet1
 Const strDataOutputCell As String = J1
 
 With ThisWorkbook
 With .Worksheets(strDataShtName)
 vararrRawData = .Range(strDataRangeToSplit).Value
 End With
 With .Worksheets(strDataOutputShtName)
 For lngLoop = LBound(vararrRawData) To UBound(vararrRawData)
 .Range(strDataOutputCell).Offset(lngLoop - 1, 0).Value = 
 vararrRawData(lngLoop, 1)
 vararrSplitData = Split(Replace(vararrRawData(lngLoop, 1), 
 ., .'), .)
 If UBound(vararrSplitData) = 0 Then
 vararrSplitData(0) = vbNullString
 End If
 .Range(strDataOutputCell).Offset(lngLoop - 1, 1).Resize(, 
 UBound(vararrSplitData) + 1).Value = vararrSplitData
 Next lngLoop
 End With
 End With
 
 lngLoop = Empty
 Erase vararrRawData
 vararrSplitData = Empty
 
 End Sub
 
 
 On Thursday, 29 August 2013 13:32:17 UTC+5:30, Pooja wrote:
 
 Hi All,
 
 Please advice on the below query.
 
 Regards
 Pooja Sharma
 Sent from BlackBerry® on Airtel
 From: Pooja Sharma pooja@dc.ibm.com
 Date: Thu, 29 Aug 2013 13:19:08 +0530
 To: vatspo...@gmail.com
 Subject: Query on Text to Columns function
 
 Hi All, 
 
 I am seeking for your support on one of my file (attached), wherein I have 
 to separate the values in different columns, the separator (Delimitor) value 
 is the . sign. 
 
 I was trying to do this with the function text to columns, but it removes 
 the zero value and I need these 0 values too. 
 
 Please advice.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Query on Text to Columns function

[De Premor]

Try this code

Sub Macro1()
Dim Data As Range
Application.DisplayAlerts = False
Set Data = Range(C2, Range(C2).End(xlDown).Address)
Data.TextToColumns Data.Offset(, 1), OtherChar:=., 
FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 2))

Application.DisplayAlerts = True
End Sub



On 01-09-2013 1:45, PoojaSharma wrote:
Thanks Lalit for the solution, though the solution to my query is 
quite simpler..while using text to column on the very next step 
choose text for each column within text to column window.

Regards  Pooja Sharma
Sent from my iPad

On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey 
mohan.pande...@gmail.com mailto:mohan.pande...@gmail.com wrote:



Try this

Option Explicit

Sub SplitValues()

Dim lngLoop   As Long
Dim vararrRawData() As Variant
Dim vararrSplitData As Variant
'Const variable change accordingly as per your requirement
Const strDataRangeToSplit   As String = C1:C65536
Const strDataShtNameAs String = Sheet1
Const strDataOutputShtName  As String = Sheet1
Const strDataOutputCell As String = J1
With ThisWorkbook
With .Worksheets(strDataShtName)
vararrRawData = .Range(strDataRangeToSplit).Value
End With
With .Worksheets(strDataOutputShtName)
For lngLoop = LBound(vararrRawData) To UBound(vararrRawData)
.Range(strDataOutputCell).Offset(lngLoop - 1, 0).Value = 
vararrRawData(lngLoop, 1)
vararrSplitData = Split(Replace(vararrRawData(lngLoop, 1), ., 
.'), .)

If UBound(vararrSplitData) = 0 Then
vararrSplitData(0) = vbNullString
End If
.Range(strDataOutputCell).Offset(lngLoop - 1, 1).Resize(, 
UBound(vararrSplitData) + 1).Value = vararrSplitData

Next lngLoop
End With
End With
lngLoop = Empty
Erase vararrRawData
vararrSplitData = Empty

End Sub


On Thursday, 29 August 2013 13:32:17 UTC+5:30, Pooja wrote:

Hi All,

Please advice on the below query.

Regards
Pooja Sharma
Sent from BlackBerry® on Airtel

*From: * Pooja Sharma pooja@dc.ibm.com javascript:
*Date: *Thu, 29 Aug 2013 13:19:08 +0530
*To: *vatspo...@gmail.com javascript:
*Subject: *Query on Text to Columns function

Hi All,

I am seeking for your support on one of my file (attached),
wherein I have to separate the values in different columns, the
separator (Delimitor) value is the . sign.

I was trying to do this with the function text to columns, but it
removes the zero value and I need these 0 values too.

Please advice.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, 

$$Excel-Macros$$ Re: Query in For Each Next

[Prince]

No , It Is not refering each cell in the * Range(A1:D5) *.For getting 
each cell you have to change the code like

*Sub Upper_()*

*For Each x In Range(A1:D5).cells*
*x.Value = UCase(x.Value)*
*Next*
*
*
*Regards*
*Prince*



On Wednesday, 3 July 2013 10:41:21 UTC+5:30, Prafull Jadhav wrote:

 Dear All,

 Good Morning..


 I got below macro from net ..Can you explain me what x stand here...



 *Sub Upper_()*

 *For Each x In Range(A1:D5)*
 *'For Each x In Range(A1:D5)*
 *
 *
 *x.Value = UCase(x.Value)*
 *'x.Value = UCase(x.Value)*
 *
 *
 *Next*
 *
 *
 *Thanks in Advance.*
 *Regards,*
 *Prafull Jadhav.*
 *
 *


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Query

[Vabz]

Hi

You getting error because you are multiplying array with not value of Cell 
C2 but just text C2.


Rgds//Vabs

On Friday, September 28, 2012 5:54:58 PM UTC+5:30, Aamir Shahzad wrote:

 Dear Group,
  
 When I mannualy enter the C7 into the following formula, it has no 
 problem, 
  
 =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
  
 but when I am trying to generate C7, it's given me #value error, however 
 address function is creating the C7 ok seperaterly. 
  

 =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2
  
 Sample file is also attached, Please suggest. 
 Regards,
  
 Aamir Shahzad



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

$$Excel-Macros$$ Re: Query

[Don Guillett]

I LOOKED at the provided file and gave proper 
answers
including the homework question about sumproduct.

On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:

 Dear Group,
  
 When I mannualy enter the C7 into the following formula, it has no 
 problem, 
  
 =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
  
 but when I am trying to generate C7, it's given me #value error, however 
 address function is creating the C7 ok seperaterly. 
  

 =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2
  
 Sample file is also attached, Please suggest. 
 Regards,
  
 Aamir Shahzad



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

$$Excel-Macros$$ Re: Query

[Don Guillett]

what is wrong with what I posted much earlier
INDEX(C:C,MATCH($H12,$H:$H))
instead of this
 =INDEX(C2,MATCH($H12,$H$2:$H$9,0))

if you insist on sumproduct, this will do just fine.
=SUMPRODUCT(($H$2:$H$9=$H12)*C$2:C$9)

On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:

 Dear Group,
  
 When I mannualy enter the C7 into the following formula, it has no 
 problem, 
  
 =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
  
 but when I am trying to generate C7, it's given me #value error, however 
 address function is creating the C7 ok seperaterly. 
  

 =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2
  
 Sample file is also attached, Please suggest. 
 Regards,
  
 Aamir Shahzad



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

Re: $$Excel-Macros$$ Re: Query

[Aamir Shahzad]

yes you are right but I am not understanding why formula generating error,
I want to know the reason? can you investigate.

Aamir Shahzad

On Fri, Sep 28, 2012 at 5:41 PM, Don Guillett dguille...@gmail.com wrote:



 On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:

 Dear Group,

 When I mannualy enter the C7 into the following formula, it has no
 problem,

 =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))

 but when I am trying to generate C7, it's given me #value error, however
 address function is creating the C7 ok seperaterly.


 =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2

 Sample file is also attached, Please suggest.
 Regards,

 Aamir Shahzad
 First, use a MEANINGFUL subject line like  sumproduct question


 Methinks you are making it much harder than necessary. Copy this down and
 across
  '=INDEX(C:C,MATCH($H12,$H:$H))




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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or 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.






-- 

Regards,
Aamir Shahzad

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

$$Excel-Macros$$ Re: Query

[Don Guillett]

Why bother when I gave you the PROPER formula.


On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:

 Dear Group,
  
 When I mannualy enter the C7 into the following formula, it has no 
 problem, 
  
 =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
  
 but when I am trying to generate C7, it's given me #value error, however 
 address function is creating the C7 ok seperaterly. 
  

 =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2
  
 Sample file is also attached, Please suggest. 
 Regards,
  
 Aamir Shahzad



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

$$Excel-Macros$$ Re: Query - Circle Invalid...

[Prince Dubey]

Means ??

regards
prince 

On Thursday, September 13, 2012 7:40:41 PM UTC+5:30, Hemant wrote:

 Hi Group,


 I want to know how Circle Invalid function works in excel and vba. 


 Regards,
 Hemant.



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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.

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

[Excel Vba]

Hi Group,

Is it good practise to declare a global variable.
But, when i use global variable in loop it performs better.

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

-
On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote:

 Hi Group,


 How can i declare a global variable for below mentioned.



 Private sub abc()
 dim sh as worksheet
 dim rng as range

 set sh = Thisworkbook.Sheets(Sheet1)
 set rng = sh.range(a1:csh.range(crows.count).end(xlup).row)

 End sub


 In my module i have 20 procedure and in future comes many more.
 So, my query how to declare a global variable and how to call in my
 procedure.

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



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

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

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

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

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

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

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

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

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

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

[noorain . ansari]

Dear Hemant,

Pls declear variable as Public and it will declear out of pocedure

Like
Public abc as string
Sub A()
Abc=ram
Msg abc
End sub

Sub B()
Abc=rahim
Msg abc
End sub
Sent from BlackBerry® on Airtel

-Original Message-
From: Excel Vba excelvba.lear...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 13 Jul 2012 18:24:57 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Query- Global Variable

Hi Group,

Is it good practise to declare a global variable.
But, when i use global variable in loop it performs better.

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

-
On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote:

 Hi Group,


 How can i declare a global variable for below mentioned.



 Private sub abc()
 dim sh as worksheet
 dim rng as range

 set sh = Thisworkbook.Sheets(Sheet1)
 set rng = sh.range(a1:csh.range(crows.count).end(xlup).row)

 End sub


 In my module i have 20 procedure and in future comes many more.
 So, my query how to declare a global variable and how to call in my
 procedure.

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



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: Query

[Shashi Ranjan]

Dear Venkat  Noorain Sir

I am very thankful to you for sharing your precipus time helping me solve
this task.

Thanks  Regards
Shashi Ranjan



On 1 September 2011 15:09, NOORAIN ANSARI noorain.ans...@gmail.com wrote:

 Dear Shashi,

 Please see attached sheet if it help to u...

 On Thu, Sep 1, 2011 at 2:22 PM, shashi shashi2...@gmail.com wrote:

 Dear Venkat

 I have second condtion that i want payout amount datewise. I want an
 urgent help on condition function. In this data i have the requirement
 of *Payout amount* for each branch in datewise without using

 On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote:
  Dear Excel Guru's
 
  I want an urgent help on condition function. In this data i have the
  requirement of *Payout amount* for each branch in datewise without using
  pivot. Please help me in this query.
 
  Thanks
  Regards
  Shashi Ranjan
 
   Consolidation RI payout Data.xls
  1512KViewDownload

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Thanks  regards,
 Noorain Ansari
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Query

[Venkat CV]

Dear Shasi,

You are Welcome...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*

On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan shashi2...@gmail.com wrote:

 Dear Venkat  Noorain Sir

 I am very thankful to you for sharing your precipus time helping me solve
 this task.

 Thanks  Regards
 Shashi Ranjan



 On 1 September 2011 15:09, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Shashi,

 Please see attached sheet if it help to u...

 On Thu, Sep 1, 2011 at 2:22 PM, shashi shashi2...@gmail.com wrote:

 Dear Venkat

 I have second condtion that i want payout amount datewise. I want an
 urgent help on condition function. In this data i have the requirement
 of *Payout amount* for each branch in datewise without using

 On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote:
  Dear Excel Guru's
 
  I want an urgent help on condition function. In this data i have the
  requirement of *Payout amount* for each branch in datewise without
 using
  pivot. Please help me in this query.
 
  Thanks
  Regards
  Shashi Ranjan
 
   Consolidation RI payout Data.xls
  1512KViewDownload

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Thanks  regards,
 Noorain Ansari
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Query

[shashi]

Dear Venkat

I have second condtion that i want payout amount datewise. I want an
urgent help on condition function. In this data i have the requirement
of *Payout amount* for each branch in datewise without using

On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote:
 Dear Excel Guru's

 I want an urgent help on condition function. In this data i have the
 requirement of *Payout amount* for each branch in datewise without using
 pivot. Please help me in this query.

 Thanks
 Regards
 Shashi Ranjan

  Consolidation RI payout Data.xls
 1512KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Query

[ankur]

*
*Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Wed, Jul 6, 2011 at 6:05 PM, ankur ankurpande...@gmail.com wrote:

 *hi ashish sir
 may this help u ...
 *Have A Nice Time  Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~



 On Wed, Jul 6, 2011 at 5:30 PM, ashish koul koul.ash...@gmail.com wrote:



 On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com wrote:

 Dear Experts,

 For this chart

 3001-5000 = 30
 5001-6000 = 40
 6001-7000 = 45
 7001-8000 = 50
 8001-9000 = 50
 9001-15000 = 110
 15001-25000 = 130
 25001-4 = 150
 40001= =200

 I use this formula:



 =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0)

 Is their any other short/intelligent way to get desired result?

 Please help

 Thanks in advance

 Kalyan




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
  *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Query

[Kal xcel]

Thanks Ashish

Thanks Ankur

On Thu, Jul 7, 2011 at 11:51 AM, ankur ankurpande...@gmail.com wrote:

 *
 *Have A Nice Time  Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~


   On Wed, Jul 6, 2011 at 6:05 PM, ankur ankurpande...@gmail.com wrote:

 *hi ashish sir
 may this help u ...
 *Have A Nice Time  Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~



 On Wed, Jul 6, 2011 at 5:30 PM, ashish koul koul.ash...@gmail.comwrote:



 On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com wrote:

 Dear Experts,

 For this chart

 3001-5000 = 30
 5001-6000 = 40
 6001-7000 = 45
 7001-8000 = 50
 8001-9000 = 50
 9001-15000 = 110
 15001-25000 = 130
 25001-4 = 150
 40001= =200

 I use this formula:



 =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0)

 Is their any other short/intelligent way to get desired result?

 Please help

 Thanks in advance

 Kalyan




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel



 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Query

[ashish koul]

On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com wrote:

 Dear Experts,

 For this chart

 3001-5000 = 30
 5001-6000 = 40
 6001-7000 = 45
 7001-8000 = 50
 8001-9000 = 50
 9001-15000 = 110
 15001-25000 = 130
 25001-4 = 150
 40001= =200

 I use this formula:



 =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0)

 Is their any other short/intelligent way to get desired result?

 Please help

 Thanks in advance

 Kalyan




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Re: Query

[ankur]

*hi ashish sir
may this help u ...
*Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Wed, Jul 6, 2011 at 5:30 PM, ashish koul koul.ash...@gmail.com wrote:



 On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com wrote:

 Dear Experts,

 For this chart

 3001-5000 = 30
 5001-6000 = 40
 6001-7000 = 45
 7001-8000 = 50
 8001-9000 = 50
 9001-15000 = 110
 15001-25000 = 130
 25001-4 = 150
 40001= =200

 I use this formula:



 =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0)

 Is their any other short/intelligent way to get desired result?

 Please help

 Thanks in advance

 Kalyan




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
  *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Re: query for a solution

[ankur]

hi
Prakash Singh Gusain and others experts

thanks for your supportu all provide very helpful solution.
thnks again
Have A Nice Time  Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Thu, Feb 10, 2011 at 3:53 PM, Prakash Gusain gusainprak...@gmail.com wrote:
 Hi Ankur,

 Please find the attached file for solution, I know you have already got the
 solution from other experts.  The only different thing you will find is
 there NO NEED TO SORT DATA AS WELL! no matter were your unique id is in the
 column it will give you the solution.

 The solution provided by Expert Umesh lacks this feature!

 Hope it made some contribution to learn something new as well :)
 --
 Best Regards!
 Prakash Singh Gusain

 Please visit my blog (click here)

 --
 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Query Excel File

[Ayush]

Dear Upendra,

Well, if your code is working fine to query excel fileYou can use 
Select distinct * from [RECEIVE$]  to pull distinct data from the column.

Not sure if it will help you. Write back in case you need something else.

Best Regards,
Ayush Jain
Microsoft MVP

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Re: Query Excel File

[Upendra Singh Sengar]

Hi Ayush,

This doesn't help. I've got the correct code:
Select Distinct [Market] from [Sheet1$A1:D5000]
or
SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];,



(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325


On 23 December 2010 21:37, Ayush jainayus...@gmail.com wrote:

 Dear Upendra,

 Well, if your code is working fine to query excel fileYou can use
 Select distinct * from [RECEIVE$]  to pull distinct data from the column.

 Not sure if it will help you. Write back in case you need something else.

 Best Regards,
 Ayush Jain
 Microsoft MVP

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

$$Excel-Macros$$ Re: Query - Date Formula

[saggi]

Dear Nikhil,

Use Data Validation  for reflect the error

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Query - Date Formula

[Nikhil Shah]

Dear Friend

Thanks For Help.I have Found Data Validation Function.

My Excel Sheet is now working find..

against Thanks

Regards
Nikhil Shah

On Sat, Jul 10, 2010 at 4:51 PM, saggi realsa...@gmail.com wrote:


 Dear Nikhil,

 Use Data Validation  for reflect the error

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

[big smile]

Hellow Sir / Friends, -  Dilip Pandeyji


Thanks for giving the answer to my query.   advice for keep smiling,

I will be grateful to you if i get the answer to this query by keeping excel
2007 version

as there are lot of difference to excel 2003 version. [ if possible ]

1] in Excel 2007-  in Formula - name manager  - we can change / edit the
name

2] i have tried the option to hide single sheet in worksheet - open only
with password

but that does not work -- i think i have some problem to understand - please
elaborate this

answer for excel 2007 version.


3] i am new to macro -- if possible can you just write the macro -- that
whenever i open the

workbook - that particular macro automatically run.

-- i does not understand where to get the code --- you can use
workbook_open event to write that macro with a Call option or reference
option.

4]  5] i understood

Thanks once again.








On Mon, Oct 19, 2009 at 7:43 PM, Dilip Pandey dilipan...@gmail.com wrote:

 Hi BigSmile - Keep Smiling:-
 Below are the answers to your queries (using Excel 2003):-

 1) Yes, you can delete that name.  Go to Insert -Name- select the name
 and press delete.  Change of name is not allowed, but Yes you can make a
 copy of that name and rename that as per your choice

 2) Yes, You can password to workbook by choosing path:- Tools - Protection
 - Protect Workbook.  If you protect the workbook, then no one can unhide
 that sheet, if password is not know to him/her.

 3) Yes, you can use workbook_open event to write that macro with a Call
 option or reference option.

 4) After running the macro, you should close the Excel and say no to save
 option provided If you have not written Save syntax in the code.

 5) Re-naming option for custom view is not there, alternatively you should
 try and record/ develop a macro to do this lengthy task for you.

 Best Regards,
 --
 DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062


 On 10/17/09, big smile bigsmile...@gmail.com wrote:

 Hellow all excel guru's   friends.

 I have some query -- or i want to know the shortcuts.

 1]  Can we delete the name given to particular cell in name box - if
 we type F5 - the name box appear

 I would like to know how to change the name and  delete  the name given to
 some reference.

 2] There are 3 sheets in one file -- i have hide one sheet -- i want to
 know can we give the password for opening

 of such hide sheet ? -- if yes how

 3] I have created one macro no. 7 -- in a particular file - i want to know
 can we define one another macro so that

 whenever i open that file -- macro no. 7 automatically run -- give me the
 result created in macro 7.

 4] whenever we run a particular macro -- we can not go back by ctrl + Z [
 undo ] -- or we can not restore the old things which were there before

 macro run -- is there any solution to such thing.

 5] I  have created certain custom view in file --- is there any shortcuts
 to change the name of that custom view ---

 at present i am using the technique to select the particular custom view
 -- then delete the same  then giving another name

 this is perhaps the long procedure.-- is there any shortcuts of changing
 the custom view name





 Thanks  have a nice time







 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query no.3 - SUMMARISED DATA SUBTOTAL ON ANOTHER SHEET.

[big smile]

Hellow friends

I am awaiting your reply for this my query.


Thanks















On Fri, Oct 16, 2009 at 3:36 PM, big smile bigsmile...@gmail.com wrote:

 HAPPY  DIWALI  NEW YEAR TO ALL OUR EXCEL GURU’S  FRIENDS





 Attached please find the Excel –tips –Query No.3 File



 In Sheet 1 – All the details given

 In sheet 2 – Types of  Reports required

 In sheet 3 – Other type of Summery reports required



 Thanks in advance for using the mastermind to solve my problem.



 Even I would like to know can we have window who give the reference the
 which column at present are filtered – if there are more than 3 – or 4 are
 filtered simultaneously.

 As I have large column I have to go to right side to see which columns are
 filtered.

 In Sheet 3- I want to summaries my full one raw for ex.

 20 –in one single page – so that I get the full summery of my single
 client.



 In this file as I change the my client name I get the full details of him/
 her. I do not require full details – I require some details or if possible I
 can change the place of details.

 Thanks   have a nice time.

 Jayshree Shah

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

[Dilip Pandey]

Hi,

Regarding point no. 2:-  Try hiding one sheet among three available sheets
and after that protect Workbook not worksheet.
As I have Excel 2003, I am not into the position to explain further in
relation to Excel 2007.

Best Regards,
-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Tue, Oct 20, 2009 at 10:36 AM, big smile bigsmile...@gmail.com wrote:

 Hellow Sir / Friends, -  Dilip Pandeyji


 Thanks for giving the answer to my query.   advice for keep smiling,

 I will be grateful to you if i get the answer to this query by keeping
 excel 2007 version

 as there are lot of difference to excel 2003 version. [ if possible ]

 1] in Excel 2007-  in Formula - name manager  - we can change / edit the
 name

 2] i have tried the option to hide single sheet in worksheet - open only
 with password

 but that does not work -- i think i have some problem to understand -
 please elaborate this

 answer for excel 2007 version.


 3] i am new to macro -- if possible can you just write the macro -- that
 whenever i open the

 workbook - that particular macro automatically run.

 -- i does not understand where to get the code --- you can use
 workbook_open event to write that macro with a Call option or reference
 option.

 4]  5] i understood

 Thanks once again.









 On Mon, Oct 19, 2009 at 7:43 PM, Dilip Pandey dilipan...@gmail.comwrote:

 Hi BigSmile - Keep Smiling:-
 Below are the answers to your queries (using Excel 2003):-

 1) Yes, you can delete that name.  Go to Insert -Name- select the name
 and press delete.  Change of name is not allowed, but Yes you can make a
 copy of that name and rename that as per your choice

 2) Yes, You can password to workbook by choosing path:- Tools -
 Protection - Protect Workbook.  If you protect the workbook, then no one
 can unhide that sheet, if password is not know to him/her.

 3) Yes, you can use workbook_open event to write that macro with a
 Call option or reference option.

 4) After running the macro, you should close the Excel and say no to save
 option provided If you have not written Save syntax in the code.

 5) Re-naming option for custom view is not there, alternatively you should
 try and record/ develop a macro to do this lengthy task for you.

 Best Regards,
 --
 DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062


   On 10/17/09, big smile bigsmile...@gmail.com wrote:

 Hellow all excel guru's   friends.

 I have some query -- or i want to know the shortcuts.

 1]  Can we delete the name given to particular cell in name box - if
 we type F5 - the name box appear

 I would like to know how to change the name and  delete  the name given
 to some reference.

 2] There are 3 sheets in one file -- i have hide one sheet -- i want to
 know can we give the password for opening

 of such hide sheet ? -- if yes how

 3] I have created one macro no. 7 -- in a particular file - i want to
 know can we define one another macro so that

 whenever i open that file -- macro no. 7 automatically run -- give me the
 result created in macro 7.

 4] whenever we run a particular macro -- we can not go back by ctrl + Z [
 undo ] -- or we can not restore the old things which were there before

 macro run -- is there any solution to such thing.

 5] I  have created certain custom view in file --- is there any shortcuts
 to change the name of that custom view ---

 at present i am using the technique to select the particular custom view
 -- then delete the same  then giving another name

 this is perhaps the long procedure.-- is there any shortcuts of changing
 the custom view name





 Thanks  have a nice time







 



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query!!!!

[Himadri Roy]

Hi Upendra,

Thanks for your reply but each client is adding customers every month, in
that case i think it wont work, plz help me



On Tue, Oct 20, 2009 at 5:11 PM, Upendra Singh upendrasinghsen...@gmail.com
 wrote:

  Hi Himadri,





 You should multiply new client with customer per client.





 Thanks and Regards,



 Upendra Singh

 +91-9910227325



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *Himadri Roy
 *Sent:* Monday, October 19, 2009 9:50 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Query



 Hi All Champs,



 I have a spreadsheet where in every month some customers are being added
 per client, now some clients have left during some month, my problem is I am
 not able to get the net customers every month after deducting the customers
 who have left. lets for simplicity sake think of clients along with their
 customers left on a first come first go basis, and if anyone can help me
 with something wherein i can feed in the client leaving and net customers.
 please see the excel file attached with this mail



 Thanks in Advance



 Himadri



 



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

[big smile]

Hellow Friends,

Please guide me all this query particular to Excel 2007 Version.

Thanks








On Sat, Oct 17, 2009 at 4:22 PM, big smile bigsmile...@gmail.com wrote:

 Hellow all excel guru's   friends.

 I have some query -- or i want to know the shortcuts.

 1]  Can we delete the name given to particular cell in name box - if we
 type F5 - the name box appear

 I would like to know how to change the name and  delete  the name given to
 some reference.

 2] There are 3 sheets in one file -- i have hide one sheet -- i want to
 know can we give the password for opening

 of such hide sheet ? -- if yes how

 3] I have created one macro no. 7 -- in a particular file - i want to know
 can we define one another macro so that

 whenever i open that file -- macro no. 7 automatically run -- give me the
 result created in macro 7.

 4] whenever we run a particular macro -- we can not go back by ctrl + Z [
 undo ] -- or we can not restore the old things which were there before

 macro run -- is there any solution to such thing.

 5] I  have created certain custom view in file --- is there any shortcuts
 to change the name of that custom view ---

 at present i am using the technique to select the particular custom view --
 then delete the same  then giving another name

 this is perhaps the long procedure.-- is there any shortcuts of changing
 the custom view name





 Thanks  have a nice time




 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

[Dilip Pandey]

Hi BigSmile - Keep Smiling:-
Below are the answers to your queries (using Excel 2003):-

1) Yes, you can delete that name.  Go to Insert -Name- select the name and
press delete.  Change of name is not allowed, but Yes you can make a copy of
that name and rename that as per your choice

2) Yes, You can password to workbook by choosing path:- Tools - Protection
- Protect Workbook.  If you protect the workbook, then no one can unhide
that sheet, if password is not know to him/her.

3) Yes, you can use workbook_open event to write that macro with a Call
option or reference option.

4) After running the macro, you should close the Excel and say no to save
option provided If you have not written Save syntax in the code.

5) Re-naming option for custom view is not there, alternatively you should
try and record/ develop a macro to do this lengthy task for you.

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 10/17/09, big smile bigsmile...@gmail.com wrote:

 Hellow all excel guru's   friends.

 I have some query -- or i want to know the shortcuts.

 1]  Can we delete the name given to particular cell in name box - if we
 type F5 - the name box appear

 I would like to know how to change the name and  delete  the name given to
 some reference.

 2] There are 3 sheets in one file -- i have hide one sheet -- i want to
 know can we give the password for opening

 of such hide sheet ? -- if yes how

 3] I have created one macro no. 7 -- in a particular file - i want to know
 can we define one another macro so that

 whenever i open that file -- macro no. 7 automatically run -- give me the
 result created in macro 7.

 4] whenever we run a particular macro -- we can not go back by ctrl + Z [
 undo ] -- or we can not restore the old things which were there before

 macro run -- is there any solution to such thing.

 5] I  have created certain custom view in file --- is there any shortcuts
 to change the name of that custom view ---

 at present i am using the technique to select the particular custom view --
 then delete the same  then giving another name

 this is perhaps the long procedure.-- is there any shortcuts of changing
 the custom view name





 Thanks  have a nice time




 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query in excel:)

[Dilip Pandey]

You are welcome!!
Let the group know, if you face any challenge.  Thanks
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 9/21/09, Manoj Lambhate mayur2...@gmail.com wrote:

 Hi Dilip,

 Thanks a lot.
 I have taken a note of the websites you have given and will be getting some
 thing or the other for them.
 Nice to see so much solutions on the BEST in WORLD *EXCEL*.

 Keep pouring more in the ocean.

 Regards,
 Manoj

 On Mon, Sep 21, 2009 at 8:47 PM, Dilip Pandey dilipan...@gmail.comwrote:

 Hi Manoj,

 I do not work on Oracle database, but searched following for you:-


 http://database.ittoolbox.com/groups/technical-functional/excel-l/linking-ms-excel-spreadsheet-to-oracle-db-1532072

 http://www.bigresource.com/ASP-Uploading-excel-sheet-into-Oracle-db-table-PVHrFKGk.html

 Best Regards,
 --
 DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062


 On Mon, Sep 21, 2009 at 6:10 PM, Manoj Lambhate mayur2...@gmail.comwrote:

 Hi Dilip,

 I am Manoj Lambhate.
 I constantly read your tweaks on the group and blog.
 I need to know how can I connect my Excel Worksheet with an Oracle
 Database.

 Do mail me some excel or ppt's that explain how to do so.
 Waiting for your reply.


 Regards,
 Manoj!






--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[Dilip Pandey]

Hi Ankur,

Follow below steps:-
1. point out the mouse in between the data.
2.  Ctrl + *
3.  F5
4.  Alt + S
5.  k
6.  Enter Zero
7.  Ctrl + Enter
done

best Regards,
-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija ankursat...@gmail.com wrote:

 How to put zero ('0') in Blank Cells  scattered in a table?

  -
 Ankur Satija, Consultant


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[Harmeet Singh]

Follow below steps:

   1. *Select table where blank cells exist.*
   2. *Press F5*
   3. *Click on Special and then Blanks.*
   4. *Enter 0 and press Ctrl+Enter simultaneously.*

U r done.



On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija ankursat...@gmail.com wrote:

 How to put zero ('0') in Blank Cells  scattered in a table?

  -
 Ankur Satija, Consultant


 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query concerning Option/Radio Buttons and their captions

[Ajit Navre]

You can only place the radio button captions to the left or right of the
option indicator. The Alignment property does that.

When you have placed the labels (with caption) above the option button, you
can use some code like -

Private Sub OptionButton1_Enter()
Label2.BorderStyle = fmBorderStyleSingle
End Sub
Private Sub OptionButton1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Label2.BorderStyle = fmBorderStyleNone
Cancel = False
End Sub
Private Sub OptionButton2_Enter()
Label3.BorderStyle = fmBorderStyleSingle
End Sub
Private Sub OptionButton2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Label3.BorderStyle = fmBorderStyleNone
Cancel = False
End Sub

- to indicate which radio button is currently selected...

In the code above label2 and label3 are the caption labels above the radio
buttons.

Regards

Ajit


-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Yptrumpet
Sent: Monday, August 03, 2009 8:13 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Query concerning Option/Radio Buttons and
their captions


Anyone out there? Help please! I'm sure it's a simple question...

On Jul 30, 12:56 pm, Yptrumpet ivanjonasgo...@gmail.com wrote:
 Hello, everyone. This is my first post. I've looked high and low for
 an answer to this problem.

 I'm making a form in Excel to easily input data. I want to operate it
 with the keyboard as much as possible. There is a section of my form
 with four radio buttons. I want the captions above the buttons, so I
 simply removed the captions and placed four labels above the buttons.

 Now, when you tab through text boxes and buttons, it is clear which is
 the active control. With the radio buttons, on the other hand, it is
 not. It is very strange. On web pages, the button itself is
 encompassed with the dotted selection rectangle, but in VBA the
 caption is highlighted.

 THEREFORE, these are my questions:
 1. Is there a way to place radio button captions above (below, to the
 left of, etc...) the button? If so, problem solved.
 2. Else, what solution do you recommend? I simply want to know which
 radio button is currently active while tabbing through them.

 I thought about making four *_Enter subroutines which make the labels
 bold or normal depending on which radio button is selected.




--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL - thanks a lot

[big smile]

Thanks a lot Sir for the  changes you have made.

Excel is very wonderful -- very usable program

We can do wonder due to the full usage of excel formulas--

Due to this group members -- all of will learn more  best.

I have may doubt - still want to learn more technique -- can i ask a group
questions

then there is no problem?

yes u all genius user  answer my query -- whenever u get the time.

My query may sometimes silly -- as i am just learner --

in excel sky is the limit --- i am trying to reach the top of the big tree.


If all the group members - have any doubt or query of any type of insurance
then do ask

me -- i  can share my experience.

Thanks once again -- to MR. AJITJI -- for taking the efforts to answer my
query.

Thanks a lot.

















On Wed, Jul 29, 2009 at 7:08 PM, Ajit Navre aquas...@gmail.com wrote:

  Pls find attached the file. Changes made as per your requirement. Now the
 entire row will be duplicated and not just first 10 columns. So you can add
 any no. of columns, just ensure that you add new columns to the right of
 existing ones and not in between the existing ones.



 Regards



 Ajit

 *From:* big smile [mailto:bigsmile...@gmail.com]
 *Sent:* Wednesday, July 29, 2009 5:44 PM
 *To:* Ajit Navre

 *Subject:* Re: $$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL



 Thanks for the reply sir,

 I am not clear about the *1.4. 07 to 31.3. 2008* thing. Can you elaborate
 further on that. Also need to know what you mean by if i want to add more
 items in that raw - old raws - it automatically taken care of the existing
 macro.


 This is the period of insurance From 1.4.2007 to 31.3.2008 -- now when we
 make the duplicate entry then the new entry column become 1.4.2008 to
 31.3.2009. -

 If suppose we want to add some more columns - like  whether receipt has
 been sent to party -- or we recd. the commission on it  -etc

 The old macro will have to change ?

 thanks
 Ms. J. Shaha










  On Tue, Jul 28, 2009 at 8:38 PM, Ajit Navre aquas...@gmail.com wrote:

 Hi,



 Thank you for your word of appreciation.



 Coming to the post, Changes effected by a macro can not be undone. CTRL+Z
 will not work if the changes are through a macro.



 The macro at present assumes there are only 10 columns in a row. If you
 want to add more columns, then changes need to be made to the macro.



 I am not clear about the *1.4. 07 to 31.3. 2008* thing. Can you elaborate
 further on that. Also need to know what you mean by if i want to add more
 items in that raw - old raws - it automatically taken care of the existing
 macro.



 Regards



 Ajit



 *From:* big smile [mailto:bigsmile...@gmail.com]
 *Sent:* Tuesday, July 28, 2009 1:16 AM
 *To:* excel-macros@googlegroups.com; aquas...@gmail.com
 *Subject:* Re: $$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL



 Thanks Ajitji



 u have given good solution to my query.



 i want to elorbrate more on the same sheet ---



 that suppose if i made wrongly clik the duplicate  then it macro --
 ctrl Z - undo



 does not work.. --- ok i can physically delete the raw -- correct the
 pending coulmn



 But suppose that raw there is still some more columns that the period



 from 1.4. 07 to 31.3. 2008  then that should be also change in the new
 raw as the period



 from 1.4. 08 to 31 .3. 09 



 if i want to add more items in that raw - old raws - it automatically taken
 care of the existing



 macro -- or i should modify.





 or shall i send again the example file.



 Thanks









































 On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre aquas...@gmail.com wrote:

 Please find the file attached….



 Let me know if you have any doubts



 Regards



 Ajit



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *big smile
 *Sent:* Monday, July 27, 2009 10:45 AM
 *To:* EXCEL MACRO GROUP
 *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL



 Respected Group memebers,

 Attach please find the query file no.3 ---

 I would like to know the macro  to do the necessary entries as shown in the
 files.

 Thanks -  have a nice day.


 







--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL

[big smile]

Thank you very much --

I will check the function --  let you know.

Ms. J. Shah





On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre aquas...@gmail.com wrote:

  Please find the file attached….



 Let me know if you have any doubts



 Regards



 Ajit



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *big smile
 *Sent:* Monday, July 27, 2009 10:45 AM
 *To:* EXCEL MACRO GROUP
 *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL



 Respected Group memebers,

 Attach please find the query file no.3 ---

 I would like to know the macro  to do the necessary entries as shown in the
 files.

 Thanks -  have a nice day.


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL

[big smile]

Thanks Ajitji

u have given good solution to my query.

i want to elorbrate more on the same sheet ---

that suppose if i made wrongly clik the duplicate  then it macro -- ctrl
Z - undo

does not work.. --- ok i can physically delete the raw -- correct the
pending coulmn

But suppose that raw there is still some more columns that the period

from 1.4. 07 to 31.3. 2008  then that should be also change in the new
raw as the period

from 1.4. 08 to 31 .3. 09 

if i want to add more items in that raw - old raws - it automatically taken
care of the existing

macro -- or i should modify.


or shall i send again the example file.

Thanks





















On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre aquas...@gmail.com wrote:

  Please find the file attached….



 Let me know if you have any doubts



 Regards



 Ajit



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *big smile
 *Sent:* Monday, July 27, 2009 10:45 AM
 *To:* EXCEL MACRO GROUP
 *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL



 Respected Group memebers,

 Attach please find the query file no.3 ---

 I would like to know the macro  to do the necessary entries as shown in the
 files.

 Thanks -  have a nice day.


 



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY ON EXCEL

[Upendra Singh]

Use Index-Match

 

=INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1))

 

Regards,

 

Upendra Singh

+91-9910227325, +91-9310760597

 


-

There are 10 kinds of people: Those who understand binary and those who
don't.


-

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of big smile
Sent: Saturday, July 25, 2009 5:43 PM
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ QUERY ON EXCEL

 

Respected friends,

I am new this group.

Attached please find the excel 2007 query file-

I would like to know the shortcut formula or macro to get the result.

Thanks in advance.



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY ON EXCEL

[Dilip Pandey]

Hi Big Smile

Keep Smiling..!!
Your problem is solved and attached with this email.

Thanks,
DILipandey

--
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062

On 7/25/09, big smile bigsmile...@gmail.com wrote:
 Respected friends,

 I am new this group.

 Attached please find the excel 2007 query file-

 I would like to know the shortcut formula or macro to get the result.

 Thanks in advance.

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



QUERY_2-By DILipandey.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: QUERY ON EXCEL

[vivek agrawal]

Hi
The query is not very clear  can u please explain what you want


Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83

GoogleMoonlight.com  - Saving energy-Save Earth




On Sat, Jul 25, 2009 at 5:43 PM, big smile bigsmile...@gmail.com wrote:

 Respected friends,

 I am new this group.

 Attached please find the excel 2007 query file-

 I would like to know the shortcut formula or macro to get the result.

 Thanks in advance.

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: QUERY ON EXCEL

[big smile]

Thanks a lot

Mrs. Jayshree  Shah











On Sat, Jul 25, 2009 at 8:07 PM, Upendra Singh upendrasinghsen...@gmail.com
 wrote:

  Use Index-Match



 =INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1))



 Regards,



 Upendra Singh

 +91-9910227325, +91-9310760597




 -

 There are 10 kinds of people: Those who understand binary and those who
 don’t.


 -



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *big smile
 *Sent:* Saturday, July 25, 2009 5:43 PM
 *To:* EXCEL MACRO GROUP
 *Subject:* $$Excel-Macros$$ QUERY ON EXCEL



 Respected friends,

 I am new this group.

 Attached please find the excel 2007 query file-

 I would like to know the shortcut formula or macro to get the result.

 Thanks in advance.


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[Naga]

Dear Amit,

The easiest way of sending an email for 1 IDs is doing mail merge using
MS Word.

On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:

 Dear All

 I have excel file with 10,000 email id in one column. I want to send mail
 to all of these. i have to put , or ; at every email id so that it could be
 send to all. How can i do it

 pl tell help me -.

 regards



 --
 Amit Arora

 



-- 
Regards
Naga

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[Ashish Jain]

---
---

Hi,

However, Gmail, Yahoo and Hotmail automatically does this task. So
Solution 1 is:
1. Copy upto 500(Gmail), 100(Yahoo) and 50(Hotmail) rows of column
depending on desired application.
2. Paste it in To,CC or BCC section of email application.
3. Go to Body area of mail application. It would have automatically
done that.

But if you're using old versions of these mail application or some
other mail application, you need to manually do the task. So Solution
2 is:
Assumption: Your 10,000 email id are in this range - A1 to A1.
1. Go to cell B2 and type the formula = B1  ,  A2  ,
2. Select The Range B2 to B10001.
3. Press Ctrl + D. (Use to fill series with formula)
4. Select the Range B2 to B10001. Right click on it and select Copy.
5. Right click on Cell B2 or C2. Select Paste Special.
6. Select Values. Click Ok.
7. You're done.


P.S. - Sending mail to this much amount of users using these mail
client applications can tag you as spammer.

For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com

Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
---
---
On Feb 24, 5:53 pm, amit arora amit.aur...@gmail.com wrote:
 Dear All
 I have excel file with 10,000 email id in one column. I want to send
mail to
 all of these. i have to put , or ; at every email id so that it could
be
 send to all. How can i do it
 pl tell help me -.
 regards
 --
 Amit Arora
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[Harmeet Singh]

Great solution

On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com wrote:

 Dear Amit,

 The easiest way of sending an email for 1 IDs is doing mail merge using
 MS Word.

 On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:

 Dear All

 I have excel file with 10,000 email id in one column. I want to send mail
 to all of these. i have to put , or ; at every email id so that it could be
 send to all. How can i do it

 pl tell help me -.

 regards



 --
 Amit Arora





 --
 Regards
 Naga

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[sarfaraz ahmed]

suppose you have email id in A column starting from A2

in B2 type =B2
and in B3 type = B2  ,   A3

Then drag it till the cell where you have email addresses.
in the last cell you will get

emailid1, emailid2 and so on.

copy text in last cell and paste in notepad or use copy paste value option
in MS Excel


Regards,
MS Excel help
http://findsarfaraz.blogspot.com/
On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:

 Dear All

 I have excel file with 10,000 email id in one column. I want to send mail
 to all of these. i have to put , or ; at every email id so that it could be
 send to all. How can i do it

 pl tell help me -.

 regards



 --
 Amit Arora

 



-- 
Thanks with regards,
Sarfaraz Ahmed

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

[johnson dara]

Hi Naga,

 Here is the short cut.

pls. see the file attached.

regds.,
Johnson


On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com wrote:

 Dear Amit,

 The easiest way of sending an email for 1 IDs is doing mail merge using
 MS Word.

 On Tue, Feb 24, 2009 at 6:23 PM, amit arora amit.aur...@gmail.com wrote:

 Dear All

 I have excel file with 10,000 email id in one column. I want to send mail
 to all of these. i have to put , or ; at every email id so that it could be
 send to all. How can i do it

 pl tell help me -.

 regards



 --
 Amit Arora





 --
 Regards
 Naga

 


--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Microsoft Excel .xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Query

[N.Shivkumar]

The solution suggested by  Mr. Johnson is the easiest for a layman. I fail
to understand why people make simple things complicated.

N.Shivkumar
Office  : +914027685423
Mobile : +919866533180
Res : +914040035774
Alternate Email : shiv1...@yahoo.com

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---