$$Excel-Macros$$ Excel Macros Free PDF
Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Help on Graph
Hi AJ, My name is saroj, i m new joinee to this group but been viewing all the e-mails and quieries with their masterminded solutions. I was some how able to analyse the solution and founded the formula which has been used to solve a certain quiery. This time i got stuck with your great technique. Kindly tell me how did u incorporated the no.s in the graph.I am unable solve it. Thank you, Saroj. On Thu, Feb 11, 2010 at 10:43 AM, Abhishek Jain wrote: > Hi Shyam, > > I have updated the graph as per your below requirements. Please see the > attached file - is this what you looking for ? > > Thanks, > > AJ > > > On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy wrote: > >> Hi Rock, >> >> Thanks for the response. It works partially. >> >> Ok let me get the criterias up: >> >> >>1. I would need the RAG (in the back ground as shown in the excel) >>2. I would need the Diagonal Bisecting the Chart too. >> >> Will this be possible? I tried to do a combo.. but with out any success! >> >> Regards >> Shyam >> >> >> On 9 February 2010 17:10, Rock wrote: >> >>> Hi Sammy, >>> >>> You can use the XY (Scatter) chart the create this. >>> >>> Regards >>> Rakesh >>> >>> >>> On Feb 9, 9:54 am, "$...@mmy" wrote: >>> > Hi All, >>> > >>> > Could any one help me out with plotting the attached graph. Currently I >>> get >>> > them manually adjusting the dots based on the axis. >>> > >>> > Is there a way where in i get the variables in the table and the Graph >>> gets >>> > automatically updated? >>> > >>> > Regards >>> > Shyam >>> > >>> > Graph.xlsx >>> > 16KViewDownload >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-ma
$$Excel-Macros$$ VBA Help
Option Explicit
Sub InputSales()
Dim MonthOfSales As String
Dim SalesData(1 to 4)
MonthOfSales = InputBox(prompt:= "Enter month of sales", _
title:= "Month")
SalesData(1) =InputBox(prompt:= "Enter sales for week 1")
SalesData(2) =InputBox(prompt:= "Enter sales for week 2")
SalesData(3) =InputBox(prompt:= "Enter sales for week 3")
SalesData(4) =InputBox(prompt:= "Enter sales for week 4")
Range("A1").Value = UCase(MonthOfSales)
Range("B2:E2").Cells(1).Value = SalesData(1)
Range("B2:E2").Cells(2).Value = SalesData(2)
Range("B2:E2").Cells(3).Value = SalesData(3)
Range("B2:E2").Cells(4).Value = SalesData(4)
Range("B2:E2").NumberFormat = "£0.00"
Columns("A:E").EntireColumn.AutoFit
End Sub
* *
Can any body help me out to crack this code
1. Why they use Option Explicit
2. What is the meaning of this code Range("A1").Value = UCase(MonthOfSales)
3. What is the meaning of this code MonthOfSales = InputBox(prompt:= "Enter
month of sales", _
title:= "Month")
--
Shiv Goel
8NBYN060
ICFAI National College,YNR
9416275776
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Help on Graph
Hi Shyam, Well there was a little trick in doing this. Thats how it happened - I took screenshot of your background (RAG). Cropped it to remove other unnecessary things. Saved it as a separate picture. Used the picture in filling the graph. (Right-Click>Format Chart Area>Fill Effects>Picture) Removed the gridlines, legends, etc. Resized the plot area to fit to the picture. If you wish to populate the value of marks in the graph, right click on the chart, select chart options, under Data Labels tab, check 'Y Value'. Cheers! Abhishek On Thu, Feb 11, 2010 at 12:56 PM, $...@mmy wrote: > Hi Abhishek, > > Its Working Fine ... Amazing.. Thanks a Ton. > > I would need to know how do we get this up so that I can be able to create > such graph. Can you please walk me thru the steps? > > Secondly, I would need to populate both the values.. can we get that too? > > Cheers > Shyam > > > On 11 February 2010 10:43, Abhishek Jain wrote: > >> Hi Shyam, >> >> I have updated the graph as per your below requirements. Please see the >> attached file - is this what you looking for ? >> >> Thanks, >> >> AJ >> >> On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy wrote: >> >>> Hi Rock, >>> >>> Thanks for the response. It works partially. >>> >>> Ok let me get the criterias up: >>> >>> >>>1. I would need the RAG (in the back ground as shown in the excel) >>>2. I would need the Diagonal Bisecting the Chart too. >>> >>> Will this be possible? I tried to do a combo.. but with out any success! >>> >>> Regards >>> Shyam >>> >>> >>> On 9 February 2010 17:10, Rock wrote: >>> Hi Sammy, You can use the XY (Scatter) chart the create this. Regards Rakesh On Feb 9, 9:54 am, "$...@mmy" wrote: > Hi All, > > Could any one help me out with plotting the attached graph. Currently I get > them manually adjusting the dots based on the axis. > > Is there a way where in i get the variables in the table and the Graph gets > automatically updated? > > Regards > Shyam > > Graph.xlsx > 16KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers
Re: $$Excel-Macros$$ Re: Help on Graph
Hi Saroj, A warm welcome to the group! Thank you very much for your kind words but there is nothing extraordinary I did in this. I think you missed the email I sent to Shyam mentioning the steps. The same is being reproduced hereunder - > I took screenshot of your background (RAG). (Printscreen) > Cropped it to remove other unnecessary things. - (Crop it in Office Picture Manager or Excel, Powerpoint, wherever you like) > Saved it as a separate picture. > Used the picture in filling the graph. (Right-Click>Format Chart Area>Fill Effects>Picture) > Removed the gridlines, legends, etc. > Resized the plot area to fit to the picture. If you wish to populate the value of marks in the graph, right click on the chart, select chart options, under Data Labels tab, check 'Y Value'. However, there is a difference there - Shyam's background was colored on the basis of values (I guess), but in this case I just used it as a picture to fill the graph so whenever you resize the graph, the axises and the picture will differoye! Putting a picture in the background of a graph doesn't make me a geniusdoes it ? :) Cheers! Abhishek On Thu, Feb 11, 2010 at 12:45 PM, saroj.32006 wrote: > Hi AJ, > > My name is saroj, i m new joinee to this group but been viewing all the > e-mails and quieries with their masterminded solutions. I was some how able > to analyse the solution and founded the formula which has been used to solve > a certain quiery. This time i got stuck with your great technique. Kindly > tell me how did u incorporated the no.s in the graph.I am unable solve > it. > > Thank you, > > Saroj. > > On Thu, Feb 11, 2010 at 10:43 AM, Abhishek Jain wrote: > >> Hi Shyam, >> >> I have updated the graph as per your below requirements. Please see the >> attached file - is this what you looking for ? >> >> Thanks, >> >> AJ >> >> >> On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy wrote: >> >>> Hi Rock, >>> >>> Thanks for the response. It works partially. >>> >>> Ok let me get the criterias up: >>> >>> >>>1. I would need the RAG (in the back ground as shown in the excel) >>>2. I would need the Diagonal Bisecting the Chart too. >>> >>> Will this be possible? I tried to do a combo.. but with out any success! >>> >>> Regards >>> Shyam >>> >>> >>> On 9 February 2010 17:10, Rock wrote: >>> Hi Sammy, You can use the XY (Scatter) chart the create this. Regards Rakesh On Feb 9, 9:54 am, "$...@mmy" wrote: > Hi All, > > Could any one help me out with plotting the attached graph. Currently I get > them manually adjusting the dots based on the axis. > > Is there a way where in i get the variables in the table and the Graph gets > automatically updated? > > Regards > Shyam > > Graph.xlsx > 16KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> -- >> >> -
Re: $$Excel-Macros$$ Re: Help on Graph
Hi Abhishek, Thanks a ton for solving my problem... Cheers Shyam On 11 February 2010 17:17, Abhishek Jain wrote: > Hi Saroj, > > A warm welcome to the group! > > Thank you very much for your kind words but there is nothing extraordinary > I did in this. I think you missed the email I sent to Shyam mentioning the > steps. The same is being reproduced hereunder - > > > > I took screenshot of your background (RAG). (Printscreen) > > Cropped it to remove other unnecessary things. - (Crop it in Office > Picture Manager or Excel, Powerpoint, wherever you like) > > > Saved it as a separate picture. > > Used the picture in filling the graph. (Right-Click>Format Chart > Area>Fill Effects>Picture) > > Removed the gridlines, legends, etc. > > Resized the plot area to fit to the picture. > > If you wish to populate the value of marks in the graph, right click on the > chart, select chart options, under Data Labels tab, check 'Y Value'. > > However, there is a difference there - Shyam's background was colored on > the basis of values (I guess), but in this case I just used it as a picture > to fill the graph so whenever you resize the graph, the axises and the > picture will differoye! > > Putting a picture in the background of a graph doesn't make me a > geniusdoes it ? :) > > Cheers! > > Abhishek > > On Thu, Feb 11, 2010 at 12:45 PM, saroj.32006 wrote: > >> Hi AJ, >> >> My name is saroj, i m new joinee to this group but been viewing all the >> e-mails and quieries with their masterminded solutions. I was some how able >> to analyse the solution and founded the formula which has been used to solve >> a certain quiery. This time i got stuck with your great technique. Kindly >> tell me how did u incorporated the no.s in the graph.I am unable solve >> it. >> >> Thank you, >> >> Saroj. >> >> On Thu, Feb 11, 2010 at 10:43 AM, Abhishek Jain >> wrote: >> >>> Hi Shyam, >>> >>> I have updated the graph as per your below requirements. Please see the >>> attached file - is this what you looking for ? >>> >>> Thanks, >>> >>> AJ >>> >>> >>> On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy wrote: >>> Hi Rock, Thanks for the response. It works partially. Ok let me get the criterias up: 1. I would need the RAG (in the back ground as shown in the excel) 2. I would need the Diagonal Bisecting the Chart too. Will this be possible? I tried to do a combo.. but with out any success! Regards Shyam On 9 February 2010 17:10, Rock wrote: > Hi Sammy, > > You can use the XY (Scatter) chart the create this. > > Regards > Rakesh > > > On Feb 9, 9:54 am, "$...@mmy" wrote: > > Hi All, > > > > Could any one help me out with plotting the attached graph. Currently > I get > > them manually adjusting the dots based on the axis. > > > > Is there a way where in i get the variables in the table and the > Graph gets > > automatically updated? > > > > Regards > > Shyam > > > > Graph.xlsx > > 16KViewDownload > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><>
Re: $$Excel-Macros$$ Re: Help on Graph
You're welcome Shyam... On Thu, Feb 11, 2010 at 5:31 PM, $...@mmy wrote: > Hi Abhishek, > > Thanks a ton for solving my problem... > > Cheers > Shyam > > > On 11 February 2010 17:17, Abhishek Jain wrote: > >> Hi Saroj, >> >> A warm welcome to the group! >> >> Thank you very much for your kind words but there is nothing extraordinary >> I did in this. I think you missed the email I sent to Shyam mentioning the >> steps. The same is being reproduced hereunder - >> >> >> > I took screenshot of your background (RAG). (Printscreen) >> > Cropped it to remove other unnecessary things. - (Crop it in Office >> Picture Manager or Excel, Powerpoint, wherever you like) >> >> > Saved it as a separate picture. >> > Used the picture in filling the graph. (Right-Click>Format Chart >> Area>Fill Effects>Picture) >> > Removed the gridlines, legends, etc. >> > Resized the plot area to fit to the picture. >> >> If you wish to populate the value of marks in the graph, right click on >> the chart, select chart options, under Data Labels tab, check 'Y Value'. >> >> However, there is a difference there - Shyam's background was colored on >> the basis of values (I guess), but in this case I just used it as a picture >> to fill the graph so whenever you resize the graph, the axises and the >> picture will differoye! >> >> Putting a picture in the background of a graph doesn't make me a >> geniusdoes it ? :) >> >> Cheers! >> >> Abhishek >> >> On Thu, Feb 11, 2010 at 12:45 PM, saroj.32006 wrote: >> >>> Hi AJ, >>> >>> My name is saroj, i m new joinee to this group but been viewing all the >>> e-mails and quieries with their masterminded solutions. I was some how able >>> to analyse the solution and founded the formula which has been used to solve >>> a certain quiery. This time i got stuck with your great technique. Kindly >>> tell me how did u incorporated the no.s in the graph.I am unable solve >>> it. >>> >>> Thank you, >>> >>> Saroj. >>> >>> On Thu, Feb 11, 2010 at 10:43 AM, Abhishek Jain >>> wrote: >>> Hi Shyam, I have updated the graph as per your below requirements. Please see the attached file - is this what you looking for ? Thanks, AJ On Tue, Feb 9, 2010 at 8:14 PM, $...@mmy wrote: > Hi Rock, > > Thanks for the response. It works partially. > > Ok let me get the criterias up: > > >1. I would need the RAG (in the back ground as shown in the excel) >2. I would need the Diagonal Bisecting the Chart too. > > Will this be possible? I tried to do a combo.. but with out any > success! > > Regards > Shyam > > > On 9 February 2010 17:10, Rock wrote: > >> Hi Sammy, >> >> You can use the XY (Scatter) chart the create this. >> >> Regards >> Rakesh >> >> >> On Feb 9, 9:54 am, "$...@mmy" wrote: >> > Hi All, >> > >> > Could any one help me out with plotting the attached graph. >> Currently I get >> > them manually adjusting the dots based on the axis. >> > >> > Is there a way where in i get the variables in the table and the >> Graph gets >> > automatically updated? >> > >> > Regards >> > Shyam >> > >> > Graph.xlsx >> > 16KViewDownload >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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
Re: $$Excel-Macros$$ VBA Help
Shiv,
Are you not using Excel help?
or are you reading a book and trying to understand it?
Or are you in school and this is your homework?
Option Explicit Statement
Used at module level to force explicit declaration of all variables in that
module.
Syntax
Option Explicit
Remarks
If used, the Option Explicit statement must appear in a module before any
procedures.
When Option Explicit appears in a module, you must explicitly declare all
variables using the Dim, Private, Public, ReDim, or Static statements. If you
attempt to use an undeclared variable name, an error occurs at compile time.
If you don't use the Option Explicit statement, all undeclared variables are of
Variant type unless the default type is otherwise specified with a Deftype
statement.
Note
Use Option Explicit to avoid incorrectly typing the name of an existing
variable or to avoid confusion in code where the scope of the variable is not
clear.
Application.InputBox Method
Displays a dialog box for user input. Returns the information entered in the
dialog box.
expression.InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextID,
Type)
UCase Function
Returns a Variant (String) containing the specified string, converted to
uppercase.
Syntax
UCase(string)
The required string argument is any valid string expression. If string contains
Null, Null is returned.
Remarks
Only lowercase letters are converted to uppercase; all uppercase letters and
nonletter characters remain unchanged.
so:
MonthOfSales = InputBox(prompt:= "Enter month of sales", title:= "Month")
prompts the user to enter a "month" and stores it in the variable "MonthOfSales"
then:
Range("A1").Value = UCase(MonthOfSales)
converts "MonthOfSales" to uppercase and puts it in Cell A1.
P
From: Shiv Goel
To: excel-macros@googlegroups.com
Sent: Thu, February 11, 2010 2:34:06 AM
Subject: $$Excel-Macros$$ VBA Help
Option Explicit
Sub InputSales()
Dim MonthOfSales As String
Dim SalesData(1 to 4)
MonthOfSales = InputBox(prompt:= "Enter month of sales", _
title:= "Month")
SalesData(1) =InputBox(prompt:= "Enter sales for week 1")
SalesData(2) =InputBox(prompt:= "Enter sales for week 2")
SalesData(3) =InputBox(prompt:= "Enter sales for week 3")
SalesData(4) =InputBox(prompt:= "Enter sales for week 4")
Range("A1").Value = UCase(MonthOfSales)
Range("B2:E2").Cells(1).Value = SalesData(1)
Range("B2:E2").Cells(2).Value = SalesData(2)
Range("B2:E2").Cells(3).Value = SalesData(3)
Range("B2:E2").Cells(4).Value = SalesData(4)
Range("B2:E2").NumberFormat = "£0.00"
Columns("A:E").EntireColumn.AutoFit
End Sub
Can any body help me out to crack this code
1. Why they use Option Explicit
2. What is the meaning of this code Range("A1").Value = UCase(MonthOfSales)
3. What is the meaning of this codeMonthOfSales = InputBox(prompt:= "Enter
month of sales", _
title:= "Month")
--
Shiv Goel
8NBYN060
ICFAI National College,YNR
9416275776
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 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.go
$$Excel-Macros$$ need your help
friends please go through the attached file and help me. For about an hour I am fiddling with this. what I want: based on the value in cell K8; the corresponding band level should be highlighted automatically and a final result is available after all the calculations corresponding to the relevent basic and band regards -- shammi shrivastav -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 Evaluation Sheet.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ I lossed my password how to recover that
Hi Team, Can any hlep me how recover my password, I lossed it. If i want to attach let me know how can i attach to this blog? Thanks Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Gift for you all...........
can you send the VB code too ? On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group.* > * > * > *Enjoy and keep up the good work.* > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- Thanks, Madhu Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Gift for you all...........
Dear, Its really GREAT !!! On Thu, Feb 11, 2010 at 6:37 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group.* > * > * > *Enjoy and keep up the good work.* > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- ~ajaY~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: Fwd: $$Excel-Macros$$ kindly help in modifying attached macro
dearest paul, Thanks a lot.U are really a friend in need. aju On Thu, Feb 11, 2010 at 9:32 PM, Paul Schreiner wrote: > > What you've asked to do isn't difficult, but it IS time-consuming. > This forum isn't designed to be a "free programming service" site. > Most of the users here have jobs, and volunteer their time to help others > at THEIR jobs. > > What you've asked to do looks simple enough, on the surface. > But it can get complicated. > For instance, in your macro, you're copying the SAP data to the new sheet > and adding the PHY values. > but you want to be able to SELECT which column in the SAP data has the > quantity. > what happens to the rest? > > I put together a userform that allows the user to select the sheet IN THE > CURRENT workbook. > it then populates the comboboxes with the sheets so that the user can > select the > material and quantity columns. > > it then runs a simplified consolidation script. > > You can try it using the Show_Form macro. > > > Paul > > > > -- > *From:* aju chacko > *To:* excel-macros@googlegroups.com > *Sent:* Thu, February 11, 2010 5:06:14 AM > *Subject:* Fwd: $$Excel-Macros$$ kindly help in modifying attached macro > > Any body in the group ,please help it's urgent OR give some guidelines in > accepting inputs from users so that existing code can be used > > aju v chacko > > > > -- Forwarded message -- > From: aju chacko > Date: Feb 10, 2010 5:44 PM > Subject: $$Excel-Macros$$ kindly help in modifying attached macro > To: excel-macros@googlegroups.com > > > *Dear vba gurus*, > Attached herewith a macro that made by friend to > compare two excel work sheets (SAP & PHY) in workbook,both are arranged as > table & *one common field (MATERIAL) *available in both sheets .What the > macro is doing that it create w.sheet named consolidated & then tabulate > *'quantity' field from sheet phy *against *'unrestricted' field* *in > w.sheet SAP* for the same *material* in two sheets.Similarly if a item in > *MATERIAL* item is not available in w.sheet *SAP*,but available in > w.sheet *PHY* that also will be brought to consolidated worksheet with > sap qty '*0'*.The difference of these two fields ( *unrestricted-**quantity) > in final column with heading 'difference'.Now this macro is HARD CODED so > that it work only when specified worksheets,specified column headers etc. > in specified order,What i required is a macro when it is executed ,accepts > some inputs from the user as shown belo**w * > > >> >> 1] User will be prompted to *select first & second work sheets to be >> compared* among the w.sheets in the active work book >> >> 2] Once he selected the w.book(s),he will be prompted to select *the >> common field from both the sheets* on which comparison to be made. >> >> 3] Finally he will be prompted to *select numerical fileds from both >> sheets* which is to be compared side by side >> >> Once he made these selections remaining process is same as what the >> attached macro is doing (summing numerical field for duplicate entries & >> eliminate duplicate entries ,final using vlookup function to find matches) >> *except the user selected values to be assigned against the hard coded >> variable name used in the macro*. >>Thanking you in advance, >> >>Aju v chacko >> >> > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com/ > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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@googlegroup
Re: $$Excel-Macros$$ Gift for you all...........
Amazing.Thanx Harmeet On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group.* > * > * > *Enjoy and keep up the good work.* > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- Regards Bharghav Ramdas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Gift for you all...........
On Thu, Feb 11, 2010 at 7:37 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group.* > * > * > *Enjoy and keep up the good work.* > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > Dear all, its really interesting file to listen music. Thanks to Mr. Harmeet. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. Mother Teresa:- If we cannot love the person whom we see, how can we love god, whom we cannot see ? P Save the environment, Do not print this message unless necessary -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Gift for you all...........
interesting tool please provide password to examine code so we may learn from your example. thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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: Excel Macros Free PDF
welcome to wonderful world of vba :) Unsure such a PDF exists (least I havent come across it yet myself) - however Excel's built-in VBA help provides a good starting place especially when coupled with Google for more examples, code fragments, tips/etc available from the numerous vba dedicated websites/forums (like this one). Another good starting point is your local library -- most have at least introductory books you can borrow to whet your hunger for more ... at which point Amazon/Barnes&Nobles/Borders become a destination in your unending quest for knowledge. On Feb 11, 1:09 am, Venkatesan c wrote: > Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ URGENT :Sumif Query
THANKS Aindril. But In Sumifs function it is not possible to have two
criteria(of = sign) on same range.
Any example would help.
The formula =sumifs("A:A","B:B","=12","B:B","=C") does not seems to be
working.
Regards,
Ayush Jain
On Feb 11, 8:37 am, Aindril De wrote:
> Hi Ayush,
>
> If you are using Exel 2007 then you can use Sumifs function, or otherwise
> you can use sumproduct function if you are using any version below 2007.
>
> Regards,
> Aindril
>
> On Wed, Feb 10, 2010 at 9:30 PM, Ayush wrote:
> > Dear Group,
>
> > I have a query on sumif function that if I would like to sum a range
> > based on two values of other range.
>
> > For example :
>
> > Column A = Amount
> > Column B = Product Line(12,15,CM,AS,AR,AJ etc.)
>
> > I want to sum column A if Column B = 12 or CM or AJ
>
> > the below is not working :
>
> > =sumif(A:A,B:B,"12,CM,AJ")
>
> > Any Help ?
>
> > The compounding of three sumif like = sumif(.) + sumif() +
> > sumif() is not I am looking for.
>
> > Thanks for advising.
>
> > Best regards,
> > Ayush Jain
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Re: Excel Macros Free PDF
And never underestimate the value of the macro recorder. The code may need a bit of cleaning up, but syntax is all there for you to take in, and reapply in your own code. Dave. > Date: Thu, 11 Feb 2010 18:53:53 -0800 > Subject: $$Excel-Macros$$ Re: Excel Macros Free PDF > From: jefgorb...@gmail.com > To: excel-macros@googlegroups.com > > welcome to wonderful world of vba :) > > Unsure such a PDF exists (least I havent come across it yet myself) - > however Excel's built-in VBA help provides a good starting place > especially when coupled with Google for more examples, code fragments, > tips/etc available from the numerous vba dedicated websites/forums > (like this one). > > Another good starting point is your local library -- most have at > least introductory books you can borrow to whet your hunger for > more ... at which point Amazon/Barnes&Nobles/Borders become a > destination in your unending quest for knowledge. > > > On Feb 11, 1:09 am, Venkatesan c wrote: > > Can I Have Excel Macros PDF Complete Guide > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 _ If it exists, you'll find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Excel Macros Free PDF
http://groups.google.com/group/excel-macros/files On 2/11/10, Venkatesan c wrote: > Can I Have Excel Macros PDF Complete Guide > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- Hari kumar Our strength grows out of our weaknesses. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Gift for you all...........
tx dude its rocking [?] -- Thanks HemanatH. On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group.* > * > * > *Enjoy and keep up the good work.* > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 <<330.gif>>
$$Excel-Macros$$ Fwd: Solution to your question 12,CM, AJ
Hello Shiv, Thanks so much for help & solution i am surprised to see that sumif function does not work this way. We have to use combination of sum & if function. Anyways thanks much. Best regards, Ayush Jain On Thu, Feb 11, 2010 at 10:47 PM, N.Shivkumar wrote: > Dear Sir > > Kindly see the attached sheet for the query you raised. > I am not sure whether this what you were looking for. > I may have used the longer route. Kindly enlighten me. > > Bye > > N.SHIVKUMAR > Mobile : +919866533180 > Office : +914027685310 > Res.: +914040035774 > Alternate Email: shiv1...@yahoo.com > > -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 Solution by N Shivkumar.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ URGENT :Sumif Query
Dear Sir
Kindly see the attached sheet for the query you raised.
I am not sure whether this what you were looking for.
I may have used the longer route. Kindly enlighten me.
With regards
Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
On 12 February 2010 09:20, Ayush wrote:
> THANKS Aindril. But In Sumifs function it is not possible to have two
> criteria(of = sign) on same range.
>
> Any example would help.
>
> The formula =sumifs("A:A","B:B","=12","B:B","=C") does not seems to be
> working.
>
> Regards,
> Ayush Jain
>
> On Feb 11, 8:37 am, Aindril De wrote:
> > Hi Ayush,
> >
> > If you are using Exel 2007 then you can use Sumifs function, or otherwise
> > you can use sumproduct function if you are using any version below 2007.
> >
> > Regards,
> > Aindril
> >
> > On Wed, Feb 10, 2010 at 9:30 PM, Ayush wrote:
> > > Dear Group,
> >
> > > I have a query on sumif function that if I would like to sum a range
> > > based on two values of other range.
> >
> > > For example :
> >
> > > Column A = Amount
> > > Column B = Product Line(12,15,CM,AS,AR,AJ etc.)
> >
> > > I want to sum column A if Column B = 12 or CM or AJ
> >
> > > the below is not working :
> >
> > > =sumif(A:A,B:B,"12,CM,AJ")
> >
> > > Any Help ?
> >
> > > The compounding of three sumif like = sumif(.) + sumif() +
> > > sumif() is not I am looking for.
> >
> > > Thanks for advising.
> >
> > > Best regards,
> > > Ayush Jain
> >
> > > --
> >
> > >
> --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> > >http://www.excelitems.com
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://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
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 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
Solution by N Shivkumar.xls
Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ need your help
Hi Shammi, I am not sure if I have understood your query correctly. This is what I have done: > On the basis of the total score, the Band in the range G11 to H15 will be highlighted with blue color. > The amount of proposed growth on the basis of percentage relevant to to Band # would be reflected in Cell - I11 > Total amount (Basic + Growth) would be reflected in Result - D17. Please see the attached file and advise if this is what you are looking for. Cheers ! AJ On Thu, Feb 11, 2010 at 7:54 PM, shammi shrivastav < shammi.shrivas...@gmail.com> wrote: > friends please go through the attached file and help me. For about an hour > I am fiddling with this. what I want: > > based on the value in cell K8; the corresponding band level should be > highlighted automatically and a final result is available after all the > calculations corresponding to the relevent basic and band > > regards > > -- > shammi shrivastav > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 Evaluation Sheet - Shammi.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ I lossed my password how to recover that
Please help me friends... I need that very badly On Thu, Feb 11, 2010 at 8:04 PM, Puttu wrote: > Hi Team, > > Can any hlep me how recover my password, I lossed it. If i want to > attach let me know how can i attach to this blog? > > Thanks > Putta > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ I lossed my password how to recover that
se send the file I will do it On Fri, Feb 12, 2010 at 11:47 AM, Puttaswamy wrote: > Please help me friends... I need that very badly > > > On Thu, Feb 11, 2010 at 8:04 PM, Puttu wrote: > >> Hi Team, >> >> Can any hlep me how recover my password, I lossed it. If i want to >> attach let me know how can i attach to this blog? >> >> Thanks >> Putta >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 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 >> > > > > -- > Putta > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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 > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) plea -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ I lossed my password how to recover that
attach file On Thu, Feb 11, 2010 at 8:04 PM, Puttu wrote: > Hi Team, > > Can any hlep me how recover my password, I lossed it. If i want to > attach let me know how can i attach to this blog? > > Thanks > Putta > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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
