Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[NOORAIN ANSARI]

Hey Ayush..

As per my Idea :

1. Exlsolution.com
2. EXL-WORLD.com
3. EXL-Garden.com
4. EXL-Station.Com

Thanks & regards,
Noorain Ansari
On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain  wrote:

> Dear members,
>
> I am too excited to share that discussexcel.com website development is in
> good progress and we are ready to launch the website on 4th Anniversary of
> our Google group. i.e. 16th -17th March.
>
> In the meantime, Can you advise a good tagline, punchline for website.
>
> My thoughts are :
> 1) building excel-lence
> 2) Excellence in Excel
> 3) Let's discuss and learn excel
>
> what do you think, Let me know
>
> Keep watching this space for more
>
> Regards
> Ayush Jain
> Group Manager.
>
> --
>
> --
> 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

-- 
--
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$$ nakshtra querry

[§»VIPER«§]

Hi

Due to some work pressure i didn't seen your query. find the attachment.
and i cannot able to understand your new query. can you make it clear
please?


-- 
*Thanks & Regards

Thamu
*





On Tue, Mar 1, 2011 at 11:39 AM, Nemi Gandhi  wrote:

> i had put the above querry, but now i have found the solution, so for
> benefit of excel users, posting once again with solution. further, one more
> querry is put. Please help?
>
> --
> Nemi Gandhi
> 98204 92963
>
>  --
>
> --
> 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$$ New Web Query get data from existing open IE Browser instead of opening new browser window

[Kishan Reddy, K]

Send me the generated code, let me try it. (replace the username and
password with X).


Regards,
Kishan Reddy, K

On Feb 17, 10:39 pm, ashish koul  wrote:
>  write
> on error resume next
>  on the line above in the code which is giving errors see if that helps
>
>
>
> On Thu, Feb 17, 2011 at 8:17 PM, RCGUA  wrote:
> > With Microsoft Excel 2003, using the "Web Query" feature, I record a
> > macro, put the URL of the website into the New Web Query and that
> > opens a new instance of Internet Explorer.  Using the Web Query, I go
> > to a specific table within the tables on the web page and select the
> > table that I want to get the data from and the Web Query copies the
> > data and pastes it into Excel.  The website that I am getting the data
> > from requires a login and password.  I wrote some VBA code to send the
> > username and password and that works at first, however, if I use this
> > web query several times in one day and after using the Web Query
> > several times, I am logged into that website many times and I begin
> > getting error messages and the Web Query does not grab any data.
>
> > Is it possible for the Web Query to to switch to the existing, already
> > opened and logged into IE and grab that data and paste it into Excel,
> > instead of opening a new browser window every time the query is run?
>
> > Or, if that is not possible, is it possible, to run the macro that
> > uses the login and password, but then, after copying the data, have
> > the query automatically logout and close the new instance of IE?
>
> > --
>
> > --
> > 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 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.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

$$Excel-Macros$$ nakshtra querry

[Nemi Gandhi]

i had put the above querry, but now i have found the solution, so for
benefit of excel users, posting once again with solution. further, one more
querry is put. Please help?

-- 
Nemi Gandhi
98204 92963

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


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

Re: $$Excel-Macros$$ To Reconcile Two Reports

[ashish koul]

can you send the report on which you want to apply the formulae




On Tue, Mar 1, 2011 at 10:56 AM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:

> Can somebody help please
>
>
> -- Forwarded message --
> From: kurikkal padinjarappalla 
> Date: Mon, Feb 28, 2011 at 12:40 PM
> Subject: Re: $$Excel-Macros$$ To Reconcile Two Reports
> To: excel-macros@googlegroups.com
> Cc: Mahesh parab , ashish koul 
>
>
>
> Dear Mahesh,
>
> Thanks for your reply,
>
> I have tried using this, but it does not generated a proper output, it may
> due to the way I used it, please find the attached sheet showing the result
> which i got, and please rectify me where i did mistake.
>
> Regards,
> Kurikkal.
>
> On Sun, Feb 27, 2011 at 9:13 PM, Mahesh parab  wrote:
>
>> Dear All
>>
>> find attach Add in which compare two worksheet as well sheets in two
>> workbook & display results
>>
>>   On Sun, Feb 27, 2011 at 9:33 PM, ashish koul wrote:
>>
>>>
>>> try this
>>>
>>>
>>>
>>> On Sun, Feb 27, 2011 at 8:30 PM, kurikkal padinjarappalla <
>>> padinjarappa...@gmail.com> wrote:
>>>
 Dear All,

 Can somebody create a macro to compare two reports, like result gets in
 pivot table, only difference is it should show a remark column also.

 Please find the attached sample.

 Thanks in advance.

 Kurikkal.

 --

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

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.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 : 

Fwd: $$Excel-Macros$$ To Reconcile Two Reports

[kurikkal padinjarappalla]

Can somebody help please

-- Forwarded message --
From: kurikkal padinjarappalla 
Date: Mon, Feb 28, 2011 at 12:40 PM
Subject: Re: $$Excel-Macros$$ To Reconcile Two Reports
To: excel-macros@googlegroups.com
Cc: Mahesh parab , ashish koul 



Dear Mahesh,

Thanks for your reply,

I have tried using this, but it does not generated a proper output, it may
due to the way I used it, please find the attached sheet showing the result
which i got, and please rectify me where i did mistake.

Regards,
Kurikkal.

On Sun, Feb 27, 2011 at 9:13 PM, Mahesh parab  wrote:

> Dear All
>
> find attach Add in which compare two worksheet as well sheets in two
> workbook & display results
>
> On Sun, Feb 27, 2011 at 9:33 PM, ashish koul wrote:
>
>>
>> try this
>>
>>
>>
>> On Sun, Feb 27, 2011 at 8:30 PM, kurikkal padinjarappalla <
>> padinjarappa...@gmail.com> wrote:
>>
>>> Dear All,
>>>
>>> Can somebody create a macro to compare two reports, like result gets in
>>> pivot table, only difference is it should show a remark column also.
>>>
>>> Please find the attached sample.
>>>
>>> Thanks in advance.
>>>
>>> Kurikkal.
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.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


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

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[Maries]

Dear Ayush,

Find below My suggestions:

==> *Excel World* or *Xcel Duniya*

==> *Excel Inspiration* or *Xcel Inspiration*
Rgds,

Maries.

On Mon, Feb 28, 2011 at 9:14 PM, Ayush Jain  wrote:

> Thanks Dave & Aindril for awesome ideas
>
> i will share the final one soon :)
>
> Regards
>
>
> On Mon, Feb 28, 2011 at 4:09 PM, Aindril De  wrote:
>
>> Hi Ayush,
>>
>> How about   XLS
>> (Excel Simplified in Short)
>>
>> Andy
>>
>>
>> On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack <
>> davebonall...@hotmail.com> wrote:
>>
>>> Hi Ayush,
>>> Perhaps you could play with the word 'Accelerate'
>>> Some suggestions would be:
>>>
>>> Excelerated Learning
>>> Excelerated Solutions
>>> Excelerating.com
>>> Exlceleration.com
>>> Excelerate.com
>>>
>>> Regards - Dave.
>>>
>>>
>>> --
>>> From: jainayus...@gmail.com
>>> Date: Mon, 28 Feb 2011 11:07:31 +0530
>>>
>>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>>> To: excel-macros@googlegroups.com
>>>
>>> Thanks Akash, This is pity cool and short...
>>> I liked it.
>>>
>>> On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha wrote:
>>>
>>>   Hey Ayush,
>>>
>>> What About 'SIMPLEXCEL'???
>>>
>>> Regards,
>>>
>>> Aakash.
>>>
>>> --- On *Mon, 2/28/11, Ayush Jain * wrote:
>>>
>>>
>>> From: Ayush Jain 
>>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>>> To: excel-macros@googlegroups.com
>>> Cc: "Dilip Pandey" 
>>> Date: Monday, February 28, 2011, 10:12 AM
>>>
>>>   Thank You Dilip...Awesome Tag Lines.
>>>
>>> I have shortlisted two taglines from all :
>>> 1) Excel Simplified
>>> 2) Helping the world to Excel in their professional life
>>>
>>> Group, Its not finalized, so you can submit more.
>>>
>>> Regards
>>> Ayush Jain
>>>
>>>
>>> On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey 
>>> http://mc/compose?to=dilipan...@gmail.com>
>>> > wrote:
>>>
>>> Hi Ayush,
>>>
>>> Few Taglines from my side:-
>>>
>>> Helping the world to Excel in their professional life
>>>
>>> Excelling in Excel
>>>
>>> Excel becomes Easy here..!!
>>>
>>> Best Regards,
>>> DILIPandey
>>>
>>> On 2/22/11, Ayush Jain 
>>> http://mc/compose?to=jainayus...@gmail.com>>
>>> wrote:
>>> > Dear members,
>>> >
>>> > I am too excited to share that discussexcel.com website development is
>>> in
>>> > good progress and we are ready to launch the website on 4th Anniversary
>>> of
>>> > our Google group. i.e. 16th -17th March.
>>> >
>>> > In the meantime, Can you advise a good tagline, punchline for website.
>>> >
>>> > My thoughts are :
>>> > 1) building excel-lence
>>> > 2) Excellence in Excel
>>> > 3) Let's discuss and learn excel
>>> >
>>> > what do you think, Let me know
>>> >
>>> > Keep watching this space for more
>>> >
>>> > Regards
>>> > Ayush Jain
>>> > Group Manager.
>>> >
>>> > --
>>> >
>>> --
>>> > 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,
>>>
>>> DILIP KUMAR PANDEY, mvp
>>>   MBA,B.Com(Hons),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com 
>>> dilipan...@yahoo.com 
>>> New Delhi - 62, India
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>>
>>>
>>>
>>> --
>>> 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. Join our

RE: $$Excel-Macros$$ Insert row based on criteria

[Pehrson, Dave]

Ashish,

 

This works great,  I'm just beginning to learn the basics of VB,  To a
newbie like me, the code seems strange, if you have a minute could you
explain what your simple commands are doing.  Maybe I can learn to
expand for other options.

 

Again, thanks for your help and support.

 

Dave

 

From: ashish koul [mailto:koul.ash...@gmail.com] 
Sent: Saturday, February 26, 2011 10:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert row based on criteria

 

hi dave

Sub newrow()


Dim i As Long

For i = Sheets(1).Range("a1").End(xlDown).Row To 2 Step -1

If Right(Sheets(1).Cells(i, 1).Value, 5) = "Total" Then

Sheets(1).Cells(i + 1, 1).EntireRow.Select

Selection.Insert Shift:=xlDown

End If
Next i


End Sub





On Sun, Feb 27, 2011 at 2:38 AM, Diamond Dave 
wrote:

I'm also trying it insert a row, but in my example, I want to insert
in after the "SubTotal" after using the "subtotal function" adding the
blank row after the subtotal line.  How would you modify the macro in
your example to accomplish this?

Dave


On Feb 26, 12:44 am, Mahesh parab  wrote:
> Hi Jason
>
> find attach, hope this will help
> if u use left function then its matching with u r group criteria
>
> Sub Mxm()
> Dim LR As Long, i As Long
> LR = Range("A" & Rows.Count).End(xlUp).Row
> For i = LR To 3 Step -1
> If Left(Range("A" & i).Value, 2) <> Left(Range("A" & i - 1).Value,
2)
> Then Rows(i).Insert
> Next i
> End Sub
>
>
>

> On Fri, Feb 25, 2011 at 7:21 PM, Jason Henke 
wrote:
> > Hello,
>
> > In the attached file I have provided an example of what I am trying
to
> > accomplish via macros.
>
> > I import a report into excel that changes each time it's ran. I'm
trying to
> > put a space after each 'group' is ran. As an example we have
locations set
> > up as
> > A-A-0
> > A-A-1 ect..to A-C-3
>
> > B-A-0 to B-F-3
>
> > more data in sheet to show. I would like to insert a row after each
area.
> > So A-A-0 to A-C-3 would be one group. B-A-0 - B-F-3 is another. Not
all
> > these locations will show when the report runs. If needed I can
provide a
> > list of every location that I need this data to sort by (and I can
provide
> > groups).
>
> > Once the rows are inserted I will be running a macro to place page
breaks
> > after each blank row.. this I already have though.
>
> > Regards,
> > Jason
>
> > --
>
> >

---
> > 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 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
>
>

>  insert_rows_Solutionm.xls
> 62KViewDownload- Hide quoted text -
>
> - Show quoted text -


--

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




-- 

Regards

 

Ashish Koul

akoul.blogspot.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

Re: $$Excel-Macros$$ Nakshtra querry

[§»VIPER«§]

Hi

Find the attachment

-- 
*Thanks & Regards

Thamu
*

On Wed, Feb 23, 2011 at 3:06 PM, Nemi Gandhi  wrote:

> file is attached. Please help.
>
> --
> Nemi Gandhi
> 98204 92963
>
>  --
>
> --
> 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$$ 20 days Left : Here is first Look of discussexcel.com

[Vikash Chandra]

Hi ayush,
it's very good  & well designedkeep it up Ayush
Thanx for your initiative

Regards,
Vikash Chandra
Bangalore
9902622922

-- 
--
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$$ 20 days Left : Here is first Look of discussexcel.com

[Dhartikumar Sahu]

it's good product & well designedkeep it up Ayush

Dhartikumar Sahu
Sr.Database Manager - Equity Research
9920342276

On Tue, Mar 1, 2011 at 1:01 AM, Indrajit $nai wrote:

> *Great going Ayush*
>
>
> On Mon, Feb 28, 2011 at 5:53 PM, sudhir kumar wrote:
>
>> It is best.
>>
>>
>> On 24 February 2011 18:38, Ayush  wrote:
>>
>>>  
>>> Dear Group,
>>>
>>> I have completed the designing part and here is the first look of
>>> website. The content development is in progress.
>>> Please let me know if you have any feedback , suggestions on same.
>>>
>>> Many Thanks.
>>>
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
>> Sudhir Verma
>> Asstt. Mngr. A/c's
>> 9818479722
>> *
>> P think Before you print
>> *
>> *
>> **
>> Life is Very beautiful !!!
>> *
>> *
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>>  `•.¸.•´.
>> *
>> *
>>  *
>>  *Happy **Valentine** Day  *
>>  \ ¦ /
>> (ò ó)
>> _ ___o0o___(_)___o0o__
>> ___¦_¦_¦_¦_¦
>> ¦_¦_¦_¦_¦__
>> ___¦_¦_¦_¦_¦
>> *Drink Bear Save Water*
>> **
>>
>>  --
>>
>> --
>> 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
>>
>
>
>
> --
> Indrajit Snai
> +91 9051755745
> talk2indra...@gmail.com
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
>
> --
> 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$$ Export Data

[Vikas Chouhan]

HI Expats,

Greeting for New Day !!!

I want to export data from mysql to .csv format. just want to click in
command button and data save to define location..

it's very urgent so pls help me !


-- 
One Team One Dream One Goal

Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_*ccess *without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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$$ 20 days Left : Here is first Look of discussexcel.com

[Indrajit $nai]

*Great going Ayush*


On Mon, Feb 28, 2011 at 5:53 PM, sudhir kumar  wrote:

> It is best.
>
>
> On 24 February 2011 18:38, Ayush  wrote:
>
>>  
>> Dear Group,
>>
>> I have completed the designing part and here is the first look of website.
>> The content development is in progress.
>> Please let me know if you have any feedback , suggestions on same.
>>
>> Many Thanks.
>>
>>
>> Regards
>> Ayush Jain
>> Group Manager
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
>  *
>  *Happy **Valentine** Day  *
>  \ ¦ /
> (ò ó)
> _ ___o0o___(_)___o0o__
> ___¦_¦_¦_¦_¦
> ¦_¦_¦_¦_¦__
> ___¦_¦_¦_¦_¦
> *Drink Bear Save Water*
> **
>
>  --
>
> --
> 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
>



-- 
Indrajit Snai
+91 9051755745
talk2indra...@gmail.com

Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful.

-- 
--
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$$ regd: drop down button

[Mahesh parab]

Hi Thamu

well done !
On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§  wrote:

> HI Naresh,
>
> Have look at this, i did something by using function,
> find the attachment.
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
>
> On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR <
> sajidmansooral...@gmail.com> wrote:
>
>> Why are you using this lengthy formula?
>> =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
>> instead of
>> =INDIRECT($B$15)   (Working Fine as above one)
>>
>>
>> On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote:
>>
>>> Hi Naresh,
>>>
>>> Please check the attached file for required solution.
>>>
>>> I have used Name definition manager, data validation with V-lookup
>>> option to achieve the desired result.
>>>
>>> Thanks & Regards,
>>> DILIPandey
>>>
>>>
>>> On 2/25/11, naresh v  wrote:
>>> > Hi Experts,
>>> >
>>> > I need some help regarding drop downs.
>>> >
>>> >Please find the attached sheet for your reference.
>>> >
>>> >Please help me in this regard.
>>> >
>>> >
>>> >
>>> > Thanks and Regards,
>>> > Naresh V
>>> >
>>> > --
>>> >
>>> --
>>> > 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,
>>>
>>> DILIP KUMAR PANDEY, mvp
>>>   MBA,B.Com(Hons),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 62, India
>>>
>>> --
>>>
>>> --
>>> 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
>

-- 
--
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$$ Fwd: I repeat again, anyone can help me?

[ashish koul]

try this


Sub Macro1()
Dim s, y  As Range
Set s = Sheets("PivoTTable").UsedRange
 For Each y In s
 If y.Value >= 0 And Not IsEmpty(y.Value) Then

  If IsNumeric(y.Value) Then


 y.ShowDetail = True
 End If
 End If

 Next y


'Range("E13").Select
'Selection.ShowDetail = True
End Sub



On Mon, Feb 28, 2011 at 9:54 PM, ChilExcel  wrote:

> attached file
>
> Thx
>
>
>
>
> -- Forwarded message --
> From: ChilExcel 
> Date: 2011/2/28
> Subject: I repeat again, anyone can help me?
> To: excel-macros@googlegroups.com
>
>
> I need to extract dynamic table, named worksheet
> or book name (for each double click)
>
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.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

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[Ayush Jain]

Thanks Dave & Aindril for awesome ideas

i will share the final one soon :)

Regards

On Mon, Feb 28, 2011 at 4:09 PM, Aindril De  wrote:

> Hi Ayush,
>
> How about   XLS
> (Excel Simplified in Short)
>
> Andy
>
>
> On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack <
> davebonall...@hotmail.com> wrote:
>
>>  Hi Ayush,
>> Perhaps you could play with the word 'Accelerate'
>> Some suggestions would be:
>>
>> Excelerated Learning
>> Excelerated Solutions
>> Excelerating.com
>> Exlceleration.com
>> Excelerate.com
>>
>> Regards - Dave.
>>
>>
>> --
>> From: jainayus...@gmail.com
>> Date: Mon, 28 Feb 2011 11:07:31 +0530
>>
>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>> To: excel-macros@googlegroups.com
>>
>> Thanks Akash, This is pity cool and short...
>> I liked it.
>>
>> On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha wrote:
>>
>>   Hey Ayush,
>>
>> What About 'SIMPLEXCEL'???
>>
>> Regards,
>>
>> Aakash.
>>
>> --- On *Mon, 2/28/11, Ayush Jain * wrote:
>>
>>
>> From: Ayush Jain 
>> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
>> To: excel-macros@googlegroups.com
>> Cc: "Dilip Pandey" 
>> Date: Monday, February 28, 2011, 10:12 AM
>>
>>   Thank You Dilip...Awesome Tag Lines.
>>
>> I have shortlisted two taglines from all :
>> 1) Excel Simplified
>> 2) Helping the world to Excel in their professional life
>>
>> Group, Its not finalized, so you can submit more.
>>
>> Regards
>> Ayush Jain
>>
>>
>> On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey 
>> http://mc/compose?to=dilipan...@gmail.com>
>> > wrote:
>>
>> Hi Ayush,
>>
>> Few Taglines from my side:-
>>
>> Helping the world to Excel in their professional life
>>
>> Excelling in Excel
>>
>> Excel becomes Easy here..!!
>>
>> Best Regards,
>> DILIPandey
>>
>> On 2/22/11, Ayush Jain 
>> http://mc/compose?to=jainayus...@gmail.com>>
>> wrote:
>> > Dear members,
>> >
>> > I am too excited to share that discussexcel.com website development is
>> in
>> > good progress and we are ready to launch the website on 4th Anniversary
>> of
>> > our Google group. i.e. 16th -17th March.
>> >
>> > In the meantime, Can you advise a good tagline, punchline for website.
>> >
>> > My thoughts are :
>> > 1) building excel-lence
>> > 2) Excellence in Excel
>> > 3) Let's discuss and learn excel
>> >
>> > what do you think, Let me know
>> >
>> > Keep watching this space for more
>> >
>> > Regards
>> > Ayush Jain
>> > Group Manager.
>> >
>> > --
>> >
>> --
>> > 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,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com 
>> dilipan...@yahoo.com 
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> 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
>>
>>
>>
>>
>> --
>> 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. 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 o

$$Excel-Macros$$ Fwd: I repeat again, anyone can help me?

[ChilExcel]

attached file

Thx




-- Forwarded message --
From: ChilExcel 
Date: 2011/2/28
Subject: I repeat again, anyone can help me?
To: excel-macros@googlegroups.com


I need to extract dynamic table, named worksheet
or book name (for each double click)




-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

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


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

$$Excel-Macros$$ I repeat again, anyone can help me?

[ChilExcel]

I need to extract dynamic table, named worksheet
or book name (for each double click)

-- 
--
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$$ Urgent required help in excel

[Jitender kumar]

Dear Excel Guru/Ashish/Dilip


Thanks for your valuable solution.But the problem is still here, Because I
want to print it according to MRP & Dcode wise on different sheet of
paper(Pivot table can doit), I know page break works but doing page break on
every dcode and MRP is very tough task wwhen data is too large.Pivot table
has ability to do it, so that is why i want it in Pivot table. Only drawback
that i told in sheet that I want MRP against each item and qty, but PIVOT
only summarizes the data so I cannot repeat MRP on each row of PIVOT.Plz
help .How it possible using PIVOT/VBA

Regards

Jitender

On 27 February 2011 23:27, Dilip Pandey  wrote:

> Hi Jitender,
>
> I think you are 90% done.
> After Pivot table is done, you should copy -> paste the data on its
> location itself and select the MRP column, F5, Select Blanks, = sign,
> up arrow, Ctrl + Enter.
>
> The above steps can also be automated where after the pivot, all the
> steps can be achieved through macro code.
>
> Best Regards,
> DILIPandey
>
> On 2/23/11, Jitender kumar  wrote:
> > Dear ExcelGurus
> >
> > I  need help in attached file, problem told in excel sheet.Please help me
> in
> > pivot /VBA only
> >
> > Thanks
> >
> > Jitender
> >
> > --
> >
> --
> > 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,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>

-- 
--
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$$ regd: drop down button

[naresh v]

Thanks Thammu, Anil and Dilip.



On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR
 wrote:
> Why are you using this lengthy formula?
> =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
> instead of
> =INDIRECT($B$15)   (Working Fine as above one)
>
> On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey  wrote:
>>
>> Hi Naresh,
>>
>> Please check the attached file for required solution.
>>
>> I have used Name definition manager, data validation with V-lookup
>> option to achieve the desired result.
>>
>> Thanks & Regards,
>> DILIPandey
>>
>>
>> On 2/25/11, naresh v  wrote:
>> > Hi Experts,
>> >
>> >             I need some help regarding drop downs.
>> >
>> >            Please find the attached sheet for your reference.
>> >
>> >            Please help me in this regard.
>> >
>> >
>> >
>> > Thanks and Regards,
>> > Naresh V
>> >
>> > --
>> >
>> > --
>> > 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,
>>
>> DILIP KUMAR PANDEY, mvp
>>       MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> 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$$ regd: drop down button

[rakesh kumar]

How does that drop down button auto hides. Could you please tell me ? How do
I place same in my excel sheet.

Regards

On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§  wrote:

> at this, i did something by using function,
> find the attachment.
>



-- 
  Rakesh kumar khowal
 +91 9540084660
 +91 9868532105

-- 
--
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: Fomula to find the Missing Numbers in the sequence - Reg

[saggi]

Insert new column then use this formula in column C
=RIGHT(B3,3)

=IF(C2-C1=1,"","missing")

Regards
Saggi

-- 
--
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$$ Fomula to find the Missing Numbers in the sequence - Reg

[§»VIPER«§]

Hi Prathap,

Here is the solution. Find the attachment.

-- 
*Thanks & Regards

Thamu
*

On Mon, Feb 28, 2011 at 2:28 PM, Prathap  wrote:

> Dear All,
>
>
> I have an excel sheet in which i need to find the missing numbers in the
> sequence. Please help me with the formula to identify missing numbers in a
> list of consecutive numbers.
>
> Example :
>
> Best Regards,
> Prathap
>
> --
>
> --
> 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


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

Re: $$Excel-Macros$$ To Reconcile Two Reports

[kurikkal padinjarappalla]

Dear Mahesh,

Thanks for your reply,

I have tried using this, but it does not generated a proper output, it may
due to the way I used it, please find the attached sheet showing the result
which i got, and please rectify me where i did mistake.

Regards,
Kurikkal.

On Sun, Feb 27, 2011 at 9:13 PM, Mahesh parab  wrote:

> Dear All
>
> find attach Add in which compare two worksheet as well sheets in two
> workbook & display results
>
> On Sun, Feb 27, 2011 at 9:33 PM, ashish koul wrote:
>
>>
>> try this
>>
>>
>>
>> On Sun, Feb 27, 2011 at 8:30 PM, kurikkal padinjarappalla <
>> padinjarappa...@gmail.com> wrote:
>>
>>> Dear All,
>>>
>>> Can somebody create a macro to compare two reports, like result gets in
>>> pivot table, only difference is it should show a remark column also.
>>>
>>> Please find the attached sample.
>>>
>>> Thanks in advance.
>>>
>>> Kurikkal.
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.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


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

Re: $$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence - Reg

[Mukesh Kumar Jha]

Hi Prathap,

Please find attached sheet, hope it will help you.

Thanks
Mukesh
  - Original Message - 
  From: Prathap 
  To: excel-macros@googlegroups.com 
  Sent: Monday, February 28, 2011 2:28 PM
  Subject: $$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence 
- Reg


  Dear All,


  I have an excel sheet in which i need to find the missing numbers in the 
sequence. Please help me with the formula to identify missing numbers in a list 
of consecutive numbers.

  Example : 

  Best Regards,
  Prathap

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


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

$$Excel-Macros$$ Hi All,

[Kishor Kumar Singh]

Hi friends,

I want make a software for Corrupted Excel  Files . Please Suggest me It's
Good or Bad as per depend on current Industry value. Can it success in the
current position. I have  request to you all people . please give me your
advice.

-- 
With Regards,

Kishor Kumar Singh
Sr.Software Developer
Touch Wood Technologies
(Software Development & Consultancy)
Gurgaon (Haryana), INDIA - 122001
Web   : http://twt.co.in/
  : http://www.touchwoodtech.in/

-- 
--
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$$ 20 days Left : Here is first Look of discussexcel.com

[sudhir kumar]

It is best.

On 24 February 2011 18:38, Ayush  wrote:

> 
> Dear Group,
>
> I have completed the designing part and here is the first look of website.
> The content development is in progress.
> Please let me know if you have any feedback , suggestions on same.
>
> Many Thanks.
>
>
> Regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> 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
>



-- 
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.
*
*
*
 *Happy **Valentine** Day  *
 \ ¦ /
(ò ó)
_ ___o0o___(_)___o0o__
___¦_¦_¦_¦_¦
¦_¦_¦_¦_¦__
___¦_¦_¦_¦_¦
*Drink Bear Save Water*
**

-- 
--
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$$ 22 days left - Launch of discussexcel.com

[Aindril De]

Hi Ayush,

How about   XLS
(Excel Simplified in Short)

Andy

On Mon, Feb 28, 2011 at 12:42 PM, Dave Bonallack
wrote:

>  Hi Ayush,
> Perhaps you could play with the word 'Accelerate'
> Some suggestions would be:
>
> Excelerated Learning
> Excelerated Solutions
> Excelerating.com
> Exlceleration.com
> Excelerate.com
>
> Regards - Dave.
>
>
> --
> From: jainayus...@gmail.com
> Date: Mon, 28 Feb 2011 11:07:31 +0530
>
> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
> To: excel-macros@googlegroups.com
>
> Thanks Akash, This is pity cool and short...
> I liked it.
>
> On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha wrote:
>
>   Hey Ayush,
>
> What About 'SIMPLEXCEL'???
>
> Regards,
>
> Aakash.
>
> --- On *Mon, 2/28/11, Ayush Jain * wrote:
>
>
> From: Ayush Jain 
> Subject: Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
> To: excel-macros@googlegroups.com
> Cc: "Dilip Pandey" 
> Date: Monday, February 28, 2011, 10:12 AM
>
>   Thank You Dilip...Awesome Tag Lines.
>
> I have shortlisted two taglines from all :
> 1) Excel Simplified
> 2) Helping the world to Excel in their professional life
>
> Group, Its not finalized, so you can submit more.
>
> Regards
> Ayush Jain
>
>
> On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey 
> http://mc/compose?to=dilipan...@gmail.com>
> > wrote:
>
> Hi Ayush,
>
> Few Taglines from my side:-
>
> Helping the world to Excel in their professional life
>
> Excelling in Excel
>
> Excel becomes Easy here..!!
>
> Best Regards,
> DILIPandey
>
> On 2/22/11, Ayush Jain 
> http://mc/compose?to=jainayus...@gmail.com>>
> wrote:
> > Dear members,
> >
> > I am too excited to share that discussexcel.com website development is
> in
> > good progress and we are ready to launch the website on 4th Anniversary
> of
> > our Google group. i.e. 16th -17th March.
> >
> > In the meantime, Can you advise a good tagline, punchline for website.
> >
> > My thoughts are :
> > 1) building excel-lence
> > 2) Excellence in Excel
> > 3) Let's discuss and learn excel
> >
> > what do you think, Let me know
> >
> > Keep watching this space for more
> >
> > Regards
> > Ayush Jain
> > Group Manager.
> >
> > --
> >
> --
> > 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,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com 
> dilipan...@yahoo.com 
> New Delhi - 62, India
>
> --
>
> --
> 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
>
>
>
>
> --
> 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. 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
>
>
>
>
>
> --
> Best regards,
> Ayush Jain
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
>

$$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence - Reg

[Prathap]

Dear All,


I have an excel sheet in which i need to find the missing numbers in the
sequence. Please help me with the formula to identify missing numbers in a
list of consecutive numbers.

Example :

Best Regards,
Prathap

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


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

Re: $$Excel-Macros$$ Multi User in Excel file

[§»VIPER«§]

Sajid

Tools > Share Workbook


-- 
*Thanks & Regards

Thamu
*


On Sun, Feb 27, 2011 at 10:38 PM, Dilip Pandey  wrote:

> Hi Sajid,
>
> Yes, it can be done.
> Share your file and provide the LAN path of the file to all the
> respective users.  Sharing of the file (workbook) will allow all the
> users to enter data in the file at the same time.
> Other options for customization and security would be to allow users
> to edit ranges.
>
>
> Best Regards,
> DILIPandey
>
> On 2/26/11, SAJID MEMON  wrote:
> >
> > Dear All Experts,
> >
> > I have LAN in my office and want to type in a excel file (Example :
> abc.xls)
> > data. Can other person type in same file entering data like Multi User.
> >
> > Plz give me tips
> >
> > awaiting your positive responce.
> >
> > Regards
> >
> > Sajid Memon
> >
> >
> > --
> >
> --
> > 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,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> 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$$ regd: drop down button

[§»VIPER«§]

HI Naresh,

Have look at this, i did something by using function,
find the attachment.

-- 
*Thanks & Regards

Thamu
*

On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR  wrote:

> Why are you using this lengthy formula?
> =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0))
> instead of
> =INDIRECT($B$15)   (Working Fine as above one)
>
>
> On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote:
>
>> Hi Naresh,
>>
>> Please check the attached file for required solution.
>>
>> I have used Name definition manager, data validation with V-lookup
>> option to achieve the desired result.
>>
>> Thanks & Regards,
>> DILIPandey
>>
>>
>> On 2/25/11, naresh v  wrote:
>> > Hi Experts,
>> >
>> > I need some help regarding drop downs.
>> >
>> >Please find the attached sheet for your reference.
>> >
>> >Please help me in this regard.
>> >
>> >
>> >
>> > Thanks and Regards,
>> > Naresh V
>> >
>> > --
>> >
>> --
>> > 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,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> 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


LIST USING FUNCTION.xls
Description: MS-Excel spreadsheet