$$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

[Venkatesan c]

Dear All,

I have attached sheet contains my query on Data Validation - Create a drop
down list containing only unique


-- 
*Best Regards,*
*Venkat*
*
*
*
*

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


Create a drop down list containing only unique.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Login Logout Report Help Required...

[Venkatesan c]

It's Working Daniel ...Thanks a lot.


*Best Regards,*

*Venkat*

On Sat, Jul 23, 2011 at 8:19 PM, Daniel  wrote:

> Hi,
>
> ** **
>
> Run the following macro :
>
> ** **
>
> Sub LoginLogout()
>
> Dim c As Range
>
> Range([L3], Cells(Rows.Count, "I").End(xlUp)).ClearContents
>
> Range([A1], Cells(Rows.Count, 3).End(xlUp)).AdvancedFilter
> xlFilterCopy, , [I2:K2], Unique:=True
>
> Range([L3], Cells(Rows.Count, "I").End(xlUp)).Sort key1:=[I2],
> order1:=xlAscending, _
>
> key2:=[K2], order2:=xlAscending
>
> Range([I3], Cells(Rows.Count, "I").End(xlUp)).Offset(, 3).FormulaR1C1 =
> _
>
> "=IF(RC[-2]=""Log In"",R[+1]C[-1]-RC[-1],"""")"
>
> Range([L3], Cells(Rows.Count, "I").End(xlUp)).Subtotal GroupBy:=1,
> Function:=xlSum, TotalList:=Array(4), _
>
> Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
> For Each c In Range([I3], Cells(Rows.Count, "I").End(xlUp))
>
> If Left(c.Value, 5) = "Total" Then
>
> c.Value = ""
>
> c.Offset(, 2).Value = "Total Login Hrs"
>
> c.Offset(, 2).Resize(, 2).NumberFormat = "[h]:mm:ss"
>
>     c.Offset(, 2).Resize(, 2).Font.Bold = True
>
> End If
>
> Next c
>
> End Sub
>
> ** **
>
> Regards.
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Venkatesan c
> *Envoyé :* vendredi 22 juillet 2011 14:58
> *À :* Google
> *Objet :* Fwd: $$Excel-Macros$$ Login Logout Report Help Required...
>
> ** **
>
> Hi All,
>
> ** **
>
> Any update on this...
>
> ** **
>
> --
>
> ** **
>
> ** **
>
> -- Forwarded message --
> From: *Venkatesan c* 
> Date: Thu, Jul 21, 2011 at 2:36 PM
> Subject: Re: $$Excel-Macros$$ Login Logout Report Help Required...
> To: Google 
> Cc: rajanverma1...@gmail.com, lucky60855 
>
> 
>
> Hi Rajan&Lucky...
>
> ** **
>
> You have Calculated based on  First Login & Last Loguot..
>
> ** **
>
> but I want to get All the Login Logout Calculated..
>
> ** **
>
> For Example:what i am looking for...
>
> ** **
>
>  I Have attached...
>
> ** **
>
> On Thu, Jul 21, 2011 at 1:54 PM, Venkatesan c 
> wrote:
>
> ** **
>
> -- Forwarded message --
> From: *Rajan_Verma* 
> Date: Thu, Jul 21, 2011 at 1:33 PM
> Subject: RE: $$Excel-Macros$$ Login Logout Report Help Required...
> To: excel-macros@googlegroups.com
>
> 
>
> *See if it help*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkatesan c
> *Sent:* Thursday, July 21, 2011 10:35 AM
> *To:* Google
> *Subject:* $$Excel-Macros$$ Login Logout Report Help Required...
>
>  
>
> Dear All,
>
>  
>
> I Have attached data sheet with Login Logout timings..i want how much time
> they were in work...Pure Login hrs
>
>  
>
> have tried one formula...it's working for  first 2 Employess not working
> for all...
>
>  
>
> Please suggest any formula or VBA code...
> 
>
> Example:
>
> Data:
>
> User Name
>
> Status
>
> Login & Logout Time
>
> amnp_26990
>
> Log Out
>
> 7:15:23 PM
>
> amnp_26990
>
> Log Out
>
> 7:15:23 PM
>
> amnp_26990
>
> Log Out
>
> 7:15:23 PM
>
> amnp_26990
>
> Log In
>
> 10:12:12 AM
>
> amnp_26990
>
> Log In
>
> 10:12:12 AM
>
> amnp_26990
>
> Log In
>
> 10:12:12 AM
>
>
> -- 
>
> Required:
>
>  
>
> Total Login Hrs: 
>
> 09:33.0
>
>  
>
> *Best Regards,*
>
> *Venkat*
>
>  
>
>  
>
>  
>
>  
>
> --
>
> --
> 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://w

Re: $$Excel-Macros$$ Urgent Help needed-Dashboards

[Venkatesan c]

Hi  Avinash,

Try below Links,

http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html

-- 
*Best Regards,*
*Venkat*
*
*

On Thu, Jul 21, 2011 at 5:49 PM, Aindril De  wrote:

> Hi Avinash,
>
> Try this:
>
> http://www.freeexceldashboards.com/exceldashboardtemplates.html
>
> Cheers,
> Andy
>
> On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil 
> wrote:
>
>> Hi Masters,
>>
>> can anybody please forward me excel dashboard designs i need dashboard
>> designs with all automations and vba work like drop downs , charts, graphs
>> "a dashboard with full graphical and customization interface"
>>
>> i'll be realy greatfull to you guys please forward me the designs,
>>
>> Regards,
>>
>> Avinash
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Unified Learning Pvt Ltd.
> Ph: 9811300157
>
>  --
>
> --
> 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$$ Change e-mail settings

[Venkatesan c]

Hi,

Just Go to Below link and sign in your Gmail account..and set as a

https://groups.google.com/group/excel-macros/subscribe?hl=en

and go to Edit my membership --->Email *(Approximately 15 emails per day)*Send
each message to me as it arrives

and save it...

-- 
*Best Regards,*
*Venkat*
*
*

On Wed, Jul 20, 2011 at 10:46 PM, Dan Little wrote:

> How do I edit my preferences such that I do not receive a message everytime
> someone posts a discussion with $$Excel-Macros$$ tagged?
>
> H3lue
>
> --
>
> --
> 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$$ Login Logout Report Help Required...

[Venkatesan c]

Dear All,

I Have attached data sheet with Login Logout timings..i want how much time
they were in work...Pure Login hrs

have tried one formula...it's working for  first 2 Employess not working for
all...

Please suggest any formula or VBA code...
Example:
Data:
User Name Status Login & Logout Time amnp_26990 Log Out 7:15:23 PM
amnp_26990 Log Out 7:15:23 PM amnp_26990 Log Out 7:15:23 PM amnp_26990 Log
In 10:12:12 AM amnp_26990 Log In 10:12:12 AM amnp_26990 Log In 10:12:12 AM

-- 
Required:

Total Login Hrs:   09:33.0
**
*Best Regards,*
*Venkat*
*
*
*
*

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


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

Re: $$Excel-Macros$$ Books

[Venkatesan c]

Hi,

Check The Below link
http://www.mrexcel.com/articles.shtml#Charts

-- 
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 19, 2011 at 11:37 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> I need a book about graphs/charts only. Thanks!
>
> On Wed, Jul 13, 2011 at 7:15 PM, Vikas Chouhan wrote:
>
>> *Hey,
>>
>> Please find the below mention link for  Microsoft Excel 2077 VBA Macro
>> Programming 2009*
>>
>>
>>
>> http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
>> *
>> Regards, Vikas Chauhan*
>>
>>
>> On Wed, Jul 13, 2011 at 3:46 PM, jmothilal  wrote:
>>
>>> if any one have pdf file pls send me
>>>
>>> J.Mothilal
>>>
>>>
>>> On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 I need book for learning chart itself. If anything is there pls send it
 to me.

 Thanks,

 Chandra Shekar B

   On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma <
 rajanverma1...@gmail.com> wrote:

>  *Here are some good books name which are free on internet ..*
>
> * *
>
> *VBA and Macros Microsoft Excel 2010 (MrExcel Library)*
>
> *VBA  Beginner How To  Computer Programming Concepts and Visual Basic*
>
> *Excel_2007_VBA_Programming_for_Dummies*
>
> *Excel Programming WIth VBA and .Net*
>
> *Excel Programming Absalute Bigginers*
>
> *Excel Power Programming 2003 With VBA*
>
> *Excel 2007 Power Programming With VBA*
>
> * *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, July 13, 2011 12:10 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Books
>
> ** **
>
> Hi,
>
>  
>
> Can anyone suggest which book will be the best ot learn Charts (Like
> Bullet Chart and Doughnut chart with Indication). If anyone have ebook
> please post it. Thanks!.
>
>  
>
> Regards,
>
>  
>
> Chandra Shekar B
>
> --
>
> --
> 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

>>>
>>>
>>>
>>> --
>>> J.Mohilal
>>> Universal Computer Systems
>>> # 16, Brindavan Complex
>>> Otteri, Vellore-2
>>>
>>> --
>>>
>>> --
>>> 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. Ex

Re: $$Excel-Macros$$ Speedo Meter Chart

[Venkatesan c]

Hi ,

Please Look below Link

http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm

*Best Regards,*
*Venkat*

On Tue, Jul 19, 2011 at 11:36 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Any suggestion please.
>
> On Mon, Jul 18, 2011 at 2:31 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> I am doing speedo meter chart File name: Speedometer_1 but I am not
>> getting output as Filename: Speedo_FDF0OKZGD1F4SBI which has taken from site
>> http://www.instructables.com/id/Speedometer-Graph-in-Excel/step1/Finally/.
>> May I know what is the problem in it.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

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

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

$$Excel-Macros$$ Job

[Venkatesan c]

From:""iGATE Global Solutions""< supreet.sa...@igatepatni.com >
Date: 18 Jul 11 20:41:03
Subject: iGate Patni hiring Senior Team Leads for WFM-Forecasting_Bangalore
location
To: 

Job Location: Bengaluru/Bangalore

Dear Candidate,

We have few openings in BPO division.Please find details:


Work location:Bangalore

Role:Senior Team Lead


Job Description:


•Candidate should have good exposure to Call center environment,

•Should have at-least 3-4 years of experience working in Call centers.

•Tool knowledge of Aspect is a must.

•Hands on experience in Forecasting.

•Should be able to work on Long Range, Medium Range and Short Range
Forecasting.

•Sound understanding of FTE and headcount information.

•Banking experience and working with North American centers will be an
added advantage.

•Strong experience in excel.


Please send your resumes as soon as possible and fill in the following
details:


Total Exp

Relevant Exp

Exp in call center

CTC

ECTC

Notice Period


Regards

Supreet Sarna

supreet.sa...@igatepatni.com


*Best Regards,*
*Venkat*
*
*
*
*

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

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

Re: $$Excel-Macros$$ Re: Check Boxs on Document

[Venkatesan c]

Please Attach There is No Attachment...

*Best Regards,*
*Venkat*
*
*

On Mon, Jul 18, 2011 at 11:48 AM, Rsh  wrote:

> Please help me in reducing the code in the attachment above..
>
> Thnx in advance
>
>  --
>
> --
> 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$$ Simple Code

[Venkatesan c]

Hi sharad,

look attached..it may Help you...

-- 
*Best Regards,*
*Venkat*
*
*


On Sun, Jul 17, 2011 at 5:22 PM, sharad jain  wrote:

> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I put
> 27 in A1, it should result in 30 in B1. For 25, it should result in 30.
>
> Thanks in advance.
>
> Best,
> Sharad
>
> --
>
> --
> 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


Round Query Resolved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ MS Access

[Venkatesan c]

Hi Siva,

You Can Post your MS Access Query's in this group it self...
*
*
*Best Regards,*
*Venkat*


On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote:

> Hi Smarts,
>
> Good day..
>
> Could you send me googlegroup id for MS Access..
>
> --
> Thanks
> Siva
>
> --
>
> --
> 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$$ Need Formula

[Venkatesan c]

Hi Rahim,

Look attached file .


 *Best Regards,*
*Venkat*



On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff
wrote:

> Hi Experts,
>
> Please refer the attached workbook.
>
> The first sheet here "Schedule" gives the training requirements and
> Training batches, and the second sheet "Training Planner" needs to be
> updated based on this.
>
> I need a formula to be entered in "D4" that will give me the results as
> show in the "Training Planner" sheet. The formula should be such that we
> should copy across and down to give the results as shown.
>
> Thanks in advance.
>
>
> --
> Thanks & Regards,
> Rahim Sharieff
>
> --
>
> --
> 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


Training Planner Resolved Venkat.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Regression Analysis in Excel

[Venkatesan c]

Thank u  So much

*Best Regards,*
*Venkat*
*
*
On Fri, Jul 15, 2011 at 6:12 AM, STDEV(i)  wrote:

> visit ..
> http://phoenix.phys.clemson.edu/tutorials/excel/regression.html
> http://mallit.fr.umn.edu/fr4218/assigns/excel_reg.html
> http://www.chem.orst.edu/courses/ch361-464/ch464/RegrssnFnl.pdf
>
> http://faculty.fuqua.duke.edu/~pecklund/ExcelReview/Use%20Excel%202007%20Regression.pdf
> http://cameron.econ.ucdavis.edu/excel/ex61multipleregression.html
> http://www.youtube.com/watch?v=lTNyalLBZo0
> http://www.law.uchicago.edu/files/files/20.Sykes_.Regression.pdf
> http://en.wikipedia.org/wiki/Regression_analysis
>
> http://office.microsoft.com/en-us/excel-help/perform-a-regression-analysis-HA00963.aspx
>
>
>
> On Thu, Jul 14, 2011 at 2:49 PM, Venkatesan c wrote:
>
>> Dear All,
>> Can any one help me on Regression Analysis in Excel with sample data..
>> *Best Regards,*
>>  *Venkat*
>> *
>> *
>>
>  --
>
> --
> 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$$ Regression Analysis in Excel

[Venkatesan c]

Dear All,

Can any one help me on Regression Analysis in Excel with sample data..


*Best Regards,*
*Venkat*
*
*
*
*

-- 
--
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$$ Vlookup Regarding Query Please Help

[Venkatesan c]

Hi Jai,

Look Attached below..




On Wed, Jul 6, 2011 at 2:19 PM, Jai  wrote:

> --
>
> --
> 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,*
*Venkat*
*
*
*
*

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


VLOOKUP  Resolved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Venkatesan c]

Congrats  *Ashish,*
*
*
*
*
-- 
*Best Regards,*
*Venkat*
*
*



On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel  wrote:

> Congratulation Ashish...You deserve it
>
> Kalyan
>
>
> On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal  wrote:
>
>>  [image:
>> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6543&referrer=-&urlaction=r...]Congratulations
>> *Ashish*, you deserve it.[image:
>> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6548&referrer=-&urlaction=r...]
>>
>>
>> Best regards,
>>
>>
>>
>> *Ahmed galal Mohamed*
>>
>> Procurement Engineer
>>
>> Head Office : SQUARE Engineering Firm
>> Tel   :(202) 2402 8846
>> Fax  :(202) 2405 0476
>> Mobile :(010) 9 62 60 61
>> Website : http://www.square.com.eg
>> 31 Lebanon St. Mohandsen, Giza, Egypt
>>
>>
>>
>>
>>
>>  --
>> From: jainayus...@gmail.com
>> Date: Mon, 4 Jul 2011 22:48:33 +0530
>> Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
>> To: excel-macros@googlegroups.com
>>
>>
>>   Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>> June'11
>> He has posted 53 posts in June 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and
>> achieved this recognition from last seven months consecutively.This is
>> really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
>> contribution.
>>
>>
>>Thanks to Rajan, Venkat and other folks for helping excel enthusiasts
>> !! keep it up !!
>>
>>Let see who becomes next MVP..
>>
>>Keep posting.
>>
>>
>>  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
>>
>> --
>>
>> --
>> 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$$ workbook location on status bar

[Venkatesan c]

Pascal,

Yes  you are right

I have said for 2007 &2010 Version...


*Best Regards,*
*Venkat*
*
*

On Tue, Jul 5, 2011 at 4:05 AM, netuser501  wrote:

> thanx,
>
> Venkat solution is most practical for 2007 since it works on all
> workbooks that work and don't work with vba code.
> I guess the vba code for this is for Excel 2003?
>
> Pascal
>
> --
>
> --
> 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$$ copy data without opening file

[Venkatesan c]

Hi,

Just Try Copy &Paste it will work...

*Best Regards,*
*Venkat*
*
*

On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote:

> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> 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$$ Recovery plz

[Venkatesan c]

Hi

just install the  software and just open that software and click Remove
Password...Before that you have to open

Locked VBA Book..

-- 
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar  wrote:

> How to use this software?
>
> Thanks,
>
> Chandra Shekar B
>
> On Fri, Dec 24, 2010 at 11:56 AM, Venkat  wrote:
>
>> Dear Saijt,
>>
>> Find below Link&Download Software &Install,It may Help you...
>>
>> http://www.excel-tool.com/vbarecovery.html
>>
>> *Best Regards,*
>> **
>> *Venkat CV*
>>
>> On Thu, Dec 23, 2010 at 12:42 PM, Vikas Chouhan wrote:
>>
>>> send ur file
>>>
>>> On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote:
>>>
 Dear All,

 I had made a project in excel and some macro made but i had protected
 with password and forget the password.
 How can i recover my VBA password.

 please give me some tips to accomplish my project.

 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> *Best Regards,*
>> *Venkat*
>> ) 91 99414 31925
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/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/discu

Re: $$Excel-Macros$$ count unique values

[Venkatesan c]

Hi,

Attach Some data ..and send will try..


*Best Regards,*
*Venkat*
*
*


On Mon, Jul 4, 2011 at 3:47 PM, airen  wrote:

> Hi,
> i want to count unique values in a selection. I got this formula on
> net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
> know how it works. So please help me understand this formula.
>
> --
>
> --
> 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$$ Assistance required

[Venkatesan c]

Hi Vikas,

Look the Below Link

http://excelvbatutor.com/vba_tutorial.html


*Best Regards,*
*Venkat*
*
*
On Sun, Jul 3, 2011 at 3:39 PM, vikas verma  wrote:

>
> Hi All,
>
> I am good with excel 2007 now I want to learn VBA coding in order to create
> automation tool. Please suggest some ideas.
>
> Thanks & Regards,
>
> Vikas Verma
> Bank of America
> delhi.ve...@gmail.com
>
> 337199
>
>  --
>
> --
> 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$$ Sumif across multiple worksheets

[Venkatesan c]

Dear Susan,

You select all sheets(Group it ) and then try this formula.You may get
result in all sheets


*Best Regards,*
*Venkat*
*
*

On Sat, Jul 2, 2011 at 9:52 PM, Susan  wrote:

> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for the same criteria , and summing
> different ranges.
>
> I tried SUMPRODUCT(SUM(IF...
> I tried SUM(IF and inserting a + before each proceeding IF
>
> Neither of those worked.
>
>
> What about using INDEX?  Thou I am not familiar with that formula...
> also, how about VLOOKUP with SUM?
>
> Thanks for your help.  Can you try to fix it again?
>
> Sunnie :-)
>
> On Jun 30, 11:26 pm, Dilip Pandey  wrote:
> > Hi Sunnie,
> >
> > It can be sorted out using simple SUM function.  Look at the below
> formula:-
> >
> >
> {=SUM(IF(D2:D6=G3,E2:E6,""),IF(Sheet3!D11:D18=G3,Sheet3!E11:E18,""),IF(Sheet2!D13:D23=G3,Sheet2!E13:E23,""))}
> >
> > It is an array formula, hence needs to be entered using key
> > combination Ctrl+Shift+Enter.
> >
> > Nesting can be an issue if you use more references here.
> >
> > Let me know if this works.
> >
> > Thanks,
> > DILIPandey
> >
> > On 7/1/11, Susan 1  wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > Hi,
> > > I cannot figure out Excel won't let me select different ranges from
> multiple
> > > worksheets with same criteria ??
> >
> > > =SUMIF(D2:D6,"C Wagner",E2:E6)
> >
> > > This is what I'd like it to do:
> >
> > > =SUMIF(Sheet1!D2:D6,Sheet3!D11:D18,Sheet2!D13:D23,"C
> > > Wagner",Sheet1!E2:E6+Sheet3!E11:E18+Sheet2!E13:E23)
> >
> > > I receive error:  I've entered few too arguments.
> > > I did a search and found out that SUMIF cannot sum across multiple
> > > worksheets like SUM can... why?
> >
> > > Can you help me?  Should I use VLOOKUP with SUM?
> >
> > > thanks,
> > > Sunnie
> >
> > > --
> > >
> --
> > > 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
> >
> > --
> > Thanks & Regards,
> >
> > DILIP KUMAR PANDEY, mvp
> >MBA,B.Com(Hons),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 62, India
> >
> >  Fall_Session_Data(2).xls
> > 68KViewDownload
>
> --
>
> --
> 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$$ I want to learn VBA

[Venkatesan c]

Hi Ankur,

Nice Sharing...Good stuff thank u so much...

*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 3:17 PM, ankur  wrote:

> hi kurikkal
> get files from the link below, i had uploaded there. i tried to
> attach files but due to excess size of files, it cant be attached .
>
> http://cmaankur.webs.com/apps/documents/
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Sat, Jul 2, 2011 at 1:02 PM, ankur  wrote:
> > hi kurikkal
> > have this file..
> > Have A Nice Time & Enjoy Life
> >
> > Regards:
> > CMA Ankur Pandey
> > (Someone Different)
> >
> > I'm not the best but i'm not like the rest~~
> >
> >
> >
> > On Sat, Jul 2, 2011 at 12:54 PM, ankur  wrote:
> >> hi kurikkal
> >> have this files...
> >> Have A Nice Time & Enjoy Life
> >>
> >> Regards:
> >> CMA Ankur Pandey
> >> (Someone Different)
> >>
> >> I'm not the best but i'm not like the rest~~
> >>
> >>
> >>
> >> On Fri, Jul 1, 2011 at 9:24 PM, ashish koul 
> wrote:
> >>> try thse video tutorial and websites
> >>> http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
> >>>
> http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
> >>>
> >>>
> >>> On Fri, Jul 1, 2011 at 1:34 PM, kurikkal padinjarappalla
> >>>  wrote:
> >>>>
> >>>> please attach it
> >>>>
> >>>> On Fri, Jul 1, 2011 at 10:43 AM, ankur 
> wrote:
> >>>>>
> >>>>> Dear friends
> >>>>> I m agree that , the sites you all recommended are very useful ,but
> >>>>> for a new user , the best way to learn VBA is getting a book
> dedicated
> >>>>> on vba...becoz they provide step wise and detailed concepts 
> >>>>> there are many free ebooks on vba on the internet.download it
> >>>>> ...learn basic from there ...and then make reference from this sites
> >>>>> to learn more...
> >>>>> i have books if u need  i can attach here...
> >>>>>
> >>>>> Have A Nice Time & Enjoy Life
> >>>>>
> >>>>> Regards:
> >>>>> CMA Ankur Pandey
> >>>>> (Someone Different)
> >>>>>
> >>>>> I'm not the best but i'm not like the rest~~
> >>>>>
> >>>>>
> >>>>>
> >>>>> On Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c  >
> >>>>> wrote:
> >>>>> >
> >>>>> >
> >>>>> > Hi Pooja,
> >>>>> > Just watch the below link Youtube video's you may get VBA
> >>>>> > Basic&Advancedconcepts
> >>>>> > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
> >>>>> >
> >>>>> > Best Regards,
> >>>>> > Venkat
> >>>>> >
> >>>>> > On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma
> >>>>> > 
> >>>>> > wrote:
> >>>>> >>
> >>>>> >> Hi All,
> >>>>> >>
> >>>>> >> I want to learn VBA, therefore, could anybody suggest with a good
> link
> >>>>> >> where I can learn it.
> >>>>> >>
> >>>>> >> --
> >>>>> >> Best Regards
> >>>>> >> Pooja Sharma
> >>>>> >>
> >>>>> >> --
> >>>>> >>
> >>>>> >>
> >>>>> >>
> --
> >>>>> >> 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
> >>>>&

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[Venkatesan c]

*Dear Asish,*
*
*
*Congrats...*
*
*
*Best Regards,*
*Venkat*
*
*

On Fri, Jul 1, 2011 at 9:25 PM, Ayush  wrote:

> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest
> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
> his exceptional MS Excel skills and voluntary contribution.
> He is well deserving for the award and I am very happy and proud of his
> recognition. The guy has been top poster in the group from last 7-8 months.
>  Let see who becomes the next MVP from the group. The group has now three
> active MVPs.
>
> Dear Ashish,
> Many Many congratulations for the award.I am very proud of you to be part
> of this group.
> Keep your valuable contribution to the group. I wish your long association
> with this group.
> Cheers !!
> Best 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
>



-- 
*
*
*
*

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

Fwd: $$Excel-Macros$$ I want to learn VBA

[Venkatesan c]

Hi Pooja,

Just watch the below link Youtube video's you may get VBA
Basic&Advancedconcepts

http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb


*Best Regards,*
*Venkat*
 *
*

On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote:

> Hi All,
>
> I want to learn VBA, therefore, could anybody suggest with a good link
> where I can learn it.
>
> --
> *Best Regards
> Pooja Sharma*
>
> --
>
> --
> 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,*
*Venkat*
*
*
*
*

-- 
--
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$$ I want to learn VBA

[Venkatesan c]

Hi Pooja,

Just watch the below link Youtube video's you may get VBA
Basic&Advancedconcepts

*Best Regards,*
*Venkat*
*
*

On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote:

> Hi All,
>
> I want to learn VBA, therefore, could anybody suggest with a good link
> where I can learn it.
>
> --
> *Best Regards
> Pooja Sharma*
>
> --
>
> --
> 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$$ How To Concatenate the Cell without loosing the format

[Venkatesan c]

Hi Ak,

Find attached your query resolved

 *Best Regards,*
*Venkat*


On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari  wrote:

> Hi Experts,
>
>
>
> I want to concatenate the different cells without losing the format of the
> cells. Please refer the excel sheet for more details.
>
> Thanking you in Advance.
>
>
>
> Regards,
>
> AK
>
> --
>
> --
> 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


Concatenation Question Resolved.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007

[Venkatesan c]

Dear Gyana,

Download the below link application and install you can remove VBA
Password..


*http://www.box.net/shared/eyqmr4v0sy74gonoxokj*


*Best Regards,*
*Venkat*
*
*

On Wed, Jun 29, 2011 at 4:25 AM, Gyana Ranjan Das wrote:

> Dear All,
>
> Last night I made some changes in our Process MI Report through VBA code.
> Today as per process requirement I need to change something but I forgot
> the VBA password.
>
> Is there  any way to resolve the problem means to disable the password to
> view the code.
>
> *
> Thanks & Regards,
> Gyana
> *
>
> On Tue, Jun 28, 2011 at 3:38 PM, SANJAY SONI 
> wrote:
>
>> Dear Venkar,
>>
>> I think the attached file can resolve your problem..It will remove your
>> passward.
>>
>> *
>>  Best Regards,
>> *
>> *Sanjay **
>>   *
>> **
>>   *From:* Venkatesan c 
>> *To:* Google 
>> *Sent:* Tuesday, 28 June 2011 11:07 AM
>> *Subject:* $$Excel-Macros$$ Unprotect Sheet in Excel 2007
>>
>> Dear All,
>>
>> I want any VBA code or some tool to Unprotect Sheet in Excel 2007
>>
>> I forgot the password..
>>
>>
>>  *Best Regards,*
>> *Venkat*
>> *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> 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$$ Single Pivot from More than one worksheet

[Venkatesan c]

Hi Shelly,

works in All versions of Excel 2010, 2007,2003...2000...

Best Regards,

Venkat...


On Tue, Jun 28, 2011 at 6:59 PM, Shelly Mehta  wrote:

> Hey Venkat,
> It was very interesting. Can u pls. let me know whether it works in Office
> 2007 as i was not able to figure this out.
>
> Thanks !!
>
> On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c wrote:
>
>> Hi Deepak,
>>
>> Find attached html file .for your queryYou prepare single pivot from
>> more than one.data
>>
>> *Best Regards,*
>> *Venkat*
>>   On Tue, Jun 28, 2011 at 10:21 AM, dpk  wrote:
>>
>>> Hi,
>>>
>>> any body help me , for prepare single pivot from more than one
>>> worksheet.
>>>
>>> regrds
>>>
>>> deepak
>>>
>>> --
>>>
>>> --
>>> 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
>



-- 
*Best Regards,*
*Venkat*
*
*
*
*

-- 
--
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$$ Unprotect Sheet in Excel 2007

[Venkatesan c]

Dear Noorain,

Working Thank u So much...

*Best Regards,*
*Venkat*

On Tue, Jun 28, 2011 at 12:33 PM, NOORAIN ANSARI
wrote:

> Dear Venkat.,
>
> Please find & use below VBA code to Unprotect sheet in EXCEL 2007
>
> Procedure : Press alt+F11
>   Insert-Module then Paste below code
>   Press-F5 to run
>
>
>
> Sub PasswordBreaker()
>
>   Dim i As Integer, j As Integer, k As Integer
>   Dim l As Integer, m As Integer, n As Integer
>   Dim i1 As Integer, i2 As Integer, i3 As Integer
>   Dim i4 As Integer, i5 As Integer, i6 As Integer
>
>   On Error Resume Next
>   For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
>   For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
>   For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
>   For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
>
>
> ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
>   Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
>   Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
>   If ActiveSheet.ProtectContents = False Then
>   MsgBox "One usable password is " & Chr(i) & Chr(j) & _
>   Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
>   Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
>ActiveWorkbook.Sheets(1).Select
>Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
>   Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
>   Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
>Exit Sub
>   End If
>   Next: Next: Next: Next: Next: Next
>   Next: Next: Next: Next: Next: Next
>
> End Sub
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>
>
> On Tue, Jun 28, 2011 at 11:07 AM, Venkatesan c wrote:
>
>> Dear All,
>>
>> I want any VBA code or some tool to Unprotect Sheet in Excel 2007
>>
>> I forgot the password..
>>
>>
>>  *Best Regards,*
>> *Venkat*
>> *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> 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$$ Unprotect Sheet in Excel 2007

[Venkatesan c]

Dear All,

I want any VBA code or some tool to Unprotect Sheet in Excel 2007

I forgot the password..


*Best Regards,*
*Venkat*
*
*
*
*

-- 
--
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$$ HaPpY BirthdaY - Sir Paul Schreiner

[Venkatesan c]

*

Dear Paul,
**

Happy Birthday Wishes to you
*

-- 
*Best Regards,*
*Venkat*
*
*

On Mon, Jun 27, 2011 at 8:30 AM, OpenExcel.com <26may.1...@gmail.com> wrote:

> Wish you many many Happy Returns of the Day :) Enjoy :)
>
> HappY BirthdaY :)
>
>
> Best Regards
> Ashish Jain
> eXceLiTems 
>
> --
>
> --
> 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$$ Help on Percentile Function

[Venkatesan c]

Dear Prashant,

Please look below links...

http://www.techonthenet.com/excel/formulas/percentile.php
http://office.microsoft.com/en-us/excel-help/percentile-HP005209211.aspx

*Best Regards,*
*Venkat*
*
*

On Mon, Jun 20, 2011 at 6:16 PM, Prashant  wrote:

>  Dear Experts,
>
> ** **
>
> Need help on how to arrive a percentile for large data , attached sample
> file & manual working 
>
> ** **
>
> Regards,
>
> ** **
>
> Prashant
>
> --
>
> --
> 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$$ Call Center Inbound&Outbound Manpower scheduling

[Venkatesan c]

Dear All,

Can any one have templates or websites for Call Center Inbound&Outbound
Manpower  scheduling.

-- 
*Best Regards,*
*Venkat*
*
*
*
*

-- 
--
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$$ HELP NEEDED FOR FORMULA

[Venkatesan c]

Hari,

Find attached 

 *Best Regards,*
*Venkat*
*
*
*Join My Group:
http://groups.google.com/group/excel-miracle
*

On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR  wrote:

> I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
> THANKS IN ADVANCE..
>
> HARI
>
> --
>
> --
> 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


Hari Query Resolved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to record a macro

[Venkatesan c]

Dear Ritesh,

Watch Below Link

http://www.youtube.com/watch?v=KKJj78LoFaA

On Sat, Jun 18, 2011 at 8:20 PM, Susan  wrote:

> http://www.excel-vba-easy.com/
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Ritesh Jain
> Sent: Saturday, June 04, 2011 12:57 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ How to record a macro
>
> Dear Friends,
>
> Can somebody please guide me on how to record macros in excel?
>
> Regards,
> Ritesh 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
>
> --
>
> --
> 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,*
*Venkat*
*
*
*Join My Group:
http://groups.google.com/group/excel-miracle
*

-- 
--
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$$ Beginer to Excel-VBA

[Venkatesan c]

On Fri, Jun 17, 2011 at 6:00 AM, Venkatesan c  wrote:

> Dear Hari,
>
> Just watch the below link video's you may get Some of basics in Excel  VBA
>
> http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
>
> Best Regards,
>
> Venkat
>
>
> On Thu, Jun 16, 2011 at 8:35 PM, Hari  wrote:
>
>>
>>  Dear Friends,
>>Can any one please help me in *"how to learn Excel-VBA"* through some
>> tutorial materials as i am CA Final student.
>>
>>
>> -
>> Yours,
>>
>> Hari.
>>
>> --
>>
>> --
>> 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,*
> *Venkat*
>
>
>


-- 
*Best Regards,*
*Venkat*

-- 
--
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$$ Pad zeros

[Venkatesan c]

Hi Skanda,

Please use Below formula for our query.
 =REPT(0,(9-LEN(B4)))&B4

*Best Regards,*
*Venkat*

On Fri, Jun 17, 2011 at 3:46 AM, Skanda  wrote:

> Hi,
>   How to add zeros in front of a value with varying lengths so that the
> length of the column is 9?
> for instance a column policy id has values with varying lengths as follows:
>
>  Policyid:
>  745689
> 2346789
>
>
> so i need to transform the above policyid to:
> 000745689
> 002346789
>
>
> --
>
> --
> 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,*
*Venkat*

-- 
--
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$$ Beginer to Excel-VBA

[Venkatesan c]

Dear Hari,

Just watch the below link video's you may get Some of basics in Excel  VBA

http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb

Best Regards,

Venkat

On Thu, Jun 16, 2011 at 8:35 PM, Hari  wrote:

>
> Dear Friends,
>Can any one please help me in *"how to learn Excel-VBA"* through some
> tutorial materials as i am CA Final student.
>
>
> -
> Yours,
>
> Hari.
>
> --
>
> --
> 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,*
*Venkat*

-- 
--
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$$ excel query

[Venkatesan c]

Hi Azeema,

Send the sample data and some one will assist the query..

Best Regards,

Venkat..



On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa  wrote:

> I have a table in excel of # of employees by age, sex and category of
> employment. The ROWs have three diff categories by sex and the COLUMNS
> have age (5 10-year age groups). Each cell provides the number
> (frequency) of employee for a particular age group and job category
> and sex!! I would like to convert the this TABLE to a data format, ie,
> I want to have age categories, sex, employment category all in columns
> and also break down the frequency to a single case, ie each row for
> each employee...  Is there any way to do it in excel?
>
> thanks.
>
> azeema
>
> --
>
> --
> 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,*
*Venkat*
) 91 99414 31925

-- 
--
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$$ how to put password in vba coding.??

[Venkatesan c]

Hi Kannan,

Please go to Module--->VBA Project Properties--->Protection--->Give
Password

The above way is to protect VBA Project...

*Best Regards,*
*Venkat*
On Wed, Jun 15, 2011 at 2:09 PM, kannan excel wrote:

> Hi Guru...
>
> how to put password in vba coding.??
>
> how to protect that?
>
> regards
>
> Kannan V
> 9941077703
> onechennaiproperty.com
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*

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

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

$$Excel-Macros$$ Excel Tips&Tricks Video's Link...

[Venkatesan c]

Dear All,

Please watch below link in YouTube you may get hundreds of Excel Tips
&Tricks... With Excel Sample Excel Workbooks Also
[image: image.png]
*http://www.youtube.com/user/ExcelIsFun?blend=1&ob=5*
*
*
*Best Regards,*
*Venkat*

-- 
--
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$$ Index, Match, Vlookup Memory Cards [Free downloads]

[Venkatesan c]

Dear Ayush,

Thank for good share of tutorial

Regards,
Venkat


On Fri, Jun 10, 2011 at 10:13 PM, Ayush  wrote:

> Well, he's done it again. My good friend John Franco just uploaded these free
> lookup syntax mastery 
> downloadsfor you.
> To be honest, these are AWESOME. These will ensure that you understand and
> REMEMBER the syntax for Index, Match, and Vlookup.
>
> I really think you should download these because they are great tangible
> resources that you can use TODAY at your office.
> Watch the video and get the 
> downloadsNOW
>
> He also provides a POWERFUL analogy in his video that makes it easy to see
> the logic of these formulas.
> You can get all the goodiesHERE
>
> Warm 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
>



-- 
*Best Regards,*
*Venkat*
) 91 99414 31925

-- 
--
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$$ SQL Server Group

[Venkatesan c]

Dear All,

I want SQL Server Group something like our excel-macros group.

Can anyone send me the links..

Thanks in Advance..

*Best Regards,*
*Venkat*

-- 
--
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@googlegroups.com

[Venkatesan c]

Thank U 

On Mon, Feb 21, 2011 at 12:35 PM, saggi  wrote:

> Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path
> of SQL table this exercise need to done once.
>
> after onward same u can pull from Existing Connection just need to
> given Username & Password.
>
> Regards
> Vijay
>
> --
>
> --
> 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,*
*Venkat*
) 91 99414 31925

-- 
--
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@googlegroups.com

[Venkatesan c]

Thank U

On Sun, Feb 20, 2011 at 12:55 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:

> Hi Venkatesh,
>
> Install SQL DTS (Data transformation services) available in microsoft
> download center for export and importing the data from SSIS.
>
> Do revert if any clarification on the same.
>
>
>
> On Sat, Feb 19, 2011 at 2:59 AM, Venkatesan c wrote:
>
>> Dear All,
>>
>> I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help
>> on this.
>> --
>> *Regards,*
>> *Venkat*
>>
>>
>> --
>>
>> --
>> 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
> Yogananda Muthaiah
> Ph : 973 123 7267
>
>
> --
>
> --
> 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,*
*Venkat*
) 91 99414 31925

-- 
--
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@googlegroups.com

[Venkatesan c]

Dear All,

I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help
on this.
-- 
*Regards,*
*Venkat*

-- 
--
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$$ Help Required Making Data into Muliple sheets

[Venkatesan c]

Dear Siti,

Thanks a lot


Best Regards,

Venkat


On Fri, Sep 24, 2010 at 3:47 PM, siti Vi  wrote:

> Sub splittabel()
> ' siti Vi / jakarta, 24 sept 2010
> Dim RefTbl As Range
> Dim DesTbl As Range
> Dim sNames As String, ArrNames
> Dim r As Long, n As Long, i As Long, c As Integer
>
> Set RefTbl = Sheets("RAW Data").Cells(1, 1).CurrentRegion
>
> ' creating unique list of Names
> For r = 2 To RefTbl.Rows.Count
>If InStr(1, sNames, RefTbl(r, 6) & "|") = 0 Then
>   sNames = sNames & RefTbl(r, 6) & "|"
>End If
> Next
> ArrNames = Split(sNames, "|")
>
> ' creating new sheet/table
> For i = LBound(ArrNames) To UBound(ArrNames) - 1
>Sheets.Add after:=Sheets(Sheets.Count)
>ActiveSheet.Name = ArrNames(i)
>RefTbl.Resize(1, RefTbl.Columns.Count).Copy ActiveSheet.Range("A1")
>n = 1
>For r = 2 To RefTbl.Rows.Count
>   If RefTbl(r, 6) = ArrNames(i) Then
>  n = n + 1
>  RefTbl(r, 1).Resize(1, RefTbl.Columns.Count).Copy
>  Cells(n, 1).PasteSpecial xlPasteValuesAndNumberFormats
>   End If
>Next r
>Application.CutCopyMode = False
> Next i
>
> End Sub
>
>
>
> On Thu, Sep 23, 2010 at 5:03 PM, Venkatesan c wrote:
>
>> Dear Group,
>>
>> I have attached file containes data i want to split based on *Exe Name* In
>> Muliple sheets by using macro's i have attached sample data & Required data
>> also.
>> Best Regards,
>> *Venkat*
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

$$Excel-Macros$$ Re: I love excel because.......

[Venkatesan c]

Dear Group,

Excel is the User friendly Application Compare then all Spread sheets &It's
Very much Easy to Handle New user's Too..


Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ I love excel because.......

[Venkatesan c]

Dear Group,

Excel is the User friendly Application Compare then all Spread sheets &It's
Very much Easy to Handle New user's Too..

*Best Regards,*
**
*Venkat*

On Sat, Aug 28, 2010 at 12:19 PM, Ayush  wrote:

> Its a very handy tool for any data analysis and reporting. - Ayush
> Jain
>
> ---
>
> Guyzzz, Let me know why you like excel so muchThe best response
> will be published on the home page with thanks. Please continue in
> this thread only just below my line I want to see the active
> participation...
>
> Thank u so much.
>
> -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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Help Required ----

[Venkatesan c]

Dear Kalyan,

My Correct Requirement Is Attached below

On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel  wrote:

> Hi venkat,
>
>  VLOOKUP formula will solveyour problem, see the attachment.
>
>   On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote:
>
>> Dear Group,
>>
>> I have attached sample data below i want to get defined criteria Emp id's.
>> Can i have any formula's or Macros
>>
>>  Best Regards,
>> *
>>
>> Venkat
>> *
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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


Help Required Data...1xls.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help Required ----

[Venkatesan c]

Dear Group,

I have attached sample data below i want to get defined criteria Emp id's.
Can i have any formula's or Macros

 Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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


Help Required Data...xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Extract Only Mobile Numbers from the strings--Urgent

[Venkatesan c]

Dear Dave,

Thanks a lot

Best Regards,
*

Venkat
*




On Wed, Aug 18, 2010 at 10:17 AM, Dave Bonallack
wrote:

> Hi,
> Have a look at the attached to se if it does what you need.
> Regards - Dave.
>
> --
> Date: Tue, 17 Aug 2010 22:06:40 +0530
> Subject: Re: $$Excel-Macros$$ Extract Only Mobile Numbers from the
> strings--Urgent
> From: venkat1@gmail.com
>
> To: excel-macros@googlegroups.com
> CC: bhavya...@gmail.com
>
>
> Dear Bhavya Khanna,
>
> I am having diffrent types of strings and i have here  sample below.
>
>   Raw Data Required Cm said on 16th *091* rnr. 091 date
> ofe  on 16th *018* s/o. *018* iaiaiia on 16th *0188811
> * s/o. *0188811* ppfpfpfpfpf on 16th *02008285228* ringing cm
> disconnected the call. *02008285228*
>
> On Tue, Aug 17, 2010 at 8:59 PM, bhavya khanna wrote:
>
>
>
> On Tue, Aug 17, 2010 at 5:31 PM, Venkatesan c wrote:
>
> Dear Group,
> Find the attached data Required.I want to Extract Only Mobile Numbers from
> the strings
>
>Raw Data Required on 16th *091* rnr. 91 on 16th *
> 018* s/o. *018* on 16th *0188811* s/o. *0188811* on
> 16th *02008285228* ringing cm disconnected the call. *02008285228*
>
>
>
>
> Best Regards,
> *
>
> Venkat
> *
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.exc

Re: $$Excel-Macros$$ Extract Only Mobile Numbers from the strings--Urgent

[Venkatesan c]

Dear Bhavya Khanna,

I am having diffrent types of strings and i have here  sample below.

  Raw Data Required Cm said on 16th *091* rnr. 091 date ofe
on 16th *018* s/o. *018* iaiaiia on 16th *0188811* s/o.
*0188811* ppfpfpfpfpf on 16th *02008285228* ringing cm disconnected the
call. *02008285228*

On Tue, Aug 17, 2010 at 8:59 PM, bhavya khanna  wrote:

>
>
> On Tue, Aug 17, 2010 at 5:31 PM, Venkatesan c wrote:
>
>> Dear Group,
>> Find the attached data Required.I want to Extract Only Mobile Numbers from
>> the strings
>>
>>Raw Data Required on 16th *091* rnr. 91 on 16th *
>> 018* s/o. *018* on 16th *0188811* s/o. *0188811* on
>> 16th *02008285228* ringing cm disconnected the call. *02008285228*
>>
>>
>>
>>
>> Best Regards,
>> *
>>
>> Venkat
>> *
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

$$Excel-Macros$$ Extract Only Mobile Numbers from the strings--Urgent

[Venkatesan c]

Dear Group,
Find the attached data Required.I want to Extract Only Mobile Numbers from
the strings

   Raw Data Required on 16th *091* rnr. 91 on 16th *
018* s/o. *018* on 16th *0188811* s/o. *0188811* on
16th *02008285228* ringing cm disconnected the call. *02008285228*




Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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


Help Required.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help Required Extract Numbers

[Venkatesan c]

Dear Group,

Find Below data Requirement.I Want to extract numbers post (_ )Only.
Raw Data Required

Best Regards,
Venkat

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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


Help Required File.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help Reqired Loop in macros

[Venkatesan c]

Dear Group,

What you mean by Loop in Macros&Use .can i have explanation with Example

 Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Formula Help Required Urgent

[Venkatesan c]

Dear Andy,

Thank u




On Fri, Jun 4, 2010 at 3:55 PM, Aindril De  wrote:

> Hi Venkat,
>
> This can be achieved using array formulas in Excel.
> Suggest you to look into the discussion in the attached link that should
> resolve your issue:
> http://www.mrexcel.com/forum/showthread.php?t=312142
>
> Regards,
> Andy
>
>   On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote:
>
>>  Dear Group,
>>
>>
>>
>> Can i have UNIQUEIFS Function its some thing like SUMIFS
>>
>>  Best Regards,
>> *
>>
>> Venkat
>> *
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

$$Excel-Macros$$ Formula Help Required Urgent

[Venkatesan c]

Dear Group,



Can i have UNIQUEIFS Function its some thing like SUMIFS

 Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

[Venkatesan c]

Dear Harmeet Singh,

It s working thanks a lot




On Tue, Jun 1, 2010 at 4:08 PM, Harmeet Singh wrote:

> *Here you go*
> *use mentioned code*
>  *
> *
> *Sub ren()*
> *
> *
> *mo = InputBox("Enter Month number.")*
> *
> *
> *For i = 1 To Application.Worksheets.Count*
> *
> *
> *Sheets(i).Name = Left(Sheets(i).Name, 3) & mo & Right(Sheets(i).Name,
> 3)*
> *Next i*
> *
> *
> *End Sub*
>
>
>
> Warm Regards,
>
> Harmeet Singh
>
> http://www.facebook.com/libraharry
>
>
>
> On Tue, Jun 1, 2010 at 3:07 PM, Venkatesan c wrote:
>
>> Dear Group,
>>
>> I have attached here file for help required.
>>
>> I am having 31 sheets the sheet names contains like 31.05.10,30.05.10,etc
>> . want to change the sheet names Like 31.06.10,30.06.10,etc by using macros
>> automatically
>>
>> is there anything macros please assist me
>>
>>  Best Regards,
>> *
>>
>> Venkat
>> *
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

[Venkatesan c]

Thanks a lot

Jitendra Kr. Verma



On Tue, Jun 1, 2010 at 3:34 PM, Jitendra Kumar Verma <
jitendra.ve...@globallogic.com> wrote:

>  Use this macro to Rename the sheet.
>
>
>
> Sub Renamesheet()
>
>
>
> Dim shtName As String
>
>
>
> For Each sht In ThisWorkbook.Sheets
>
> shtName = sht.Name
>
> shtName = Left(shtName, 2) & Replace(shtName, "05", "06", 3)
>
> sht.Name = shtName
>
>
>
>   Next
>
> End Sub
>
>
>
>
>
> Regards,
>
> *Jitendra Kr. Verma** ***
>  --
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Venkatesan c
> *Sent:* Tuesday, June 01, 2010 3:07 PM
> *To:* Google
> *Subject:* $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired
>
>
>
> Dear Group,
>
> I have attached here file for help required.
>
> I am having 31 sheets the sheet names contains like 31.05.10,30.05.10,etc .
> want to change the sheet names Like 31.06.10,30.06.10,etc by using macros
> automatically
>
> is there anything macros please assist me
>
>  Best Regards,
>
> *Venkat *
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

[Venkatesan c]

Dear Ayush,

Good show

Best Regards,
*

Venkat
*



On Mon, May 24, 2010 at 9:00 AM, Ayush  wrote:

> Dear Group Members,
>
> Finally, after long time we have achieved a milestone of 7000
> members.
>
> I would use this moment to thank each one of you for your contribution
> to the group. This group really helps people on all of their queries
> on excel and macros.
>
> Thanks to all query solvers.you really make a difference in
> group
>
> Keep posting !!
>
> Best 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

$$Excel-Macros$$ Lotus Notes scheduled Future mails Help

[Venkatesan c]

Dear Group

I am using Lotus notes 7.

I want send scheduled Future mails

is there sending Option else any tolls please send it to me.

Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

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

Re: $$Excel-Macros$$ Automation Help required

[Venkatesan c]

Thanks a lot Deepak

Regards
Venkat



On Sat, May 22, 2010 at 9:43 PM, Deepak Rai  wrote:

> Hi Venkat,
>
> Please find the attached File with the solution. I tried my best but could
> not able to paste formula down. After running the macro you just need to
> paste the forlmula down. Hope this will help. Please let me know in case you
> need my assistance.
>
> Regards,
>
> Deepak
>
>   On Sat, May 22, 2010 at 4:21 PM, Venkatesan c wrote:
>
>> Dear Group,
>>
>> I have attached here with help required sample data.I had given input
>> &output required in different sheets.
>>
>> please any one create for this VB Code and let me know
>>
>> Best Regards,
>> *
>>
>> Venkat
>> *
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Automation Help required

[Venkatesan c]

Dear Group,

I have attached here with help required sample data.I had given input
&output required in different sheets.

please any one create for this VB Code and let me know

Best Regards,
*

Venkat
*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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


Automation Help Reqired.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help Reqired Multiple conditions Lookup

[Venkatesan c]

Dear Group,

Any send me with example Multiple conditions Lookup

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Fwd: Macro Help Msg Box

[Venkatesan c]

Dear Group,

Need Assistance for folowing Problam

active cell value is Number(or)text(or)Formula Should show as a msg box by
using Macro


*Thanks & Regards,*
*Venkatesan C*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Fwd: Help Required

[Venkatesan c]

Thank u Dilip

Can i have any pdf with u



On Tue, Apr 13, 2010 at 2:49 PM, Dilip Pandey  wrote:

> Hi Venkatesan,
>
> Up to Excel 2003, go to Tools-> Macro-> Record New Macro.  Now perform some
> actions on excel spreadsheet.  Press Alt + F11 when you are done.  Select
> modue 1 under your workbook's name in left pane and watch out for the code.
> These are the codes which excel has created as per your action(s).  Now it's
> up to you to perform the action and watch the code and by this way you can
> further enhance your understanding.
>
> Alternatively, you can search for "VBA Course for beginners" over internet.
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
>   On Tue, Apr 13, 2010 at 12:27 PM, Venkatesan c wrote:
>
>> Dear Group.
>>
>> Iam the beginner for Excel macros.
>>
>> I want to know what is the procedure to write a macro and kindly provide
>> some examples in excel files
>>
>> *Thanks & Regards,*
>> *Venkat *
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
>

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Fwd: Help Required

[Venkatesan c]

Dear Group.

Iam the beginner for Excel macros.

I want to know what is the procedure to write a macro and kindly provide
some examples in excel files

*Thanks & Regards,*
*Venkat *

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Help Required

[Venkatesan c]

Dear Group,

Please help me to create Function for below Problam & Help books,Procedure
to create udf's

20100312=12-mar-2010

*

Thanks & Regards,

Venkat C*

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Excel Formula Required

[Venkatesan c]

Dear All,

Any one can Assist me attached file query It's something like reverse Lookup

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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

Query.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How to Convert Time to Sec

[Venkatesan c]

8:59:44  into Decemical seconds is there any formula  anyone help me

Thanks & Regards

Venkat

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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Excel Macros Free PDF

[Venkatesan c]

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

$$Excel-Macros$$ Excel Macros Free PDF

[Venkatesan c]

Dear All

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