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

2020-02-15 Thread 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 !!!

2016-08-16 Thread सचिन शर्मा
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

2015-07-09 Thread 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

2015-04-28 Thread 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  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.


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

2015-04-28 Thread 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.


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

2015-04-28 Thread Paul Schreiner
I'm curious about your file size and response issue. What version of Excel are 
you using?As ask because I use Excel 2010 and have a file that is generated 
from 5 different data sources.The file contains 29 sheets,one of which contains 
145,500 rows and 74 columns.There are 27 macro modules containing 13,700 lines 
of VBA code. This, to me, seems to be a rather large file. If I save it as 
Excel97-2003 format (.xls) it is 83Mb,If I save it in Excel2010 macro format 
(.xlsm) format, it's 55Mb.If I save it in Excel2010 binary format (.xlsb), it's 
only 17Mb. (the .xlsb format runs MUCH faster) So, I'm curious as to why your 
file is 350mb.Does it contain graphics/images?Are there lots of formulas? 
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
 
  From: Mandeep Baluja 
 To: excel-macros@googlegroups.com 
 Sent: Tuesday, April 28, 2015 6:11 AM
 Subject: $$Excel-Macros$$ Re: Query to retreive data
   
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.


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

2015-04-28 Thread 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"  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

2015-04-28 Thread 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

2015-04-28 Thread 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

2015-03-20 Thread saravanan R
On Wed, Mar 18, 2015 at 5:31 PM, saravanan R  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 
> 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

2015-03-18 Thread 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 
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

2015-03-18 Thread 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


$$Excel-Macros$$ Re: Query for autofit columns.

2015-03-12 Thread Mandeep baluja
got to know autofit not works for merge cells was doing the issue tried 
this code it works. 

 Sub Hidealternatecolumns()

Dim first As Double
Dim last As Double

first = 4
last = 65

For i = first To last
If Cells(1, i).Column Mod 2 = 0 Then
Cells(1, i).EntireColumn.Hidden = True
End If
Next

Range("E9:BN9").SpecialCells(xlCellTypeVisible).Select
Selection.ColumnWidth = 6

End Sub



On Thursday, 12 March 2015 13:43:32 UTC+5:30, Mandeep baluja wrote:
>
> Quuery for autofit
>

-- 
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 in IF formula on sheet deactivation event

2015-03-02 Thread 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 
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

2015-03-01 Thread 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

2014-11-15 Thread 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 
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

2014-11-13 Thread 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 count

2014-11-13 Thread 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

2014-11-13 Thread 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


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

2013-08-31 Thread 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 
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 >
*Date: *Thu, 29 Aug 2013 13:19:08 +0530
*To: *>
*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, send email to excel-macros@googlegroups.com.
Visit this gro

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

2013-08-31 Thread 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  
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 
>> Date: Thu, 29 Aug 2013 13:19:08 +0530
>> To: 
>> 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.


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

2013-07-04 Thread 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

2012-09-30 Thread 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

2012-09-30 Thread 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

2012-09-29 Thread 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.




$$Excel-Macros$$ Re: Query

2012-09-28 Thread 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.




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

2012-09-28 Thread 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  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

2012-09-28 Thread Don Guillett


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.




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

2012-09-13 Thread 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.




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

2012-07-13 Thread 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 
Sender: excel-macros@googlegroups.com
Date: Fri, 13 Jul 2012 18:24:57 
To: 
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 wrote:

> Hi Group,
>
>
> How can i declare a global variable for below mentioned.
>
>
>
> Private sub abc()
> dim sh as worksheet
> dim rng as range
>
> set sh = Thisworkbook.Sheets("Sheet1")
> set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
>
> End sub
>
>
> In my module i have 20 procedure and in future comes many more.
> So, my query how to declare a global variable and how to call in my
> procedure.
>
> Regards,
> excelvba.lear...@gmail.com
>
>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2012-07-13 Thread 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 wrote:

> Hi Group,
>
>
> How can i declare a global variable for below mentioned.
>
>
>
> Private sub abc()
> dim sh as worksheet
> dim rng as range
>
> set sh = Thisworkbook.Sheets("Sheet1")
> set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
>
> End sub
>
>
> In my module i have 20 procedure and in future comes many more.
> So, my query how to declare a global variable and how to call in my
> procedure.
>
> Regards,
> excelvba.lear...@gmail.com
>
>

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

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

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

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

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

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

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

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

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

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

2012-07-10 Thread Prince Dubey
Hi Hemant,

Please see this sub, i hope this will help you.


Sub Autonumber()
Dim rng As Range
Dim intNext As Integer

With ThisWorkbook.Worksheets("Sheet1")
Set rng = .Range("A1:A" & .Range("A" & .Rows.Count).End(xlUp).Row)
intNext = Application.WorksheetFunction.Max(rng)
rng.Offset(1) = intNext + 1
End With

End Sub


Regards
Prince dubey.

On Tuesday, July 10, 2012 7:12:00 PM UTC+5:30, Hemant wrote:
>
> Hi Group,
>  
> I am trying to get a automatically generate a Number using the last number 
> used + 1, through vba.
>  
>  
> Regards,
> Hemant.
>

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Re: Query from URL

2012-01-02 Thread Alberto
Ok now it works.
I dont why, but it works :-)

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

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

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

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

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

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

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

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


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

2011-09-03 Thread Venkat CV
Dear Shasi,

You are Welcome...

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

On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan  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 wrote:
>
>> Dear Shashi,
>>
>> Please see attached sheet if it help to u...
>>
>> On Thu, Sep 1, 2011 at 2:22 PM, shashi  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  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/*
>>
>>  --
>>
>> --
>> 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


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

2011-09-03 Thread 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  wrote:

> Dear Shashi,
>
> Please see attached sheet if it help to u...
>
> On Thu, Sep 1, 2011 at 2:22 PM, shashi  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  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/*
>
>  --
>
> --
> 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

2011-09-01 Thread 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  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

2011-07-07 Thread Kal xcel
Thanks Ashish

Thanks Ankur

On Thu, Jul 7, 2011 at 11:51 AM, ankur  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  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 wrote:
>>
>>>
>>>
>>> On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel  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.posterous.com/
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> 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


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

2011-07-06 Thread 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  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  wrote:
>
>>
>>
>> On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel  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.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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

2011-07-06 Thread 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  wrote:

>
>
> On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel  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.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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


$$Excel-Macros$$ Re: Query

2011-07-06 Thread ashish koul
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel  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.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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 for a solution

2011-02-13 Thread 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  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


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

2010-12-23 Thread 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  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=wall&ref=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=wall&ref=ts


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

2010-12-23 Thread 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=wall&ref=ts


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

2010-07-10 Thread 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  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 - Date Formula

2010-07-10 Thread 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


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

2009-10-20 Thread Himadri Roy
Hi,

U r right, see i need to deduct the cumulative customers...plz find attached
sheet for ur reference




On Tue, Oct 20, 2009 at 2:12 PM, Anubhav Somani wrote:

> Hi Himadri,
>
> I m not sure if i hv understood the query correctly, pls clarify...
> U are unable to give the effect of customer reduction once a client leaves.
> I assume that wn a client leaves, all customers linked to that client also
> go off?? right??
> If i m right, do you have any data (or summary) of clientwise customers?
>
> i mean for client A (in month Oct), Customers add= x; less=y
>
>   On Mon, Oct 19, 2009 at 9:50 PM, Himadri Roy wrote:
>
>> 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
-~--~~~~--~~--~--~---



Query.xls
Description: MS-Excel spreadsheet


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

2009-10-20 Thread Anubhav Somani
Hi Himadri,

I m not sure if i hv understood the query correctly, pls clarify...
U are unable to give the effect of customer reduction once a client leaves.
I assume that wn a client leaves, all customers linked to that client also
go off?? right??
If i m right, do you have any data (or summary) of clientwise customers?

i mean for client A (in month Oct), Customers add= x; less=y

On Mon, Oct 19, 2009 at 9:50 PM, Himadri Roy  wrote:

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

2009-10-20 Thread 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  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

2009-10-20 Thread 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  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 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  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

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

2009-10-20 Thread Upendra Singh
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.3 - SUMMARISED DATA & SUBTOTAL ON ANOTHER SHEET.

2009-10-19 Thread 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  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

2009-10-19 Thread 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  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  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

2009-10-19 Thread 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  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

2009-10-18 Thread 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  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

2009-10-18 Thread Terry

On the menu select Insert - Name - Define. You can add, change or
delete range names from there.

On Oct 17, 6:52 am, big smile  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:)

2009-09-21 Thread 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  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 wrote:
>
>> 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 wrote:
>>
>>> 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

2009-09-18 Thread 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  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

2009-09-10 Thread Mahesh
Hi Ankur,

Use Ctrl+H, and replace blank with 0.

this will solve ur problem,

Rgds,
Mahender Bisht

On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija  wrote:

> How to put zero ('0') in Blank Cells  scattered in a table?
>
>>  -
>> Ankur Satija, Consultant
>>
>
> >
>


-- 
With Love,
Mahesh Bisht

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

2009-09-08 Thread 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  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

2009-08-04 Thread 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  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 concerning Option/Radio Buttons and their captions

2009-08-03 Thread Yptrumpet

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

On Jul 30, 12:56 pm, Yptrumpet  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

2009-07-29 Thread 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  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  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  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.
>
>
> >

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

2009-07-27 Thread 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  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

2009-07-27 Thread 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  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

2009-07-25 Thread big smile
Thanks a lot

Mrs. Jayshree  Shah











On Sat, Jul 25, 2009 at 8:07 PM, Upendra Singh  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 ON EXCEL

2009-07-25 Thread 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  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

2009-07-25 Thread Dilip Pandey
Hi 

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

2009-07-25 Thread 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

2009-02-24 Thread Lavprasad Kori
Dear Amit,

If U want to send one email to all 10,000 mail id's. Then U have to type a
mail in MS - Word using mail merge option. For sending it, it does not
require , or ; or anything else. You has to select existing list . then open
the excel file. select the sheet & Click on OK.  U has to do preview then
send to one or All.

Regards,

Lavprasad Kori
MIS Executive
Hindustan Unilever Limited
Mob : 9867931351




On Tue, Feb 24, 2009 at 6:23 PM, amit arora  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 & Regards,

Lavprasad Kori
MIS Executive - Water
Tel. 022 - 39833428

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

2009-02-24 Thread 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
-
-~--~~~~--~~--~--~---



$$Excel-Macros$$ Re: Query

2009-02-24 Thread 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  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  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

2009-02-24 Thread 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

On Tue, Feb 24, 2009 at 6:23 PM, amit arora  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

2009-02-24 Thread Harmeet Singh
Great solution

On Tue, Feb 24, 2009 at 6:34 PM, Naga  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  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

2009-02-24 Thread 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  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

2009-02-24 Thread 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  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
-
-~--~~~~--~~--~--~---